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 <emaring...@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.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 ? > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> > > >> > > > >
