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.al...@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 <emaring...@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.al...@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.al...@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 <bstj...@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.al...@gmail.com> >> >>> To: Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is >> >>> welcome <pharo-users@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 <bstj...@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.al...@gmail.com> >> >>> To: Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is >> >>> welcome <pharo-users@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 <bstj...@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.al...@gmail.com> >> >>> To: Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is >> >>> welcome <pharo-users@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.al...@gmail.com> >> >>> wrote: >> >>> >> >>> thank you Benoit >> >>> >> >>> On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users >> >>> <pharo-users@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.al...@gmail.com> >> >>> To: Any question about pharo is welcome <pharo-users@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 ? >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> > >> >
