April 2017 - Pharo-users - lists.pharo.org

Re: [Pharo-users] best practices for using external files for testing

by Peter Uhnak

I think the best way would be to profile it I guess, or try all options... my idea was that I will keep with the repo (because I don't want to pull off-site resources every time the test suite runs (e.g. on travis), and at the same time I didn't want to make the source code big... but I guess I could also download the file from the repo itself (if it won't be accessible locally...) which I guess would make most sense. Thank you all for ideas. :) Peter On Mon, Apr 17, 2017 at 09:09:15AM -0300, HernÃ¡n Morales Durand wrote: > Hi Peter, > > In BioSmalltalk I download and extract all test files in the Configuration > and then use a method in abstract test class to access test files. > Cheers, > > HernÃ¡n > > > 2017-04-15 13:52 GMT-03:00 Peter Uhnak <i.uhnak(a)gmail.com>: > > > Hi, > > > > is there a common/best practice for using external files in tests? > > > > In my specific case I am interested in git-based projects, where I have a > > big (~1MB) file stored in repository and I would like to use it in my tests. > > > > For GitFileTree project I could presumably use the following to access it: > > > > 'OP-XMI' asPackage mcPackage workingCopy repositoryGroup remotes first > > directory / 'tests' / 'my-test-file.xmi' > > > > This will retrieve the MCPackage of the Package and then retireve where it > > the repo is actually stored on the disk. > > > > Are there better ways to do this? Could something similar be done with > > IceBerg? > > > > (p.s. in theory I could compile the entire file (e.g. 1MB) to a method, > > but that is very ugly to me) > > > > Thanks, > > Peter > > > >

April 18, 2017

Re: [Pharo-users] VM/Image magic numbers (Re: Pharo 6 snap install)

by Luke Gorrie

On 15 April 2017 at 01:22, Ben Coman <btc(a)openinworld.com> wrote: > The "magic decode for image files" seems related and possibly *very* > useful.... > http://forum.world.st/magic-decode-for-image-files-td4941712.html#a4941837 > > Now traditionally the VM has been backward compatible with old Images, > but Pharo doesn't necessarily adhere to that and policy IIUC is > release specific VM/Image pairs. > So does Pharo require extra magic numbers to co-ordinate this? > And how would this interact with OpenSmalltalk policy on these magic > numbers? > I would really like a copy of the script that checks the magic number and starts the right VM. David, could you share yours please? I started writing case file -m @share@/magic "$image" in 'Smalltalk image V3 32b*') vm=@pharo-vm-cog@ ;; 'Smalltalk image Spur 32b*') vm=@pharo-vm-spur@ ;; 'Smalltalk image Spur 64b*') vm=@pharo-vm-spur64@ ;; *) echo unrecognized image file format ;; esac ... but would prefer to avoid reinventing the wheel e.g. on how to find the image name in amongst the various options passed to $@. I would quite like for my package to be able to open the pharo-launcher image and the various images that this downloads. This means supporting pre-spur images. I would ideally like to do that by building a non-spur version of the latest VM, but I am not sure if that is supported for pharo, there is no mvm script for non-spur. The alternative would be to just build an old VM release with cmake.

April 18, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

Thanks I will give it a try though I am very bad at understanding code without documentation. I also know close to nothing about SSL . If that fails I will then use the Python library for accessing my PostgreSQL database from Pharo image. On Tue, 18 Apr 2017 at 19:18, Sven Van Caekenberghe <sven(a)stfx.eu> wrote: > > > On 18 Apr 2017, at 16:49, Esteban A. Maringolo <emaringolo(a)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(a)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(a)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(a)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(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 Sven Van Caekenberghe

> On 18 Apr 2017, at 16:49, Esteban A. Maringolo <emaringolo(a)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(a)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(a)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(a)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(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

And nope it does not allow for disabling SSL , time to use old reliable Python and make my life a ton easier :D On Tue, 18 Apr 2017 at 18:29, Dimitris Chloupis <kilon.alios(a)gmail.com> wrote: > If I disable ssl I would make database insecure, but yeah it would not > matter so much as the data is not sensitive in any way. I will try that, > good idea. > On Tue, 18 Apr 2017 at 18:22, Benoit St-Jean via Pharo-users < > pharo-users(a)lists.pharo.org> wrote: > >> Do you absolutely need SSL or you can connect to this server without it? >> >> Esteban is right : writing a driver from scratch takes quite some time! >> It would be way easier to add SSL support to the existing one. >> >> >> >> ----------------- >> 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:* Tuesday, April 18, 2017 11:02 AM >> >> *Subject:* Re: [Pharo-users] PostgreSQL and Pharo 6 >> >> 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 <emaringolo(a)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.alios(a)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(a)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(a)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(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

If I disable ssl I would make database insecure, but yeah it would not matter so much as the data is not sensitive in any way. I will try that, good idea. On Tue, 18 Apr 2017 at 18:22, Benoit St-Jean via Pharo-users < pharo-users(a)lists.pharo.org> wrote: > Do you absolutely need SSL or you can connect to this server without it? > > Esteban is right : writing a driver from scratch takes quite some time! > It would be way easier to add SSL support to the existing one. > > > > ----------------- > 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:* Tuesday, April 18, 2017 11:02 AM > > *Subject:* Re: [Pharo-users] PostgreSQL and Pharo 6 > > 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 <emaringolo(a)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.alios(a)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(a)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(a)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(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 Benoit St-Jean

Do you absolutely need SSL or you can connect to this server without it?Â Esteban is right : writing a driver from scratch takes quite some time!Â It would be way easier to add SSL support to the existing one. Â ----------------- 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: Tuesday, April 18, 2017 11:02 AM Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 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 <emaringolo(a)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.alios(a)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(a)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(a)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(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] [ANN] Prometheas : a Pharo wiki database

by nacho

Thanks Offray. I already sign up. I am taking a look a Rubric. It seems that can help in formating text. best Nacho ----- Nacho Smalltalker apprentice. Buenos Aires, Argentina. -- View this message in context: http://forum.world.st/ANN-Prometheas-a-Pharo-wiki-database-tp4942110p494254… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

April 18, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

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 <emaringolo(a)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.alios(a)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(a)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(a)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(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] [ANN] Prometheas : a Pharo wiki database

by Offray Vladimir Luna CÃ¡rdenas

Nice to know Nacho. Please join us at our Grafoscopio Spanish mailing list at [1] and checkout the last updated documentation, including English user manual with explanations about web links support and custom markup keywords at [2]. [1] http://mutabit.com/grafoscopio/#contacto [2] http://mutabit.com/repos.fossil/grafoscopio/doc/tip/intro.md Cheers, Offray On 17/04/17 18:36, nacho wrote: > 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 18, 2017