- Pharo-users - lists.pharo.org

Re: [Pharo-users] example in FFI manual not worked

by Yuriy Babah

I have recorded screencast abaut this my operations with Pharo. https://drive.google.com/open?id=0B_0p5J9SNPlBOHduQlIxdHI0bk0 But sometimes I'm moved forvard to operations: MyStructure rebuildFieldAccessors. -> DoIt -> Ok myStruct := MyStructure externalNew. -> DoIt -> Ok myStruct := id: 42. -> MessageDoesUnderstood. I'm doesn't understand in which cases i got to this moment. I'm associete that with that what i have a several copy's Pharo. And somebody affect to other. 2017-04-19 18:46 GMT+04:00 Ben Coman <btc(a)openinworld.com>: > Hi Yuriy, > > Hope I can help. I tried your example in build 60463 and its works fine. > So lets break it down. > > On Wed, Apr 19, 2017 at 8:46 PM, Yuriy Babah <babah.yuriy06(a)gmail.com> > wrote: > >> Hello everyone, >> >> I'm new to Pharo and have tried do example with structure in Unified FFI >> manual. >> >> FFIExternalStructure subclass: #MyStructure >> instanceVariableNames: '' >> classVariableNames: '' >> package: 'FFIDemo' >> > > You opened a System Browser and entered and accepted the above first on > its own, > such that the new package & class were added and the new class selected. > > Then you clicked on the <Class> button, such that the "no messages" text > in the third pane changed from > normal font to bold font. Then clicked on "no messages" to display the > method template.... > messageSelectorAndArgumentNames > "comment stating purpose of message" > | temporary variable names | > statements > > And replaced that text with the text below from "fieldsDesc" onwards, > the Accepted that. > > >> MyStructure class>>#fieldsDesc >> ^ #( >> uint8 id; >> char * struct_name; >> uint name_length; >> ) >> >> > Then separately you evaluated(doIt) the following... > > >> MyStructure rebuildFieldAccessors >> > > > >> . -> DoIt -> MessageNotUnderstood >> > What's i do wrong? >> > > Does a debug window appear? What is the exact text of the title bar, > which details which message is not understood by which class. > This provides an important hint to what is wrong. > > Further help might need a live chat. I'll be in discord for a couple of > hours, but ask anyone there... > https://discord.gg/KCKQSSt > > cheers -ben > > I do it in >> Pharo5 and 6, widows and os x. >> Sorry for my english, it's not my native language. >> >> > Your english is not too bad :) > > cheers -ben >

April 20, 2017

Re: [Pharo-users] example in FFI manual not worked

by Ben Coman

Hi Yuriy, Hope I can help. I tried your example in build 60463 and its works fine. So lets break it down. On Wed, Apr 19, 2017 at 8:46 PM, Yuriy Babah <babah.yuriy06(a)gmail.com> wrote: > Hello everyone, > > I'm new to Pharo and have tried do example with structure in Unified FFI > manual. > > FFIExternalStructure subclass: #MyStructure > instanceVariableNames: '' > classVariableNames: '' > package: 'FFIDemo' > You opened a System Browser and entered and accepted the above first on its own, such that the new package & class were added and the new class selected. Then you clicked on the <Class> button, such that the "no messages" text in the third pane changed from normal font to bold font. Then clicked on "no messages" to display the method template.... messageSelectorAndArgumentNames "comment stating purpose of message" | temporary variable names | statements And replaced that text with the text below from "fieldsDesc" onwards, the Accepted that. > MyStructure class>>#fieldsDesc > ^ #( > uint8 id; > char * struct_name; > uint name_length; > ) > > Then separately you evaluated(doIt) the following... > MyStructure rebuildFieldAccessors > > . -> DoIt -> MessageNotUnderstood > What's i do wrong? > Does a debug window appear? What is the exact text of the title bar, which details which message is not understood by which class. This provides an important hint to what is wrong. Further help might need a live chat. I'll be in discord for a couple of hours, but ask anyone there... https://discord.gg/KCKQSSt cheers -ben I do it in > Pharo5 and 6, widows and os x. > Sorry for my english, it's not my native language. > > Your english is not too bad :) cheers -ben

April 19, 2017

example in FFI manual not worked

by Yuriy Babah

Hello everyone, I'm new to Pharo and have tried do example with structure in Unified FFI manual. FFIExternalStructure subclass: #MyStructure instanceVariableNames: '' classVariableNames: '' package: 'FFIDemo' MyStructure class>>#fieldsDesc ^ #( uint8 id; char * struct_name; uint name_length; ) MyStructure rebuildFieldAccessors . -> DoIt -> MessageNotUnderstood What's i do wrong? I do it in Pharo5 and 6, widows and os x. Sorry for my english, it's not my native language.

April 19, 2017

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

by David T. Lewis

On Tue, Apr 18, 2017 at 11:11:07PM +0200, Luke Gorrie wrote: > > 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? Attached. Dave

April 18, 2017

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