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

Re: [Pharo-users] Oracle on Linux

by Norbert Hartl

> Am 02.04.2015 um 13:55 schrieb Esteban Lorenzano <estebanlm(a)gmail.com>: > > >> On 02 Apr 2015, at 13:13, Norbert Hartl <norbert(a)hartl.name <mailto:norbert@hartl.name>> wrote: >> >> >>> Am 02.04.2015 um 12:52 schrieb Esteban A. Maringolo <emaringolo(a)gmail.com <mailto:emaringolo@gmail.com>>: >>> >>> I don't know if you need full fledged access or just to read a few tables. >>> >>> If it the latest you can use PostgreSQL Foreign Data Wrappers (FDW) and access the pgsql instance using the existing PGv2 driver. >>> >>> I know it might look convoluted, and maybe it is, but you avoid using DBX. >>> >>> >> I would also avoid using oracle which is a prerequisite, right? :) So DBX is to avoid? Sorry, I didn't care very much about SQL engines the last years. > > why DBX is to avoid? I don't know. I read the sentence "I know it might look convoluted, and maybe it is, but you avoid using DBX." as avoiding DBX is something positive. So I want to know as well. > in linux, it is your only chance for connecting to oracle (in windows you could also use odbc). > and it should be working, AFAIK > I'm fine with using DBX as long as it works. I understood also that it is one of the higher prioritized tasks for the consortium. Norbert > Esteban > >> >> Norbert >> >>> Regards. >>> >>> Ps: FDW are amazing. >>> >>> El abr 2, 2015 6:07 AM, "Norbert Hartl" <norbert(a)hartl.name <mailto:norbert@hartl.name>> escribiÃ³: >>> I see from time to time topics like SQL popping up. Most of the time DBXTalk seems to be a requirement. It is also something that is considered necessary for a lot of people. Now have the need to access an oracle database. Is that possible? And if yes does it also work on linux? >>> >>> Norbert >> >

April 2, 2015

Re: [Pharo-users] Oracle on Linux

by Mariano Martinez Peck

Norbert, OpenDBXDriver worked for Oracle in Linux. Not sure the state about right now (FFI status etc), but with some work it should work. On Thu, Apr 2, 2015 at 8:55 AM, Esteban Lorenzano <estebanlm(a)gmail.com> wrote: > > On 02 Apr 2015, at 13:13, Norbert Hartl <norbert(a)hartl.name> wrote: > > > Am 02.04.2015 um 12:52 schrieb Esteban A. Maringolo <emaringolo(a)gmail.com > >: > > I don't know if you need full fledged access or just to read a few tables. > > If it the latest you can use PostgreSQL Foreign Data Wrappers (FDW) and > access the pgsql instance using the existing PGv2 driver. > > I know it might look convoluted, and maybe it is, but you avoid using DBX. > > I would also avoid using oracle which is a prerequisite, right? :) So DBX > is to avoid? Sorry, I didn't care very much about SQL engines the last > years. > > > why DBX is to avoid? > in linux, it is your only chance for connecting to oracle (in windows you > could also use odbc). > and it should be working, AFAIK > > Esteban > > > Norbert > > Regards. > > Ps: FDW are amazing. > El abr 2, 2015 6:07 AM, "Norbert Hartl" <norbert(a)hartl.name> escribiÃ³: > >> I see from time to time topics like SQL popping up. Most of the time >> DBXTalk seems to be a requirement. It is also something that is considered >> necessary for a lot of people. Now have the need to access an oracle >> database. Is that possible? And if yes does it also work on linux? >> >> Norbert >> > > > -- Mariano http://marianopeck.wordpress.com

April 2, 2015

Re: [Pharo-users] OrderedCollection remove:

by Alexandre Bergel

col := #(1 2 3 4 5) asOrderedCollection. col copy do: [ :each | col remove: each. ]. col will work instead Alexandre -- _,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;: Alexandre Bergel http://www.bergel.eu ^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;. > On Apr 2, 2015, at 3:22 AM, Peter UhnÃ¡k <i.uhnak(a)gmail.com> wrote: > > Hi, > > I've just run into quite a nasty surprise > ~~~~~~~~~~~~~~~~ > col := #(1 2 3 4 5) asOrderedCollection. > col do: [ :each | col remove: each. ]. > col > ~~~~~~~~~~~~~~~~ > it throws "NotFound: nil not found in OrderedCollection" > I tested it also in Pharo3 and there it just silently removed first, third and fifth element. > > Looking at the implementation of OrderedCollection>>do: it seems that doing what I'm doing is a bad idea. > > So what shall one do:? col copy do: [...] ? > > Why can't do: be a bit smarter? Optimization? > > Thanks, > Peter

April 2, 2015

Re: [Pharo-users] what to use for simple parsing

by Thierry Goubier

2015-04-02 11:49 GMT+02:00 phil(a)highoctane.be <phil(a)highoctane.be>: > Sure works. > > Regex > > '((XXX Logical Channel) ([0-9])) on (((Upstream)|(Downstream)) ([0-9])) on > ((chassis) ([0-9])), ((slot) ([0-9])), ((mac) ([0-9]))' asRegex > > But in PP, things were more comple and there were a lot of them, so: > > line > ^ temperatureStatusDescrEntry token asParser > / temperatureStatusValueEntry token asParser > / temperatureThresholdEntry token asParser > / temperatureLastShutdownEntry token asParser > / temperatureStateEntry token asParser > and things like > > temperatureStatusDescrEntry ^ temperatureStatusDescrOidPrefix, oidIndex, > space, equals, space, stringType, space, displayStringValue. > > made my day much easier. > > Especially when I had all the tokens I needed: > > gauge32Type ^'Gauge32:' asParser flatten ==> [:str | #gauge32]. > > > Not sure it would have been as flexible with a SmaCC (I am not familiar > with SmaCC but used Lex/Yacc|Bison in another life). > SmaCC is a lot (and I mean a lot) simpler than Flex/bison, especially for the interaction between Flex and Bison (in short, SmaCC infer all the token/keyword stuff as well as the api between the two objects, behaving like a scannerless system). For everything like keywords, for example, you don't even bother with the token: Gauge32Type: "Gauge32:" { #gauge32 } ; And of course you would: TemperatureStatusDescrEntry : TemperatureStatusDescrOidPrefix OidIndex Space "=" Space StringType Space DisplayStringValue (Everytime I read PetitParser code, I see the SmaCC grammar, usually in a more verbose form (asParser, asToken)... ) Some of the benefits of SmaCC are not that obvious in fact. Coming from the Flex/Bison world, what is striking is the multithreading ability of the SmaCC parser infrastructure: they have no global/shared space and you can create as many instances of them as you like, as often as you like... A second benefit, but harder to use, is the AST node automatic generation, with the api, an equality and visitors: this makes all the code appearing behind an SmaCC parser very regular. However, if you derive on a regular basis grammars, the SmaCC API is not designed for that. It could do it (you could maybe include other grammars, for example), but nobody has expressed that need :) Thierry

April 2, 2015

Re: [Pharo-users] Oracle on Linux

by Esteban Lorenzano

> On 02 Apr 2015, at 13:13, Norbert Hartl <norbert(a)hartl.name> wrote: > > >> Am 02.04.2015 um 12:52 schrieb Esteban A. Maringolo <emaringolo(a)gmail.com <mailto:emaringolo@gmail.com>>: >> >> I don't know if you need full fledged access or just to read a few tables. >> >> If it the latest you can use PostgreSQL Foreign Data Wrappers (FDW) and access the pgsql instance using the existing PGv2 driver. >> >> I know it might look convoluted, and maybe it is, but you avoid using DBX. >> >> > I would also avoid using oracle which is a prerequisite, right? :) So DBX is to avoid? Sorry, I didn't care very much about SQL engines the last years. why DBX is to avoid? in linux, it is your only chance for connecting to oracle (in windows you could also use odbc). and it should be working, AFAIK Esteban > > Norbert > >> Regards. >> >> Ps: FDW are amazing. >> >> El abr 2, 2015 6:07 AM, "Norbert Hartl" <norbert(a)hartl.name <mailto:norbert@hartl.name>> escribiÃ³: >> I see from time to time topics like SQL popping up. Most of the time DBXTalk seems to be a requirement. It is also something that is considered necessary for a lot of people. Now have the need to access an oracle database. Is that possible? And if yes does it also work on linux? >> >> Norbert >

April 2, 2015

Re: [Pharo-users] Oracle on Linux

by Norbert Hartl

> Am 02.04.2015 um 12:52 schrieb Esteban A. Maringolo <emaringolo(a)gmail.com>: > > I don't know if you need full fledged access or just to read a few tables. > > If it the latest you can use PostgreSQL Foreign Data Wrappers (FDW) and access the pgsql instance using the existing PGv2 driver. > > I know it might look convoluted, and maybe it is, but you avoid using DBX. > > I would also avoid using oracle which is a prerequisite, right? :) So DBX is to avoid? Sorry, I didn't care very much about SQL engines the last years. Norbert > Regards. > > Ps: FDW are amazing. > > El abr 2, 2015 6:07 AM, "Norbert Hartl" <norbert(a)hartl.name <mailto:norbert@hartl.name>> escribiÃ³: > I see from time to time topics like SQL popping up. Most of the time DBXTalk seems to be a requirement. It is also something that is considered necessary for a lot of people. Now have the need to access an oracle database. Is that possible? And if yes does it also work on linux? > > Norbert

April 2, 2015

Re: [Pharo-users] Oracle on Linux

by Tudor Girba

I managed to access Oracle through DBXTalk but on Windows 7. Cheers, Doru On Thu, Apr 2, 2015 at 11:06 AM, Norbert Hartl <norbert(a)hartl.name> wrote: > I see from time to time topics like SQL popping up. Most of the time > DBXTalk seems to be a requirement. It is also something that is considered > necessary for a lot of people. Now have the need to access an oracle > database. Is that possible? And if yes does it also work on linux? > > Norbert > -- www.tudorgirba.com "Every thing has its own flow"

April 2, 2015

Re: [Pharo-users] Oracle on Linux

by Esteban A. Maringolo

I don't know if you need full fledged access or just to read a few tables. If it the latest you can use PostgreSQL Foreign Data Wrappers (FDW) and access the pgsql instance using the existing PGv2 driver. I know it might look convoluted, and maybe it is, but you avoid using DBX. Regards. Ps: FDW are amazing. El abr 2, 2015 6:07 AM, "Norbert Hartl" <norbert(a)hartl.name> escribiÃ³: > I see from time to time topics like SQL popping up. Most of the time > DBXTalk seems to be a requirement. It is also something that is considered > necessary for a lot of people. Now have the need to access an oracle > database. Is that possible? And if yes does it also work on linux? > > Norbert >

April 2, 2015

Re: [Pharo-users] what to use for simple parsing

by kilon alios

yeap you use what makes your life easier ;) On Thu, Apr 2, 2015 at 12:49 PM, phil(a)highoctane.be <phil(a)highoctane.be> wrote: > Sure works. > > Regex > > '((XXX Logical Channel) ([0-9])) on (((Upstream)|(Downstream)) ([0-9])) on > ((chassis) ([0-9])), ((slot) ([0-9])), ((mac) ([0-9]))' asRegex > > But in PP, things were more comple and there were a lot of them, so: > > line > ^ temperatureStatusDescrEntry token asParser > / temperatureStatusValueEntry token asParser > / temperatureThresholdEntry token asParser > / temperatureLastShutdownEntry token asParser > / temperatureStateEntry token asParser > and things like > > temperatureStatusDescrEntry ^ temperatureStatusDescrOidPrefix, oidIndex, > space, equals, space, stringType, space, displayStringValue. > > made my day much easier. > > Especially when I had all the tokens I needed: > > gauge32Type ^'Gauge32:' asParser flatten ==> [:str | #gauge32]. > > > âNot sure it would have been as flexible with a SmaCC (I am not familiar > with SmaCC but used Lex/Yacc|Bison in another life). > > Phil >

April 2, 2015

Re: [Pharo-users] OrderedCollection remove:

by jtuchel＠objektfabrik.de

Peter, several approaches have been shown already. I'd like to add: * Iterate over a copy and remove from the original (slower because of lookup in the original) * If possible, sort the collection and use something like [col atEnd] whileTrue:/whileFalse: with removeFirst/removeLast * Select: a collection of items to be removed and then do a removeAll: * Use #- to remove one collection from the other * Iterate over the original and add only the wanted objects to a new collection which will then be used in the future - Streams may be helpful here * I have never used XStreams, but there may even be some nice options to find in it HTH Joachim Am 02.04.15 um 09:33 schrieb Peter UhnÃ¡k: > On Thu, Apr 2, 2015 at 8:30 AM, Joachim Tuchel > <jtuchel(a)objektfabrik.de <mailto:jtuchel@objektfabrik.de>> wrote: > > In general, removing from a Collection while iterating through it > leads to undefined results. The same is true for adding. > > That is a question of approach; apart from mentioned #copy I could > also do something like > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > col := #(1 2 3 4 5) asOrderedCollection. > [col isNotEmpty] whileTrue: [ col remove: col first ]. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > if I had an Iterator I could also reset it after each change. > > What I am asking is what the best approach would be - I want do some > processing for each item and remove it from the collection after it is > done. > > Peter

April 2, 2015