- Pharo-users - lists.pharo.org

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

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

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 Dimitris Chloupis

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> 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] [ANN] Prometheas : a Pharo wiki database

by nacho

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 17, 2017

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

by Offray Vladimir Luna CÃ¡rdenas

Not now, that I'm aware of. But with Bloc, this will be possible (Pharo 6 maybe)? Meanwhile, a Summer of Code proposal [1] tries to create a better user experience (UX) with emphasis on the markdown markup writing experience. Stay tuned :-). [1] http://mutabit.com/repos.fossil/grafoscopio/doc/tip/Events/GSOC/2017-offray… Cheers, Offray On 17/04/17 16:33, nacho 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 17, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Benoit St-Jean

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 17, 2017

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

by nacho

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 17, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

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 17, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Benoit St-Jean

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 17, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

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 17, 2017