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

example in FFI manual not worked

by Torsten Bergmann

Hi Yuriy, I guess you subclassed your class from the (wrong) class "ExternalStructure" but in the guide it is "FFIExternalStructure". Make sure to accept in the browser: FFIExternalStructure subclass: #MyStructure instanceVariableNames: '' classVariableNames: '' package: 'FFIDemo' instead of ExternalStructure subclass: #MyStructure instanceVariableNames: '' classVariableNames: '' package: 'FFIDemo' to make the class MyStructure a subclass of FFIExternalStructure instead of ExternalStructure. Hope this helps! Bye Torsten

April 20, 2017

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

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

Re: [Pharo-users] [ANN] Prometheas : a Pharo wiki database

by Offray Vladimir Luna CÃ¡rdenas

Yes. I tried to use it once and even ask for support to Moose devs, after they asked for feedback (and I didn't get any answer, but my question to answer ratio by Moose team can be pretty random). The idea is to use same principles, but for markdown. Supporting markdown in the documentation markup space is as important as supporting Git in the DVCS space. Cheers, Offray On 17/04/17 23:59, Dimitris Chloupis wrote: > Moose devs made a Pillar rendered for GTInspector. Pillar is a > markdown inspired version for Pharo. > > http://forum.world.st/ann-pillar-support-in-gtinspector-td4913115.html > > We use Pillar to generate all our HTML and PDF documentation > > On Tue, 18 Apr 2017 at 00:44, nacho <0800nacho(a)gmail.com > <mailto:0800nacho@gmail.com>> wrote: > > I'm eager to test it! > One quick question, is there a way to render markdown inside an Image? > thanks > Nacho > > > > ----- > Nacho > Smalltalker apprentice. > Buenos Aires, Argentina. > -- > View this message in context: > http://forum.world.st/ANN-Prometheas-a-Pharo-wiki-database-tp4942110p494246… > Sent from the Pharo Smalltalk Users mailing list archive at > Nabble.com. >

April 18, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Esteban A. Maringolo

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

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] best practices for using external files for testing

by monty

XMLParser's XML-Tests-Conformance project, which is automatically generated from the W3C's Conformance Test Suites project (https://www.w3.org/XML/Test/) stores the contents of its files in class methods. This way it's self-contained, portable, and the actual files only need to be downloaded and unzipped to regenerate the TestCases. Consider extracting it into a separate project with a separate CI job if it gets too big. > Sent: Saturday, April 15, 2017 at 12:52 PM > From: "Peter Uhnak" <i.uhnak(a)gmail.com> > To: pharo-users(a)lists.pharo.org > Subject: [Pharo-users] best practices for using external files for testing > > 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] PostgreSQL and Pharo 6

by Esteban A. Maringolo

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] Exporting Packages to Cincom Smalltalk (VisualWorks)

by Peter Uhnak

Ah, I forgot about that one. (I've seen it before I wrote mine, but I didn't like some things iirc... like using string cocats instead of XMLWriter etc) Peter On Mon, Apr 17, 2017 at 04:42:52PM -0300, Esteban A. Maringolo wrote: > Thank you Peter. > > Alexandre Bergel pointed me to Roassal export classes, which does > something similar to the code you pointed me to (yours seems more > tidy). > > Thanks again, > > Esteban A. Maringolo > > > 2017-04-17 12:57 GMT-03:00 Peter Uhnak <i.uhnak(a)gmail.com>: > > Some time ago I hacked together a very simple thing that generates VW XML from code represented in Moose/UML... I guess you could use it as a starting point: https://github.com/OpenPonk/class-editor/tree/master/repository/UML-CodeGen… > > > > Also take a look at SIF (which is quite easy to use on both Pharo and VW side): > > > > * https://github.com/peteruhnak/sif > > * https://github.com/peteruhnak/sif/blob/master/docs.md > > * http://www.samadhiweb.com/blog/2016.01.06.sif.html > > * http://www.pocketsmalltalk.com/sif/ > > > > Peter > > > > On Mon, Apr 17, 2017 at 10:37:52AM -0300, Esteban A. Maringolo wrote: > >> Is there any exporter than can convert an RPackage into a VW Parcel > >> (.pst), in XML or Chunk format? > >> > >> I need to migrate a few libraries of my own and couldn't find > >> anything, so I'm asking before start writing something :) > >> > >> Regards! > >> > >> Esteban A. Maringolo > >> > > >

April 18, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

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

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 Dimitris Chloupis

Moose devs made a Pillar rendered for GTInspector. Pillar is a markdown inspired version for Pharo. http://forum.world.st/ann-pillar-support-in-gtinspector-td4913115.html We use Pillar to generate all our HTML and PDF documentation On Tue, 18 Apr 2017 at 00:44, nacho <0800nacho(a)gmail.com> wrote: > I'm eager to test it! > One quick question, is there a way to render markdown inside an Image? > thanks > Nacho > > > > ----- > Nacho > Smalltalker apprentice. > Buenos Aires, Argentina. > -- > View this message in context: > http://forum.world.st/ANN-Prometheas-a-Pharo-wiki-database-tp4942110p494246… > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. > >

April 18, 2017

Re: [Pharo-users] [ANN] Prometheas : a Pharo wiki database

by nacho

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 17, 2017