- Pharo-users - lists.pharo.org

Re: [Pharo-users] PostgreSQL and Pharo 6

by Benoit St-Jean

Do you absolutely need SSL or you can connect to this server without it?Â Esteban is right : writing a driver from scratch takes quite some time!Â It would be way easier to add SSL support to the existing one. Â ----------------- BenoÃ®t St-Jean Yahoo! Messenger: bstjean Twitter: @BenLeChialeux Pinterest: benoitstjean Instagram: Chef_Benito IRC: lamneth Blogue: endormitoire.wordpress.com "A standpoint is an intellectual horizon of radius zero".Â (A. Einstein) From: Dimitris Chloupis <kilon.alios(a)gmail.com> To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> Sent: Tuesday, April 18, 2017 11:02 AM Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 Sure but most probably I won't do either and abandon the effort. By API I did not mean to wrap the entire thing only a dozen of functions, the bare minimum I want to make this work. Including SSL. Will give a try at some point in the future and if it's easy will do. If not , no big deal. There is also the possibility of using the Python library for PostgreSQL from inside Pharo via my Python IPC API, Atlas. I just did not want to add Python as dependency for a Pharo library. But for now is the easiest solution . On Tue, 18 Apr 2017 at 17:51, Esteban A. Maringolo <emaringolo(a)gmail.com> wrote: All current PostgreSQL drivers are 100% written in Smalltalk, I haven't used the V3 version (binary), but the V2 is more than good enough even for production systems. Writing a new driver using the libpq shared library might be a fun project, but a lot of work; maybe it will be more fun adding the SSL/TLS to the current Smalltalk implementation :) Regards, Esteban A. Maringolo 2017-04-18 11:19 GMT-03:00 Dimitris Chloupis <kilon.alios(a)gmail.com>: > Looks like I will have to make my own PostgreSQL API . Nice excuse to test > my UFFI skills once more :) > > On Tue, 18 Apr 2017 at 16:17, Esteban A. Maringolo <emaringolo(a)gmail.com> > wrote: >> >> Not that I'm aware of. >> >> You can create a ssh tunnel that ciphers the data between your host >> and the remote server, but you'd need a ssh daemon running in the >> server host. >> >> Regards, >> >> Esteban A. Maringolo >> >> >> 2017-04-18 5:09 GMT-03:00 Dimitris Chloupis <kilon.alios(a)gmail.com>: >> > After some investigation in Heroku documentation, the database expects a >> > SSL >> > connection but it seems the driver does not use SSL , any way to force >> > Garage to use SSL ? >> > >> > On Tue, 18 Apr 2017 at 10:07, Dimitris Chloupis <kilon.alios(a)gmail.com> >> > wrote: >> >> >> >> I adjusted it for my database and gives me error >> >> >> >> EFATAL:Â no pg_hba.conf entry for host "", user "", database "", SSL >> >> off >> >> >> >> any way to resolved this ? >> >> >> >> On Tue, Apr 18, 2017 at 1:24 AM Benoit St-Jean <bstjean(a)yahoo.com> >> >> wrote: >> >>> >> >>> Try this: >> >>> >> >>> | sql conn connectionSpec resultÂ | >> >>> sql := 'SELECT * FROM search_terms'. >> >>> conn := GAConnection new. >> >>> connectionSpec := GAConnectionArgs >> >>>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â hostname: 'localhost' >> >>>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â portno: 5432 >> >>>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â databaseName: 'sodbxtest' >> >>>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â userName: 'sodbxtest' >> >>>Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â password: 'sodbxtest'. >> >>> conn connectionArgs: connectionSpec. >> >>> >> >>> "Connect to the server" >> >>> result := conn startup. >> >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt >> >>> ]. >> >>> >> >>> "Execute your SQL stuff" >> >>> result := conn execute: sql. >> >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ] >> >>> ifFalse: [result inspect]. >> >>> >> >>> "Disconnect from the server" >> >>> conn close. >> >>> >> >>> >> >>> ----------------- >> >>> BenoÃ®t St-Jean >> >>> Yahoo! Messenger: bstjean >> >>> Twitter: @BenLeChialeux >> >>> Pinterest: benoitstjean >> >>> Instagram: Chef_Benito >> >>> IRC: lamneth >> >>> Blogue: endormitoire.wordpress.com >> >>> "A standpoint is an intellectual horizon of radius zero".Â (A. >> >>> Einstein) >> >>> >> >>> >> >>> ________________________________ >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is >> >>> welcome <pharo-users(a)lists.pharo.org> >> >>> Sent: Monday, April 17, 2017 5:24 PM >> >>> >> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 >> >>> >> >>> Following the instructions here >> >>> >> >>> http://guillep.github.io/DBXTalk/garage/installation.html >> >>> >> >>> I did >> >>> >> >>> Gofer it >> >>> smalltalkhubUser: 'DBXTalk' project: 'Garage'; >> >>> configurationOf: 'Garage'; >> >>> load. >> >>> >> >>> >> >>> (ConfigurationOfGarage project version: '0.5') >> >>> load: 'postgresV2'. >> >>> >> >>> And it did install >> >>> >> >>> >> >>> On Tue, 18 Apr 2017 at 00:02, Benoit St-Jean <bstjean(a)yahoo.com> >> >>> wrote: >> >>> >> >>> Tell me which exact package you loaded (or even better, the exact to >> >>> load >> >>> it) and I will test some code against my PostgreSQL server... >> >>> >> >>> >> >>> ----------------- >> >>> BenoÃ®t St-Jean >> >>> Yahoo! Messenger: bstjean >> >>> Twitter: @BenLeChialeux >> >>> Pinterest: benoitstjean >> >>> Instagram: Chef_Benito >> >>> IRC: lamneth >> >>> Blogue: endormitoire.wordpress.com >> >>> "A standpoint is an intellectual horizon of radius zero".Â (A. >> >>> Einstein) >> >>> >> >>> >> >>> ________________________________ >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is >> >>> welcome <pharo-users(a)lists.pharo.org> >> >>> Sent: Monday, April 17, 2017 4:55 PM >> >>> >> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 >> >>> >> >>> no conn connect does not work because GAConnection has no such method. >> >>> #connect exist in GAPostgresDrive but even if I go that route I get >> >>> error >> >>> #OptionAt:IfAbsent: was sent to nil . With this code >> >>> >> >>> conn2 := GAPostgresDriver new . >> >>> conn2 host: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' >> >>> port: '****' >> >>> database:'*******' >> >>> user: '*****' >> >>> password:''***'. >> >>> conn2 connect. >> >>> >> >>> Is there sample code that connects to online databases ? >> >>> >> >>> >> >>> >> >>> On Mon, Apr 17, 2017 at 11:18 PM Benoit St-Jean <bstjean(a)yahoo.com> >> >>> wrote: >> >>> >> >>> You have to #connect before executing SQL statements! >> >>> >> >>> Something like (in your code): >> >>> >> >>> conn connect. >> >>> >> >>> ----------------- >> >>> BenoÃ®t St-Jean >> >>> Yahoo! Messenger: bstjean >> >>> Twitter: @BenLeChialeux >> >>> Pinterest: benoitstjean >> >>> Instagram: Chef_Benito >> >>> IRC: lamneth >> >>> Blogue: endormitoire.wordpress.com >> >>> "A standpoint is an intellectual horizon of radius zero".Â (A. >> >>> Einstein) >> >>> >> >>> >> >>> ________________________________ >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is >> >>> welcome <pharo-users(a)lists.pharo.org> >> >>> Sent: Monday, April 17, 2017 3:54 PM >> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 >> >>> >> >>> Installing from Catalog Browser fails >> >>> >> >>> I installed it via the the website instructions, it installs fine >> >>> >> >>> But if I use it this way >> >>> >> >>> conn := GAConnection new. >> >>> ca := GAConnectionArgs hostname: >> >>> 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' >> >>> portno: '****' >> >>> databaseName:'*******' >> >>> userName: '*****' >> >>> password:''***'. >> >>> conn connectionArgs: ca. >> >>> conn execute: 'select * from search_terms'. >> >>> >> >>> it fails with no connection, is there anything else i need to do ? >> >>> is there a guide for how to use this ? >> >>> >> >>> >> >>> >> >>> On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis >> >>> <kilon.alios(a)gmail.com> >> >>> wrote: >> >>> >> >>> thank you Benoit >> >>> >> >>> On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users >> >>> <pharo-users(a)lists.pharo.org> wrote: >> >>> >> >>> ODBC worked fine as well if you don't need native driver access >> >>> >> >>> ----------------- >> >>> BenoÃ®t St-Jean >> >>> Yahoo! Messenger: bstjean >> >>> Twitter: @BenLeChialeux >> >>> Pinterest: benoitstjean >> >>> Instagram: Chef_Benito >> >>> IRC: lamneth >> >>> Blogue: endormitoire.wordpress.com >> >>> "A standpoint is an intellectual horizon of radius zero".Â (A. >> >>> Einstein) >> >>> >> >>> >> >>> ________________________________ >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >> >>> To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> >> >>> Sent: Sunday, April 16, 2017 4:37 AM >> >>> Subject: [Pharo-users] PostgreSQL and Pharo 6 >> >>> >> >>> Hey guys , I play with PostgreSQL and I really like it, sorry Esteban >> >>> :D >> >>> >> >>> I am using Python for it but I would like to give access also to Pharo >> >>> to >> >>> my database. I was informed that Garage has a driver for PostgreSQL , >> >>> is >> >>> there any other candidate ? Any advice ? >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> > >> >

April 18, 2017

Re: [Pharo-users] [ANN] Prometheas : a Pharo wiki database

by nacho

Thanks Offray. I already sign up. I am taking a look a Rubric. It seems that can help in formating text. best Nacho ----- Nacho Smalltalker apprentice. Buenos Aires, Argentina. -- View this message in context: http://forum.world.st/ANN-Prometheas-a-Pharo-wiki-database-tp4942110p494254… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

April 18, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

Sure but most probably I won't do either and abandon the effort. By API I did not mean to wrap the entire thing only a dozen of functions, the bare minimum I want to make this work. Including SSL. Will give a try at some point in the future and if it's easy will do. If not , no big deal. There is also the possibility of using the Python library for PostgreSQL from inside Pharo via my Python IPC API, Atlas. I just did not want to add Python as dependency for a Pharo library. But for now is the easiest solution . On Tue, 18 Apr 2017 at 17:51, Esteban A. Maringolo <emaringolo(a)gmail.com> wrote: > All current PostgreSQL drivers are 100% written in Smalltalk, I > haven't used the V3 version (binary), but the V2 is more than good > enough even for production systems. > > Writing a new driver using the libpq shared library might be a fun > project, but a lot of work; maybe it will be more fun adding the > SSL/TLS to the current Smalltalk implementation :) > > Regards, > > Esteban A. Maringolo > > > 2017-04-18 11:19 GMT-03:00 Dimitris Chloupis <kilon.alios(a)gmail.com>: > > Looks like I will have to make my own PostgreSQL API . Nice excuse to > test > > my UFFI skills once more :) > > > > On Tue, 18 Apr 2017 at 16:17, Esteban A. Maringolo <emaringolo(a)gmail.com > > > > wrote: > >> > >> Not that I'm aware of. > >> > >> You can create a ssh tunnel that ciphers the data between your host > >> and the remote server, but you'd need a ssh daemon running in the > >> server host. > >> > >> Regards, > >> > >> Esteban A. Maringolo > >> > >> > >> 2017-04-18 5:09 GMT-03:00 Dimitris Chloupis <kilon.alios(a)gmail.com>: > >> > After some investigation in Heroku documentation, the database > expects a > >> > SSL > >> > connection but it seems the driver does not use SSL , any way to force > >> > Garage to use SSL ? > >> > > >> > On Tue, 18 Apr 2017 at 10:07, Dimitris Chloupis < > kilon.alios(a)gmail.com> > >> > wrote: > >> >> > >> >> I adjusted it for my database and gives me error > >> >> > >> >> EFATAL: no pg_hba.conf entry for host "", user "", database "", SSL > >> >> off > >> >> > >> >> any way to resolved this ? > >> >> > >> >> On Tue, Apr 18, 2017 at 1:24 AM Benoit St-Jean <bstjean(a)yahoo.com> > >> >> wrote: > >> >>> > >> >>> Try this: > >> >>> > >> >>> | sql conn connectionSpec result | > >> >>> sql := 'SELECT * FROM search_terms'. > >> >>> conn := GAConnection new. > >> >>> connectionSpec := GAConnectionArgs > >> >>> hostname: 'localhost' > >> >>> portno: 5432 > >> >>> databaseName: 'sodbxtest' > >> >>> userName: 'sodbxtest' > >> >>> password: 'sodbxtest'. > >> >>> conn connectionArgs: connectionSpec. > >> >>> > >> >>> "Connect to the server" > >> >>> result := conn startup. > >> >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt > >> >>> ]. > >> >>> > >> >>> "Execute your SQL stuff" > >> >>> result := conn execute: sql. > >> >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self > halt ] > >> >>> ifFalse: [result inspect]. > >> >>> > >> >>> "Disconnect from the server" > >> >>> conn close. > >> >>> > >> >>> > >> >>> ----------------- > >> >>> BenoÃ®t St-Jean > >> >>> Yahoo! Messenger: bstjean > >> >>> Twitter: @BenLeChialeux > >> >>> Pinterest: benoitstjean > >> >>> Instagram: Chef_Benito > >> >>> IRC: lamneth > >> >>> Blogue: endormitoire.wordpress.com > >> >>> "A standpoint is an intellectual horizon of radius zero". (A. > >> >>> Einstein) > >> >>> > >> >>> > >> >>> ________________________________ > >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> > >> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is > >> >>> welcome <pharo-users(a)lists.pharo.org> > >> >>> Sent: Monday, April 17, 2017 5:24 PM > >> >>> > >> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 > >> >>> > >> >>> Following the instructions here > >> >>> > >> >>> http://guillep.github.io/DBXTalk/garage/installation.html > >> >>> > >> >>> I did > >> >>> > >> >>> Gofer it > >> >>> smalltalkhubUser: 'DBXTalk' project: 'Garage'; > >> >>> configurationOf: 'Garage'; > >> >>> load. > >> >>> > >> >>> > >> >>> (ConfigurationOfGarage project version: '0.5') > >> >>> load: 'postgresV2'. > >> >>> > >> >>> And it did install > >> >>> > >> >>> > >> >>> On Tue, 18 Apr 2017 at 00:02, Benoit St-Jean <bstjean(a)yahoo.com> > >> >>> wrote: > >> >>> > >> >>> Tell me which exact package you loaded (or even better, the exact to > >> >>> load > >> >>> it) and I will test some code against my PostgreSQL server... > >> >>> > >> >>> > >> >>> ----------------- > >> >>> BenoÃ®t St-Jean > >> >>> Yahoo! Messenger: bstjean > >> >>> Twitter: @BenLeChialeux > >> >>> Pinterest: benoitstjean > >> >>> Instagram: Chef_Benito > >> >>> IRC: lamneth > >> >>> Blogue: endormitoire.wordpress.com > >> >>> "A standpoint is an intellectual horizon of radius zero". (A. > >> >>> Einstein) > >> >>> > >> >>> > >> >>> ________________________________ > >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> > >> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is > >> >>> welcome <pharo-users(a)lists.pharo.org> > >> >>> Sent: Monday, April 17, 2017 4:55 PM > >> >>> > >> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 > >> >>> > >> >>> no conn connect does not work because GAConnection has no such > method. > >> >>> #connect exist in GAPostgresDrive but even if I go that route I get > >> >>> error > >> >>> #OptionAt:IfAbsent: was sent to nil . With this code > >> >>> > >> >>> conn2 := GAPostgresDriver new . > >> >>> conn2 host: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' > >> >>> port: '****' > >> >>> database:'*******' > >> >>> user: '*****' > >> >>> password:''***'. > >> >>> conn2 connect. > >> >>> > >> >>> Is there sample code that connects to online databases ? > >> >>> > >> >>> > >> >>> > >> >>> On Mon, Apr 17, 2017 at 11:18 PM Benoit St-Jean <bstjean(a)yahoo.com> > >> >>> wrote: > >> >>> > >> >>> You have to #connect before executing SQL statements! > >> >>> > >> >>> Something like (in your code): > >> >>> > >> >>> conn connect. > >> >>> > >> >>> ----------------- > >> >>> BenoÃ®t St-Jean > >> >>> Yahoo! Messenger: bstjean > >> >>> Twitter: @BenLeChialeux > >> >>> Pinterest: benoitstjean > >> >>> Instagram: Chef_Benito > >> >>> IRC: lamneth > >> >>> Blogue: endormitoire.wordpress.com > >> >>> "A standpoint is an intellectual horizon of radius zero". (A. > >> >>> Einstein) > >> >>> > >> >>> > >> >>> ________________________________ > >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> > >> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is > >> >>> welcome <pharo-users(a)lists.pharo.org> > >> >>> Sent: Monday, April 17, 2017 3:54 PM > >> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 > >> >>> > >> >>> Installing from Catalog Browser fails > >> >>> > >> >>> I installed it via the the website instructions, it installs fine > >> >>> > >> >>> But if I use it this way > >> >>> > >> >>> conn := GAConnection new. > >> >>> ca := GAConnectionArgs hostname: > >> >>> 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' > >> >>> portno: '****' > >> >>> databaseName:'*******' > >> >>> userName: '*****' > >> >>> password:''***'. > >> >>> conn connectionArgs: ca. > >> >>> conn execute: 'select * from search_terms'. > >> >>> > >> >>> it fails with no connection, is there anything else i need to do ? > >> >>> is there a guide for how to use this ? > >> >>> > >> >>> > >> >>> > >> >>> On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis > >> >>> <kilon.alios(a)gmail.com> > >> >>> wrote: > >> >>> > >> >>> thank you Benoit > >> >>> > >> >>> On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users > >> >>> <pharo-users(a)lists.pharo.org> wrote: > >> >>> > >> >>> ODBC worked fine as well if you don't need native driver access > >> >>> > >> >>> ----------------- > >> >>> BenoÃ®t St-Jean > >> >>> Yahoo! Messenger: bstjean > >> >>> Twitter: @BenLeChialeux > >> >>> Pinterest: benoitstjean > >> >>> Instagram: Chef_Benito > >> >>> IRC: lamneth > >> >>> Blogue: endormitoire.wordpress.com > >> >>> "A standpoint is an intellectual horizon of radius zero". (A. > >> >>> Einstein) > >> >>> > >> >>> > >> >>> ________________________________ > >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> > >> >>> To: Any question about pharo is welcome < > pharo-users(a)lists.pharo.org> > >> >>> Sent: Sunday, April 16, 2017 4:37 AM > >> >>> Subject: [Pharo-users] PostgreSQL and Pharo 6 > >> >>> > >> >>> Hey guys , I play with PostgreSQL and I really like it, sorry > Esteban > >> >>> :D > >> >>> > >> >>> I am using Python for it but I would like to give access also to > Pharo > >> >>> to > >> >>> my database. I was informed that Garage has a driver for PostgreSQL > , > >> >>> is > >> >>> there any other candidate ? Any advice ? > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> > > >> > > > >

April 18, 2017

Re: [Pharo-users] [ANN] Prometheas : a Pharo wiki database

by Offray Vladimir Luna CÃ¡rdenas

Nice to know Nacho. Please join us at our Grafoscopio Spanish mailing list at [1] and checkout the last updated documentation, including English user manual with explanations about web links support and custom markup keywords at [2]. [1] http://mutabit.com/grafoscopio/#contacto [2] http://mutabit.com/repos.fossil/grafoscopio/doc/tip/intro.md Cheers, Offray On 17/04/17 18:36, nacho wrote: > Excellent proposal Offray. Hope this get elected. I use Grafoscopio a lot to > keep notes with code and would love to see markdown integration, ability to > add images and links. > Keep us posted! > best > Nacho > > > > > ----- > Nacho > Smalltalker apprentice. > Buenos Aires, Argentina. > -- > View this message in context: http://forum.world.st/ANN-Prometheas-a-Pharo-wiki-database-tp4942110p494247… > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. > >

April 18, 2017

Re: [Pharo-users] [ANN] Prometheas : a Pharo wiki database

by Offray Vladimir Luna CÃ¡rdenas

Yes. I tried to use it once and even ask for support to Moose devs, after they asked for feedback (and I didn't get any answer, but my question to answer ratio by Moose team can be pretty random). The idea is to use same principles, but for markdown. Supporting markdown in the documentation markup space is as important as supporting Git in the DVCS space. Cheers, Offray On 17/04/17 23:59, Dimitris Chloupis wrote: > Moose devs made a Pillar rendered for GTInspector. Pillar is a > markdown inspired version for Pharo. > > http://forum.world.st/ann-pillar-support-in-gtinspector-td4913115.html > > We use Pillar to generate all our HTML and PDF documentation > > On Tue, 18 Apr 2017 at 00:44, nacho <0800nacho(a)gmail.com > <mailto:0800nacho@gmail.com>> wrote: > > I'm eager to test it! > One quick question, is there a way to render markdown inside an Image? > thanks > Nacho > > > > ----- > Nacho > Smalltalker apprentice. > Buenos Aires, Argentina. > -- > View this message in context: > http://forum.world.st/ANN-Prometheas-a-Pharo-wiki-database-tp4942110p494246… > Sent from the Pharo Smalltalk Users mailing list archive at > Nabble.com. >

April 18, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Esteban A. Maringolo

All current PostgreSQL drivers are 100% written in Smalltalk, I haven't used the V3 version (binary), but the V2 is more than good enough even for production systems. Writing a new driver using the libpq shared library might be a fun project, but a lot of work; maybe it will be more fun adding the SSL/TLS to the current Smalltalk implementation :) Regards, Esteban A. Maringolo 2017-04-18 11:19 GMT-03:00 Dimitris Chloupis <kilon.alios(a)gmail.com>: > Looks like I will have to make my own PostgreSQL API . Nice excuse to test > my UFFI skills once more :) > > On Tue, 18 Apr 2017 at 16:17, Esteban A. Maringolo <emaringolo(a)gmail.com> > wrote: >> >> Not that I'm aware of. >> >> You can create a ssh tunnel that ciphers the data between your host >> and the remote server, but you'd need a ssh daemon running in the >> server host. >> >> Regards, >> >> Esteban A. Maringolo >> >> >> 2017-04-18 5:09 GMT-03:00 Dimitris Chloupis <kilon.alios(a)gmail.com>: >> > After some investigation in Heroku documentation, the database expects a >> > SSL >> > connection but it seems the driver does not use SSL , any way to force >> > Garage to use SSL ? >> > >> > On Tue, 18 Apr 2017 at 10:07, Dimitris Chloupis <kilon.alios(a)gmail.com> >> > wrote: >> >> >> >> I adjusted it for my database and gives me error >> >> >> >> EFATAL: no pg_hba.conf entry for host "", user "", database "", SSL >> >> off >> >> >> >> any way to resolved this ? >> >> >> >> On Tue, Apr 18, 2017 at 1:24 AM Benoit St-Jean <bstjean(a)yahoo.com> >> >> wrote: >> >>> >> >>> Try this: >> >>> >> >>> | sql conn connectionSpec result | >> >>> sql := 'SELECT * FROM search_terms'. >> >>> conn := GAConnection new. >> >>> connectionSpec := GAConnectionArgs >> >>> hostname: 'localhost' >> >>> portno: 5432 >> >>> databaseName: 'sodbxtest' >> >>> userName: 'sodbxtest' >> >>> password: 'sodbxtest'. >> >>> conn connectionArgs: connectionSpec. >> >>> >> >>> "Connect to the server" >> >>> result := conn startup. >> >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt >> >>> ]. >> >>> >> >>> "Execute your SQL stuff" >> >>> result := conn execute: sql. >> >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ] >> >>> ifFalse: [result inspect]. >> >>> >> >>> "Disconnect from the server" >> >>> conn close. >> >>> >> >>> >> >>> ----------------- >> >>> BenoÃ®t St-Jean >> >>> Yahoo! Messenger: bstjean >> >>> Twitter: @BenLeChialeux >> >>> Pinterest: benoitstjean >> >>> Instagram: Chef_Benito >> >>> IRC: lamneth >> >>> Blogue: endormitoire.wordpress.com >> >>> "A standpoint is an intellectual horizon of radius zero". (A. >> >>> Einstein) >> >>> >> >>> >> >>> ________________________________ >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is >> >>> welcome <pharo-users(a)lists.pharo.org> >> >>> Sent: Monday, April 17, 2017 5:24 PM >> >>> >> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 >> >>> >> >>> Following the instructions here >> >>> >> >>> http://guillep.github.io/DBXTalk/garage/installation.html >> >>> >> >>> I did >> >>> >> >>> Gofer it >> >>> smalltalkhubUser: 'DBXTalk' project: 'Garage'; >> >>> configurationOf: 'Garage'; >> >>> load. >> >>> >> >>> >> >>> (ConfigurationOfGarage project version: '0.5') >> >>> load: 'postgresV2'. >> >>> >> >>> And it did install >> >>> >> >>> >> >>> On Tue, 18 Apr 2017 at 00:02, Benoit St-Jean <bstjean(a)yahoo.com> >> >>> wrote: >> >>> >> >>> Tell me which exact package you loaded (or even better, the exact to >> >>> load >> >>> it) and I will test some code against my PostgreSQL server... >> >>> >> >>> >> >>> ----------------- >> >>> BenoÃ®t St-Jean >> >>> Yahoo! Messenger: bstjean >> >>> Twitter: @BenLeChialeux >> >>> Pinterest: benoitstjean >> >>> Instagram: Chef_Benito >> >>> IRC: lamneth >> >>> Blogue: endormitoire.wordpress.com >> >>> "A standpoint is an intellectual horizon of radius zero". (A. >> >>> Einstein) >> >>> >> >>> >> >>> ________________________________ >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is >> >>> welcome <pharo-users(a)lists.pharo.org> >> >>> Sent: Monday, April 17, 2017 4:55 PM >> >>> >> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 >> >>> >> >>> no conn connect does not work because GAConnection has no such method. >> >>> #connect exist in GAPostgresDrive but even if I go that route I get >> >>> error >> >>> #OptionAt:IfAbsent: was sent to nil . With this code >> >>> >> >>> conn2 := GAPostgresDriver new . >> >>> conn2 host: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' >> >>> port: '****' >> >>> database:'*******' >> >>> user: '*****' >> >>> password:''***'. >> >>> conn2 connect. >> >>> >> >>> Is there sample code that connects to online databases ? >> >>> >> >>> >> >>> >> >>> On Mon, Apr 17, 2017 at 11:18 PM Benoit St-Jean <bstjean(a)yahoo.com> >> >>> wrote: >> >>> >> >>> You have to #connect before executing SQL statements! >> >>> >> >>> Something like (in your code): >> >>> >> >>> conn connect. >> >>> >> >>> ----------------- >> >>> BenoÃ®t St-Jean >> >>> Yahoo! Messenger: bstjean >> >>> Twitter: @BenLeChialeux >> >>> Pinterest: benoitstjean >> >>> Instagram: Chef_Benito >> >>> IRC: lamneth >> >>> Blogue: endormitoire.wordpress.com >> >>> "A standpoint is an intellectual horizon of radius zero". (A. >> >>> Einstein) >> >>> >> >>> >> >>> ________________________________ >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is >> >>> welcome <pharo-users(a)lists.pharo.org> >> >>> Sent: Monday, April 17, 2017 3:54 PM >> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 >> >>> >> >>> Installing from Catalog Browser fails >> >>> >> >>> I installed it via the the website instructions, it installs fine >> >>> >> >>> But if I use it this way >> >>> >> >>> conn := GAConnection new. >> >>> ca := GAConnectionArgs hostname: >> >>> 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' >> >>> portno: '****' >> >>> databaseName:'*******' >> >>> userName: '*****' >> >>> password:''***'. >> >>> conn connectionArgs: ca. >> >>> conn execute: 'select * from search_terms'. >> >>> >> >>> it fails with no connection, is there anything else i need to do ? >> >>> is there a guide for how to use this ? >> >>> >> >>> >> >>> >> >>> On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis >> >>> <kilon.alios(a)gmail.com> >> >>> wrote: >> >>> >> >>> thank you Benoit >> >>> >> >>> On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users >> >>> <pharo-users(a)lists.pharo.org> wrote: >> >>> >> >>> ODBC worked fine as well if you don't need native driver access >> >>> >> >>> ----------------- >> >>> BenoÃ®t St-Jean >> >>> Yahoo! Messenger: bstjean >> >>> Twitter: @BenLeChialeux >> >>> Pinterest: benoitstjean >> >>> Instagram: Chef_Benito >> >>> IRC: lamneth >> >>> Blogue: endormitoire.wordpress.com >> >>> "A standpoint is an intellectual horizon of radius zero". (A. >> >>> Einstein) >> >>> >> >>> >> >>> ________________________________ >> >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >> >>> To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> >> >>> Sent: Sunday, April 16, 2017 4:37 AM >> >>> Subject: [Pharo-users] PostgreSQL and Pharo 6 >> >>> >> >>> Hey guys , I play with PostgreSQL and I really like it, sorry Esteban >> >>> :D >> >>> >> >>> I am using Python for it but I would like to give access also to Pharo >> >>> to >> >>> my database. I was informed that Garage has a driver for PostgreSQL , >> >>> is >> >>> there any other candidate ? Any advice ? >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> > >> >

April 18, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

Looks like I will have to make my own PostgreSQL API . Nice excuse to test my UFFI skills once more :) On Tue, 18 Apr 2017 at 16:17, Esteban A. Maringolo <emaringolo(a)gmail.com> wrote: > Not that I'm aware of. > > You can create a ssh tunnel that ciphers the data between your host > and the remote server, but you'd need a ssh daemon running in the > server host. > > Regards, > > Esteban A. Maringolo > > > 2017-04-18 5:09 GMT-03:00 Dimitris Chloupis <kilon.alios(a)gmail.com>: > > After some investigation in Heroku documentation, the database expects a > SSL > > connection but it seems the driver does not use SSL , any way to force > > Garage to use SSL ? > > > > On Tue, 18 Apr 2017 at 10:07, Dimitris Chloupis <kilon.alios(a)gmail.com> > > wrote: > >> > >> I adjusted it for my database and gives me error > >> > >> EFATAL: no pg_hba.conf entry for host "", user "", database "", SSL off > >> > >> any way to resolved this ? > >> > >> On Tue, Apr 18, 2017 at 1:24 AM Benoit St-Jean <bstjean(a)yahoo.com> > wrote: > >>> > >>> Try this: > >>> > >>> | sql conn connectionSpec result | > >>> sql := 'SELECT * FROM search_terms'. > >>> conn := GAConnection new. > >>> connectionSpec := GAConnectionArgs > >>> hostname: 'localhost' > >>> portno: 5432 > >>> databaseName: 'sodbxtest' > >>> userName: 'sodbxtest' > >>> password: 'sodbxtest'. > >>> conn connectionArgs: connectionSpec. > >>> > >>> "Connect to the server" > >>> result := conn startup. > >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ]. > >>> > >>> "Execute your SQL stuff" > >>> result := conn execute: sql. > >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ] > >>> ifFalse: [result inspect]. > >>> > >>> "Disconnect from the server" > >>> conn close. > >>> > >>> > >>> ----------------- > >>> BenoÃ®t St-Jean > >>> Yahoo! Messenger: bstjean > >>> Twitter: @BenLeChialeux > >>> Pinterest: benoitstjean > >>> Instagram: Chef_Benito > >>> IRC: lamneth > >>> Blogue: endormitoire.wordpress.com > >>> "A standpoint is an intellectual horizon of radius zero". (A. > Einstein) > >>> > >>> > >>> ________________________________ > >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> > >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is > >>> welcome <pharo-users(a)lists.pharo.org> > >>> Sent: Monday, April 17, 2017 5:24 PM > >>> > >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 > >>> > >>> Following the instructions here > >>> > >>> http://guillep.github.io/DBXTalk/garage/installation.html > >>> > >>> I did > >>> > >>> Gofer it > >>> smalltalkhubUser: 'DBXTalk' project: 'Garage'; > >>> configurationOf: 'Garage'; > >>> load. > >>> > >>> > >>> (ConfigurationOfGarage project version: '0.5') > >>> load: 'postgresV2'. > >>> > >>> And it did install > >>> > >>> > >>> On Tue, 18 Apr 2017 at 00:02, Benoit St-Jean <bstjean(a)yahoo.com> > wrote: > >>> > >>> Tell me which exact package you loaded (or even better, the exact to > load > >>> it) and I will test some code against my PostgreSQL server... > >>> > >>> > >>> ----------------- > >>> BenoÃ®t St-Jean > >>> Yahoo! Messenger: bstjean > >>> Twitter: @BenLeChialeux > >>> Pinterest: benoitstjean > >>> Instagram: Chef_Benito > >>> IRC: lamneth > >>> Blogue: endormitoire.wordpress.com > >>> "A standpoint is an intellectual horizon of radius zero". (A. > Einstein) > >>> > >>> > >>> ________________________________ > >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> > >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is > >>> welcome <pharo-users(a)lists.pharo.org> > >>> Sent: Monday, April 17, 2017 4:55 PM > >>> > >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 > >>> > >>> no conn connect does not work because GAConnection has no such method. > >>> #connect exist in GAPostgresDrive but even if I go that route I get > error > >>> #OptionAt:IfAbsent: was sent to nil . With this code > >>> > >>> conn2 := GAPostgresDriver new . > >>> conn2 host: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' > >>> port: '****' > >>> database:'*******' > >>> user: '*****' > >>> password:''***'. > >>> conn2 connect. > >>> > >>> Is there sample code that connects to online databases ? > >>> > >>> > >>> > >>> On Mon, Apr 17, 2017 at 11:18 PM Benoit St-Jean <bstjean(a)yahoo.com> > >>> wrote: > >>> > >>> You have to #connect before executing SQL statements! > >>> > >>> Something like (in your code): > >>> > >>> conn connect. > >>> > >>> ----------------- > >>> BenoÃ®t St-Jean > >>> Yahoo! Messenger: bstjean > >>> Twitter: @BenLeChialeux > >>> Pinterest: benoitstjean > >>> Instagram: Chef_Benito > >>> IRC: lamneth > >>> Blogue: endormitoire.wordpress.com > >>> "A standpoint is an intellectual horizon of radius zero". (A. > Einstein) > >>> > >>> > >>> ________________________________ > >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> > >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is > >>> welcome <pharo-users(a)lists.pharo.org> > >>> Sent: Monday, April 17, 2017 3:54 PM > >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 > >>> > >>> Installing from Catalog Browser fails > >>> > >>> I installed it via the the website instructions, it installs fine > >>> > >>> But if I use it this way > >>> > >>> conn := GAConnection new. > >>> ca := GAConnectionArgs hostname: > >>> 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' > >>> portno: '****' > >>> databaseName:'*******' > >>> userName: '*****' > >>> password:''***'. > >>> conn connectionArgs: ca. > >>> conn execute: 'select * from search_terms'. > >>> > >>> it fails with no connection, is there anything else i need to do ? > >>> is there a guide for how to use this ? > >>> > >>> > >>> > >>> On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis < > kilon.alios(a)gmail.com> > >>> wrote: > >>> > >>> thank you Benoit > >>> > >>> On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users > >>> <pharo-users(a)lists.pharo.org> wrote: > >>> > >>> ODBC worked fine as well if you don't need native driver access > >>> > >>> ----------------- > >>> BenoÃ®t St-Jean > >>> Yahoo! Messenger: bstjean > >>> Twitter: @BenLeChialeux > >>> Pinterest: benoitstjean > >>> Instagram: Chef_Benito > >>> IRC: lamneth > >>> Blogue: endormitoire.wordpress.com > >>> "A standpoint is an intellectual horizon of radius zero". (A. > Einstein) > >>> > >>> > >>> ________________________________ > >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> > >>> To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> > >>> Sent: Sunday, April 16, 2017 4:37 AM > >>> Subject: [Pharo-users] PostgreSQL and Pharo 6 > >>> > >>> Hey guys , I play with PostgreSQL and I really like it, sorry Esteban > :D > >>> > >>> I am using Python for it but I would like to give access also to Pharo > to > >>> my database. I was informed that Garage has a driver for PostgreSQL , > is > >>> there any other candidate ? Any advice ? > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > > > >

April 18, 2017

Re: [Pharo-users] best practices for using external files for testing

by monty

XMLParser's XML-Tests-Conformance project, which is automatically generated from the W3C's Conformance Test Suites project (https://www.w3.org/XML/Test/) stores the contents of its files in class methods. This way it's self-contained, portable, and the actual files only need to be downloaded and unzipped to regenerate the TestCases. Consider extracting it into a separate project with a separate CI job if it gets too big. > Sent: Saturday, April 15, 2017 at 12:52 PM > From: "Peter Uhnak" <i.uhnak(a)gmail.com> > To: pharo-users(a)lists.pharo.org > Subject: [Pharo-users] best practices for using external files for testing > > Hi, > > is there a common/best practice for using external files in tests? > > In my specific case I am interested in git-based projects, where I have a big (~1MB) file stored in repository and I would like to use it in my tests. > > For GitFileTree project I could presumably use the following to access it: > > 'OP-XMI' asPackage mcPackage workingCopy repositoryGroup remotes first directory / 'tests' / 'my-test-file.xmi' > > This will retrieve the MCPackage of the Package and then retireve where it the repo is actually stored on the disk. > > Are there better ways to do this? Could something similar be done with IceBerg? > > (p.s. in theory I could compile the entire file (e.g. 1MB) to a method, but that is very ugly to me) > > Thanks, > Peter > >

April 18, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Esteban A. Maringolo

Not that I'm aware of. You can create a ssh tunnel that ciphers the data between your host and the remote server, but you'd need a ssh daemon running in the server host. Regards, Esteban A. Maringolo 2017-04-18 5:09 GMT-03:00 Dimitris Chloupis <kilon.alios(a)gmail.com>: > After some investigation in Heroku documentation, the database expects a SSL > connection but it seems the driver does not use SSL , any way to force > Garage to use SSL ? > > On Tue, 18 Apr 2017 at 10:07, Dimitris Chloupis <kilon.alios(a)gmail.com> > wrote: >> >> I adjusted it for my database and gives me error >> >> EFATAL: no pg_hba.conf entry for host "", user "", database "", SSL off >> >> any way to resolved this ? >> >> On Tue, Apr 18, 2017 at 1:24 AM Benoit St-Jean <bstjean(a)yahoo.com> wrote: >>> >>> Try this: >>> >>> | sql conn connectionSpec result | >>> sql := 'SELECT * FROM search_terms'. >>> conn := GAConnection new. >>> connectionSpec := GAConnectionArgs >>> hostname: 'localhost' >>> portno: 5432 >>> databaseName: 'sodbxtest' >>> userName: 'sodbxtest' >>> password: 'sodbxtest'. >>> conn connectionArgs: connectionSpec. >>> >>> "Connect to the server" >>> result := conn startup. >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ]. >>> >>> "Execute your SQL stuff" >>> result := conn execute: sql. >>> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ] >>> ifFalse: [result inspect]. >>> >>> "Disconnect from the server" >>> conn close. >>> >>> >>> ----------------- >>> BenoÃ®t St-Jean >>> Yahoo! Messenger: bstjean >>> Twitter: @BenLeChialeux >>> Pinterest: benoitstjean >>> Instagram: Chef_Benito >>> IRC: lamneth >>> Blogue: endormitoire.wordpress.com >>> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) >>> >>> >>> ________________________________ >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is >>> welcome <pharo-users(a)lists.pharo.org> >>> Sent: Monday, April 17, 2017 5:24 PM >>> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 >>> >>> Following the instructions here >>> >>> http://guillep.github.io/DBXTalk/garage/installation.html >>> >>> I did >>> >>> Gofer it >>> smalltalkhubUser: 'DBXTalk' project: 'Garage'; >>> configurationOf: 'Garage'; >>> load. >>> >>> >>> (ConfigurationOfGarage project version: '0.5') >>> load: 'postgresV2'. >>> >>> And it did install >>> >>> >>> On Tue, 18 Apr 2017 at 00:02, Benoit St-Jean <bstjean(a)yahoo.com> wrote: >>> >>> Tell me which exact package you loaded (or even better, the exact to load >>> it) and I will test some code against my PostgreSQL server... >>> >>> >>> ----------------- >>> BenoÃ®t St-Jean >>> Yahoo! Messenger: bstjean >>> Twitter: @BenLeChialeux >>> Pinterest: benoitstjean >>> Instagram: Chef_Benito >>> IRC: lamneth >>> Blogue: endormitoire.wordpress.com >>> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) >>> >>> >>> ________________________________ >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is >>> welcome <pharo-users(a)lists.pharo.org> >>> Sent: Monday, April 17, 2017 4:55 PM >>> >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 >>> >>> no conn connect does not work because GAConnection has no such method. >>> #connect exist in GAPostgresDrive but even if I go that route I get error >>> #OptionAt:IfAbsent: was sent to nil . With this code >>> >>> conn2 := GAPostgresDriver new . >>> conn2 host: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' >>> port: '****' >>> database:'*******' >>> user: '*****' >>> password:''***'. >>> conn2 connect. >>> >>> Is there sample code that connects to online databases ? >>> >>> >>> >>> On Mon, Apr 17, 2017 at 11:18 PM Benoit St-Jean <bstjean(a)yahoo.com> >>> wrote: >>> >>> You have to #connect before executing SQL statements! >>> >>> Something like (in your code): >>> >>> conn connect. >>> >>> ----------------- >>> BenoÃ®t St-Jean >>> Yahoo! Messenger: bstjean >>> Twitter: @BenLeChialeux >>> Pinterest: benoitstjean >>> Instagram: Chef_Benito >>> IRC: lamneth >>> Blogue: endormitoire.wordpress.com >>> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) >>> >>> >>> ________________________________ >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >>> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is >>> welcome <pharo-users(a)lists.pharo.org> >>> Sent: Monday, April 17, 2017 3:54 PM >>> Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 >>> >>> Installing from Catalog Browser fails >>> >>> I installed it via the the website instructions, it installs fine >>> >>> But if I use it this way >>> >>> conn := GAConnection new. >>> ca := GAConnectionArgs hostname: >>> 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' >>> portno: '****' >>> databaseName:'*******' >>> userName: '*****' >>> password:''***'. >>> conn connectionArgs: ca. >>> conn execute: 'select * from search_terms'. >>> >>> it fails with no connection, is there anything else i need to do ? >>> is there a guide for how to use this ? >>> >>> >>> >>> On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis <kilon.alios(a)gmail.com> >>> wrote: >>> >>> thank you Benoit >>> >>> On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users >>> <pharo-users(a)lists.pharo.org> wrote: >>> >>> ODBC worked fine as well if you don't need native driver access >>> >>> ----------------- >>> BenoÃ®t St-Jean >>> Yahoo! Messenger: bstjean >>> Twitter: @BenLeChialeux >>> Pinterest: benoitstjean >>> Instagram: Chef_Benito >>> IRC: lamneth >>> Blogue: endormitoire.wordpress.com >>> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) >>> >>> >>> ________________________________ >>> From: Dimitris Chloupis <kilon.alios(a)gmail.com> >>> To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> >>> Sent: Sunday, April 16, 2017 4:37 AM >>> Subject: [Pharo-users] PostgreSQL and Pharo 6 >>> >>> Hey guys , I play with PostgreSQL and I really like it, sorry Esteban :D >>> >>> I am using Python for it but I would like to give access also to Pharo to >>> my database. I was informed that Garage has a driver for PostgreSQL , is >>> there any other candidate ? Any advice ? >>> >>> >>> >>> >>> >>> >>> >>> >

April 18, 2017

Re: [Pharo-users] Exporting Packages to Cincom Smalltalk (VisualWorks)

by Peter Uhnak

Ah, I forgot about that one. (I've seen it before I wrote mine, but I didn't like some things iirc... like using string cocats instead of XMLWriter etc) Peter On Mon, Apr 17, 2017 at 04:42:52PM -0300, Esteban A. Maringolo wrote: > Thank you Peter. > > Alexandre Bergel pointed me to Roassal export classes, which does > something similar to the code you pointed me to (yours seems more > tidy). > > Thanks again, > > Esteban A. Maringolo > > > 2017-04-17 12:57 GMT-03:00 Peter Uhnak <i.uhnak(a)gmail.com>: > > Some time ago I hacked together a very simple thing that generates VW XML from code represented in Moose/UML... I guess you could use it as a starting point: https://github.com/OpenPonk/class-editor/tree/master/repository/UML-CodeGen… > > > > Also take a look at SIF (which is quite easy to use on both Pharo and VW side): > > > > * https://github.com/peteruhnak/sif > > * https://github.com/peteruhnak/sif/blob/master/docs.md > > * http://www.samadhiweb.com/blog/2016.01.06.sif.html > > * http://www.pocketsmalltalk.com/sif/ > > > > Peter > > > > On Mon, Apr 17, 2017 at 10:37:52AM -0300, Esteban A. Maringolo wrote: > >> Is there any exporter than can convert an RPackage into a VW Parcel > >> (.pst), in XML or Chunk format? > >> > >> I need to migrate a few libraries of my own and couldn't find > >> anything, so I'm asking before start writing something :) > >> > >> Regards! > >> > >> Esteban A. Maringolo > >> > > >

April 18, 2017