- Pharo-users - lists.pharo.org

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

by Sean P. DeNigris

vmusulainen wrote > http://pharo.org/news/garage-database I'm also confused. What is the relationship between OpenDBX and Garage? IIRC DBXTalk was the previous name of OpenDBX, right? Maybe an FAQ is in order as the DB-related names seem to be multiplying ;) ----- Cheers, Sean -- View this message in context: http://forum.world.st/Garage-Glorp-PostgreSQL-and-Cursors-tp4840760p4840771… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Aug. 3, 2015

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

by Norbert Hartl

> Am 03.08.2015 um 15:11 schrieb Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com>: > > I'm little bit shy, but what is Garage? http://pharo.org/news/garage-database <http://pharo.org/news/garage-database> Norbert > > 2015-08-03 15:33 GMT+03:00 Tommaso Dal Sasso <tommaso.dalsasso(a)gmail.com <mailto:tommaso.dalsasso@gmail.com>>: > Hello, > > I was trying the version of Glorp ported to Garage, and I must say it > runs smoothly, nice job! > > I am reading large amount of data from a Postgres db, and I was curious > about the use of cursors. > I remember that the old version of Glorp for Pharo did not support > cursors in Postgresql, has this changed in Garage? > > I tried to run some tests, using a query like: > > (Query readManyOf: MyClass) > collectionType: GlorpCursoredStream; > yourself. > > but with a large number of rows (~300k), the whole image crashes. > > Is this still not supported, or am I doing something wrong? > > Thanks, > Tommaso > >

Aug. 3, 2015

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

by Alexandre Bergel

> I'm little bit shy, but what is Garage? Good question! Alexandre > > 2015-08-03 15:33 GMT+03:00 Tommaso Dal Sasso <tommaso.dalsasso(a)gmail.com <mailto:tommaso.dalsasso@gmail.com>>: > Hello, > > I was trying the version of Glorp ported to Garage, and I must say it > runs smoothly, nice job! > > I am reading large amount of data from a Postgres db, and I was curious > about the use of cursors. > I remember that the old version of Glorp for Pharo did not support > cursors in Postgresql, has this changed in Garage? > > I tried to run some tests, using a query like: > > (Query readManyOf: MyClass) > collectionType: GlorpCursoredStream; > yourself. > > but with a large number of rows (~300k), the whole image crashes. > > Is this still not supported, or am I doing something wrong? > > Thanks, > Tommaso > >

Aug. 3, 2015

Re: [Pharo-users] Garage, Glorp, PostgreSQL and Cursors

by Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾

I'm little bit shy, but what is Garage? 2015-08-03 15:33 GMT+03:00 Tommaso Dal Sasso <tommaso.dalsasso(a)gmail.com>: > Hello, > > I was trying the version of Glorp ported to Garage, and I must say it > runs smoothly, nice job! > > I am reading large amount of data from a Postgres db, and I was curious > about the use of cursors. > I remember that the old version of Glorp for Pharo did not support > cursors in Postgresql, has this changed in Garage? > > I tried to run some tests, using a query like: > > (Query readManyOf: MyClass) > collectionType: GlorpCursoredStream; > yourself. > > but with a large number of rows (~300k), the whole image crashes. > > Is this still not supported, or am I doing something wrong? > > Thanks, > Tommaso > >

Aug. 3, 2015

Garage, Glorp, PostgreSQL and Cursors

by Tommaso Dal Sasso

Hello, I was trying the version of Glorp ported to Garage, and I must say it runs smoothly, nice job! I am reading large amount of data from a Postgres db, and I was curious about the use of cursors. I remember that the old version of Glorp for Pharo did not support cursors in Postgresql, has this changed in Garage? I tried to run some tests, using a query like: (Query readManyOf: MyClass) collectionType: GlorpCursoredStream; yourself. but with a large number of rows (~300k), the whole image crashes. Is this still not supported, or am I doing something wrong? Thanks, Tommaso

Aug. 3, 2015

Re: [Pharo-users] Pillar hyperref and refs numbering

by Ferlicot D. Cyril

Le 03/08/2015 12:44, Peter UhnÃ¡k a Ã©crit : > Hi, > Hi > I have two questions: > > 1. > Would it be possible to add \usepackage{hyperref} to Pillar pdf output? > Because currently all links are invisible (well, not invisible but they > look like regular text so if the). > > So if you have sentence like "Then create a directory named "pharo-vm" > and unzip the VM for windows that you can get on the pharo website > (windows virtual machine) ." (Section "installing pillar on windows." > nobody will notice that it's a link). > Having hyperref for print doesn't make sense but if people are viewing > it on their computer it's useful. > I tried to add what you write but I do not see the difference. Do I have to add something else? (I did not used much LaTeX before so I'm not familiar with LaTeX templates.) > > 2. > Why does HTML and PDF numbering differ? > > For example the first figure in HTML is "15.1", whilst in PDF its "1.1". > > This is further exemplified in the second sentence of the chapter > "Pillar is currently used to write the Enterprise Pharo book and other > projects (see Section 1.1)." > or > "Pillar is currently used to write the Enterprise Pharo book > <https://github.com/SquareBracketAssociates/EnterprisePharo> and other > projects (see Section 15.1.2 > <https://ci.inria.fr/pharo-contribution/job/EnterprisePharoBook/lastSuccessf…>)." > > Where in PDF it's actually referring to the whole chapter instead of the > proper part. But this may be result of the subsections not being > numbered (unlike html, which numbered is). > This is because you check only 1 chapter. If you check the whole book on "book-result" you will see that it's "15.1". See: http://puu.sh/jnEyC/8952285cee.png If you compile only 1 chapter in LaTeX then you will only have the numbering of the chapter. If you compile the whole book you will have the numbering of all chapters. Cyril

Aug. 3, 2015

Pillar hyperref and refs numbering

by Peter UhnÃ¡k

Hi, I have two questions: 1. Would it be possible to add \usepackage{hyperref} to Pillar pdf output? Because currently all links are invisible (well, not invisible but they look like regular text so if the). So if you have sentence like "Then create a directory named "pharo-vm" and unzip the VM for windows that you can get on the pharo website (windows virtual machine) ." (Section "installing pillar on windows." nobody will notice that it's a link). Having hyperref for print doesn't make sense but if people are viewing it on their computer it's useful. 2. Why does HTML and PDF numbering differ? For example the first figure in HTML is "15.1", whilst in PDF its "1.1". This is further exemplified in the second sentence of the chapter "Pillar is currently used to write the Enterprise Pharo book and other projects (see Section 1.1)." or "Pillar is currently used to write the Enterprise Pharo book <https://github.com/SquareBracketAssociates/EnterprisePharo> and other projects (see Section 15.1.2 <https://ci.inria.fr/pharo-contribution/job/EnterprisePharoBook/lastSuccessf…> )." Where in PDF it's actually referring to the whole chapter instead of the proper part. But this may be result of the subsections not being numbered (unlike html, which numbered is). Thanks, Peter

Aug. 3, 2015

Re: [Pharo-users] Pillar automatic anchors

by Peter UhnÃ¡k

> > Hi Petter! > > I begun a transformer some time ago. His name is "PRAnchorOfSection" > that inherit from "PRNodeTransformer". > For now this transformer is not enable because we need to check some > problems. > Yeah, I started studying this. > For example this works bad if we put a link inside the title. Maybe combination of using ==PRHeader text== (instead of ==PRHeader children first text== which doesn't work when there's formatting involved... like ! ==PRTransformer==) and then id filtering could solve this? It will be messy, but not if we also give user the ability to specify anchors explicitly... see further down. But I see a different problem which I don't think can be solved with generic Transformer... And that is that in HTML it is customary to place anchor ABOVE or before the target, so when you click on a link it it will show also the name of the chapter, so the user knows where he is. While in LaTeX it's usually placed underneath. So this would require having an extra HTML-only specific transformer (or something) that would swap them. Or what do > we do if we have two times the same title? As "Introduction"? > Well ideally user would still be able to specify an explicit anchor, in which case the default one is not generated. So by default it can append a number or something, but user could override it. I think there's a lot to be learned from Sphinx. Peter

Aug. 3, 2015

Re: [Pharo-users] Pillar automatic anchors

by Ferlicot D. Cyril

Le 31/07/2015 20:06, Peter UhnÃ¡k a Ã©crit : > Hi, > > I would like to resolve this issue: > Automatic section anchors: Each section title should automatically > generate an implicit hyperlink target (aka, anchor) pointing to the > section. The text of the hyperlink target (the "reference name") is the > same as that of the section title. > > however since I'm not familiar with Pillar I don't know how acceptable > this solution could be > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > PRHTMLWriter>>visitHeader: aHeader > | level | > level := self configuration headingLevelOffset + aHeader level."h1 to h7 > exist." > level := level min: 7 max: 1. > canvas tag > name: 'h' , level asString; > parameterAt: 'id' put: (self createIdForHeader: aHeader); "<<< addition" > with: [ > self writeCounterForHeader: aHeader. > super visitHeader: aHeader ]. > canvas newLine > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > and > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > createIdForHeader: aHeader > | id | > id := aHeader text. > id := id asLowercase. > "replace banned characters with dashes" > id := '[^0-9a-z\-]' asRegex copy: id replacingMatchesWith: '-'. > "merge multiple dashes" > id := '-{2,}' asRegex copy: id replacingMatchesWith: '-'. > "remove dashes from beginning/end of the id" > id := '^-|-$' asRegex copy: id replacingMatchesWith: ''. > ^ id > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > Strictly speaking HTML 5 is very permissive with the value of id, but > the question is whether we really want to permit everything. E.g. > unicode in url is always asking for trouble. > > Thanks, > Peter > > Hi Petter! I begun a transformer some time ago. His name is "PRAnchorOfSection" that inherit from "PRNodeTransformer". For now this transformer is not enable because we need to check some problems. For example this works bad if we put a link inside the title. Or what do we do if we have two times the same title? As "Introduction"? Cyril

Aug. 3, 2015

Re: [Pharo-users] ICFP contest 4th of August

by Sebastian Heidbrink

Sorry wrong key it is on the 7th... On 2015-08-02 10:05 PM, Sebastian Heidbrink wrote: > Hi! > > Just in case somebody might have missed this: > > http://icfpcontest.org/ > > Seabstian > >

Aug. 3, 2015