January 2018 - Pharo-users - lists.pharo.org

Re: [Pharo-users] Examples of Garage for DB2

by Esteban Lorenzano

I think if you use old compiler it will work: SmalltalkImage compilerClass: Compiler. Esteban > On 3 Jan 2018, at 17:42, Andrei Stebakov <lispercat(a)gmail.com> wrote: > > I tried before to install odbc. > Gofer new > squeaksource: 'ODBC'; > package: 'ConfigurationOfODBC'; load. > (Smalltalk at: #ConfigurationOfODBC) load. > > When I execute the code above I got an exception doesNotUnderstand: #selector in RBParser>>externalFunctionDeclaration. Looks like currentScope variable is not defined. > Also if I install ODBC from the catalog it also fails. > I still don't see how postgres can help but I'll give it another try. > > On Jan 3, 2018 11:05, "Pierce Ng" <pierce(a)samadhiweb.com <mailto:pierce@samadhiweb.com>> wrote: > On Wed, Jan 03, 2018 at 10:12:32AM -0500, Andrei Stebakov wrote: > > Pierce, I couldn't find any smalltalk framework to work with DB2 at this > > point. I couldn't also find any Pharo odbc library. That's why at this > > point I am looking for any ideas how to connect to DB2 from Pharo. > > I suppose Instantiations VA Smalltalk will be able to talk to DB2. I'm quite > sure Dolphin Smalltalk does ODBC too. > > Staying with Pharo, assuming you have known-working DB2 ODBC driver for Windows > installed and ODBC to DB2 configured, try this: > > http://smalltalkhub.com/#!/~PharoExtras/ODBC/ <http://smalltalkhub.com/#!/~PharoExtras/ODBC/> > > Most recent commit was in Apr 2015 by Torsten 'switching to newer FFI'. So > hopefully this works with Pharo 6.1. > > If the above doesn't work, but you know that the Windows DB2 ODBC driver works, > then - I'm not being facetious - install PostgreSQL, set up PostgreSQL foreign > data wrapper to ODBC, and talk to PostgreSQL using Pharo. > > http://www.postgresonline.com/journal/archives/372-ODBC-FDW-now-supports-9.… <http://www.postgresonline.com/journal/archives/372-ODBC-FDW-now-supports-9.…> > > Or, set up Python's SQL Alchemy for DB2, install PostgreSQL, set up PostgreSQL > foreign data wrapper to SQL Alchemy, and talk to PostgreSQL using Pharo. > > https://wiki.postgresql.org/wiki/Foreign_data_wrappers <https://wiki.postgresql.org/wiki/Foreign_data_wrappers> > https://github.com/Kozea/Multicorn <https://github.com/Kozea/Multicorn> > > HTH. > >

Jan. 3, 2018

Re: [Pharo-users] Examples of Garage for DB2

by Andrei Stebakov

I tried before to install odbc. Gofer new squeaksource: 'ODBC'; package: 'ConfigurationOfODBC'; load. (Smalltalk at: #ConfigurationOfODBC) load. When I execute the code above I got an exception doesNotUnderstand: #selector in RBParser>>externalFunctionDeclaration. Looks like currentScope variable is not defined. Also if I install ODBC from the catalog it also fails. I still don't see how postgres can help but I'll give it another try. On Jan 3, 2018 11:05, "Pierce Ng" <pierce(a)samadhiweb.com> wrote: > On Wed, Jan 03, 2018 at 10:12:32AM -0500, Andrei Stebakov wrote: > > Pierce, I couldn't find any smalltalk framework to work with DB2 at this > > point. I couldn't also find any Pharo odbc library. That's why at this > > point I am looking for any ideas how to connect to DB2 from Pharo. > > I suppose Instantiations VA Smalltalk will be able to talk to DB2. I'm > quite > sure Dolphin Smalltalk does ODBC too. > > Staying with Pharo, assuming you have known-working DB2 ODBC driver for > Windows > installed and ODBC to DB2 configured, try this: > > http://smalltalkhub.com/#!/~PharoExtras/ODBC/ > > Most recent commit was in Apr 2015 by Torsten 'switching to newer FFI'. So > hopefully this works with Pharo 6.1. > > If the above doesn't work, but you know that the Windows DB2 ODBC driver > works, > then - I'm not being facetious - install PostgreSQL, set up PostgreSQL > foreign > data wrapper to ODBC, and talk to PostgreSQL using Pharo. > > http://www.postgresonline.com/journal/archives/372-ODBC-FDW- > now-supports-9.5-and-9.6.html > > Or, set up Python's SQL Alchemy for DB2, install PostgreSQL, set up > PostgreSQL > foreign data wrapper to SQL Alchemy, and talk to PostgreSQL using Pharo. > > https://wiki.postgresql.org/wiki/Foreign_data_wrappers > https://github.com/Kozea/Multicorn > > HTH. > > >

Jan. 3, 2018

Re: [Pharo-users] Examples of Garage for DB2

by Pierce Ng

On Wed, Jan 03, 2018 at 10:12:32AM -0500, Andrei Stebakov wrote: > Pierce, I couldn't find any smalltalk framework to work with DB2 at this > point. I couldn't also find any Pharo odbc library. That's why at this > point I am looking for any ideas how to connect to DB2 from Pharo. I suppose Instantiations VA Smalltalk will be able to talk to DB2. I'm quite sure Dolphin Smalltalk does ODBC too. Staying with Pharo, assuming you have known-working DB2 ODBC driver for Windows installed and ODBC to DB2 configured, try this: http://smalltalkhub.com/#!/~PharoExtras/ODBC/ Most recent commit was in Apr 2015 by Torsten 'switching to newer FFI'. So hopefully this works with Pharo 6.1. If the above doesn't work, but you know that the Windows DB2 ODBC driver works, then - I'm not being facetious - install PostgreSQL, set up PostgreSQL foreign data wrapper to ODBC, and talk to PostgreSQL using Pharo. http://www.postgresonline.com/journal/archives/372-ODBC-FDW-now-supports-9.… Or, set up Python's SQL Alchemy for DB2, install PostgreSQL, set up PostgreSQL foreign data wrapper to SQL Alchemy, and talk to PostgreSQL using Pharo. https://wiki.postgresql.org/wiki/Foreign_data_wrappers https://github.com/Kozea/Multicorn HTH.

Jan. 3, 2018

Re: [Pharo-users] Examples of Garage for DB2

by Andrei Stebakov

Pierce, I couldn't find any smalltalk framework to work with DB2 at this point. I couldn't also find any Pharo odbc library. That's why at this point I am looking for any ideas how to connect to DB2 from Pharo. On Jan 3, 2018 09:52, "Pierce Ng" <pierce(a)samadhiweb.com> wrote: > On Tue, Jan 02, 2018 at 02:10:03PM -0500, Andrei Stebakov wrote: > > I downloaded Garage to my Pharo 6.1 on windows. But in Garage I only see > > drivers for MySql, Postgres and Sqlite3. > > Does it mean that for DB2 I should look somewhere else or there is a way > to > > create a connection for DB2 using existing Garage functionality? > > Garage uses the OpenDBX C language database access library underneath. > Looking > at https://linuxnetworks.de/doc/index.php?title=OpenDBX/Support, it > doesn't > look OpenDBX supports DB2. > > Does the Windows DB2 ODBC driver work? Does Pharo successfully use the ODBC > driver to talk to DB2? > > Pierce > >

Jan. 3, 2018

Re: [Pharo-users] Metacello with Git

by Alistair Grant

Hi Stef, On 2 January 2018 at 20:11, Stephane Ducasse <stepharo.self(a)gmail.com> wrote: > Hi Alistair > > About pillar, we are working on a new pipeline and lot of cleaning > compared to the version available on smalltalkhub. > The new version Branch new pipeline seems broken (I will check it > tomorrow it cannot handle internal references). > I want to be able to build the old books with the new version. Now it > is not working. > > Stef Yep, I remember you also mentioning that you're planning to decouple the core Pillar from Magritte and Grease. All of this will make our lives easier. Thanks, Alistair > On Tue, Jan 2, 2018 at 6:08 PM, Alistair Grant <akgrant0710(a)gmail.com> wrote: >> Hi Sean, >> >> On 2 January 2018 at 18:00, Sean P. DeNigris <sean(a)clipperadams.com> wrote: >>> EstebanLM wrote >>>> if you have iceberg metacello integration enabledâ¦ Then it works on >>>> baselines, etc. >>> >>> Strange. I did `Iceberg enableMetacelloIntegration: true.` first and still >>> got the error. I can't easily test in 7 because it depends on Magritte which >>> depends on Grease which doesn't seem to load yet. Maybe I can cobble >>> together a simpler test case. >> >> This may not help, but... >> >> Pharo 7.0 >> Build information: >> Pharo-7.0+alpha.build.398.sha.52a28a857deec25612d302aba8ab09bdd6212b31 >> (32 Bit) >> >> I have Pillar loaded, which in turn loads: >> >> ConfigurationOfMagritte3-topa.126 >> Magritte-Model-SeanDeNigris.465 >> Magritte-Morph-SeanDeNigris.95 >> Magritte-Pharo3-Model-JohnCBorden.4 >> ConfigurationOfGrease-StephanEggermont.348 >> Grease-Core-JohanBrichau.97 >> Grease-Pharo30-Core-PavelKrivanek.22 >> >> The image was built about 4 days ago. >> >> HTH, >> Alistair >> >> >> >>> The Git error I mentioned in my OP was caused because `LGitRepository >> >>> clone:options:to:` is trying to clone >>> 'git@bitbucket.org:nDeNigris/Quote-Me.git' based on >>> `gitlab://SeanDeNigris/Quote-Me:master/repository` from the baseline spec. >>> Earlier in the stack, `IceProviderRepositoryType >> mcRepository` is using >>> `MCBitbucketRepository` which is hardcoded. >>> >>> All of the above is with iceberg metacello integration enabled. >>> >>> >>> >>> ----- >>> Cheers, >>> Sean >>> -- >>> Sent from: http://forum.world.st/Pharo-Smalltalk-Users-f1310670.html >>> >> >

Jan. 3, 2018

Re: [Pharo-users] Examples of Garage for DB2

by Pierce Ng

On Tue, Jan 02, 2018 at 02:10:03PM -0500, Andrei Stebakov wrote: > I downloaded Garage to my Pharo 6.1 on windows. But in Garage I only see > drivers for MySql, Postgres and Sqlite3. > Does it mean that for DB2 I should look somewhere else or there is a way to > create a connection for DB2 using existing Garage functionality? Garage uses the OpenDBX C language database access library underneath. Looking at https://linuxnetworks.de/doc/index.php?title=OpenDBX/Support, it doesn't look OpenDBX supports DB2. Does the Windows DB2 ODBC driver work? Does Pharo successfully use the ODBC driver to talk to DB2? Pierce

Jan. 3, 2018

Re: [Pharo-users] Object Persistence

by Manuel Leuenberger

Hi Stef, The Neo4j Cypher queries express a subgraph/path that you want to match in the big graph (nodes and edges with attributes). No fragmentation due to normalization etc., so no joins, itâs more like a regex matcher: MATCH p=(x:PERSON)-[:KNOWS*]->(:PERSON) WHERE x.name = 'John' RETURN p; Will give you the graph of all persons John knows and all the persons they know (transitive closure). You can also combine multiple queries that one processes the result of the other (pipes and filters). See https://neo4j.com/developer/cypher-query-language/ OutOfMemory only happens if your query selects more data (at any point) than you have memory, as the query execution happens entirely in memory, there seems to be no flush do disk. But there are ways to work around this (albeit resulting in uglier partitioned queries). You can see it in action for my KOWALSKI tool, collecting API clients and extracting call graphs: https://youtu.be/zdx28GnoSRQ <https://youtu.be/zdx28GnoSRQ> Cheers, Manuel > On 31 Dec 2017, at 11:19, Stephane Ducasse <stepharo.self(a)gmail.com> wrote: > > Hi manuel > > what kind of queries can we express? > Can be get select node? > Now out of memory is a read falg for me (for moose because we do that > all the time). > > Stef > > > On Tue, Dec 26, 2017 at 10:03 PM, Manuel Leuenberger > <leuenberger(a)inf.unibe.ch> wrote: >> Iâve always liked Neo4j to persist object graphs. Also has a nice query language. The database is not fool-proof (isolation issues, out of memory on expensive queries), but works fine for analytics. >> >>> On 25 Dec 2017, at 10:43, Ian Ian <icjohnsoia(a)gmail.com> wrote: >>> >>> Hi All, >>> >>> Thoughts of a purely OO nature? >>> >>> :) >> >> >

Jan. 3, 2018

Formatted print for Duration

by Julien

Hello, I do not see how to do a formatted print from a duration. I would like to be able to do something like: String streamContents: [ :s | 90 minutes formatted: âhh:mmâ printOn: s ] The Duration>>#printOn: method prints the ANSI 5.8.2.16 format: [-]D:HH:MM:SS[.S] The Duration>>#printHumanReadableOn: is not printing in the format I want. Am I missing something or such feature does not exist actually? Julien --- Julien Delplanque Doctorant Ã lâUniversitÃ© de Lille 1 http://juliendelplanque.be/phd.html Equipe Rmod, Inria BÃ¢timent B 40, avenue Halley 59650 Villeneuve d'Ascq NumÃ©ro de tÃ©lÃ©phone: +333 59 35 86 40

Jan. 3, 2018

How to justify text in pillar booklets ?

by Steven Costiou

Hi, i am using the pillar booklet tools from https://github.com/SquareBracketAssociates/Booklet-PublishingAPillarBooklet How can i justify all paragraphs in the generated spiral book, instead of having all of it aligned to left ? Steven.

Jan. 3, 2018

Re: [Pharo-users] Metacello with Git

by Norbert Hartl

> Am 03.01.2018 um 00:26 schrieb Sean P. DeNigris <sean(a)clipperadams.com>: > > EstebanLM wrote >> yep. that seems to be a bug. > > Okay, I hacked a solution. Before I submit the fix I want to verify: no one > has been successfully using gitlab:// URLs in a MetaC baseline spec for a > private dependent project (accessed via SSH keys), right? > > There were no classes to support it. Only github and bitbucket. So, yes!! Norbert > > ----- > Cheers, > Sean > -- > Sent from: http://forum.world.st/Pharo-Smalltalk-Users-f1310670.html

Jan. 3, 2018