> On 18 Apr 2017, at 16:49, 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 :)
That is probably not so difficult. For inspiration, take a look at ZdcSecurePOP3Client and ZdcSecureSMTPClient, which are both SSL variants of their respective superclasses. Once set up, an SSL stream acts the same as a normal socket stream. Methods to look at are #setupStreamForSSL or #setupStreamForStartTLS. > 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 ? >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>> >>> >> >