> On 18 Apr 2017, at 16:49, Esteban A. Maringolo <emaringolo@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.alios@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@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@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@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@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@gmail.com>
>>>>>> To: Benoit St-Jean <bstjean@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 <bstjean@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@gmail.com>
>>>>>> To: Benoit St-Jean <bstjean@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 <bstjean@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@gmail.com>
>>>>>> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>
>>
>