[ANN] ESUG supports once again SqueakDBX

MM
Mariano Martinez Peck
Fri, Mar 4, 2011 8:40 AM

We are really happy to announce that ESUG will sponsor us once again through
the ESUG Summer Talk project. This means that we have reached the ESUG
expectations and that they still think that relational database access is an
important matter in Smalltalk.

One important thing is that we are going to rename the project (we are still
working on it) since SqueakDBX runs not only in Squeak but also in Pharo,
and there have been even ports to Dolphin. What's the reason for this
decision? Because we do not want to couple ourselves to a smalltalk dialect
nor to OpenDBX, because our project is much more than that (later I will
tell you about our plans). So, these are some of the possible names:
ObjectPark, SmallParking, Parktalk, SmallValet, Valetalk, ValetST,
NorayTalk, Ballard, Noray and Cruise. Please let us know which one is your
favourite or help us find a new one.

Another important subject is the team. There will be three "mentors",
Esteban Lorenzano, Diogenes Moreira and myself, Mariano Martinez Peck; and
three students: Guillermo Polito, Nicolas Scarcella and Santiago Bragagnolo.

We are open to suggestions and ideas. In addition, we have defined a
possible list of actions that I copy at the end of the email.

For the moment, the url remains www.squeakdbx.org and the mailing list
squeakdbx@lists.squeakfoundation.org

Once again, we want to thank ESUG for their support and trust.

Thank you very much,

SqueakDBX team

Possible list of actions:

  1. Change SqueakDBX’s name.

  2. Update GLORP version since the actual one is 3 years old.

Port it again from VisualWorks, create a VW porting tool (may be).
Complete support to Glorp.  Today it works with PostgreSQL, Oracle and
MySQL.  Make it work with most databases OpenDBX supports.

  1. Create a lightweight solution, alternatively to GLORP.  There are some
    options:

Make SqueakSave work with SqueakDBX.  SqueakSave developers already
contacted us because they wanted to do it. SqueakSave seems to be 20% slower
than Glorp but you don't need to write the mappings :)
Adapt Ramon Leon's active record to use an abstract database driver, and
create a driver for SqueakDBX.
Port the new Glorp’s kind of active record to Pharo. (included in 2).

  1. Write a Pharo By Example 2 chapter based on the card game Stef built ;).

  2. Cog compatibility.

  3. Use Alien instead of FFI.
    Eliot is working on a threaded CogVM. One of the projects of the GSoC of
    this year was to make something similar to a threaded FFI. What the student
    did is a modification in Alien (I think) that can be run in a multithreaded
    envirorment. He worked with Eliot. The idea is when Eliot releases the
    threaded CogVM, this FFI would work our of the box, and would avoid locking
    the WHOLE vm while a C function is being invoked (as it happens today with
    FFI).....So....when that VM is released, we MUST migrate to that).

  4. Explore performance issues (maybe with our approach of "In thread
    execution plugin").

  5. Complete integration with OpenDBX. For example, Oracle, for large objects
    (Clob, Blob, etc) use specific functions. There are specific functions in
    OpenDBX that have to be used if the database uses specific functions (oracle
    is the only one for the moment.). We don't manage those functions yet.

  6. In this link http://www.squeakdbx.org/Targets%20and%20Features
    You can see a list of future possible features like Connection pooling (now
    it is done!), Prepared statement interface, Store procedures, Escape and
    avoid of SQL insertion, Authentication support: extends to other methods,
    not only user/password, Full text support, etc.

We are really happy to announce that ESUG will sponsor us once again through the ESUG Summer Talk project. This means that we have reached the ESUG expectations and that they still think that relational database access is an important matter in Smalltalk. One important thing is that we are going to rename the project (we are still working on it) since SqueakDBX runs not only in Squeak but also in Pharo, and there have been even ports to Dolphin. What's the reason for this decision? Because we do not want to couple ourselves to a smalltalk dialect nor to OpenDBX, because our project is much more than that (later I will tell you about our plans). So, these are some of the possible names: ObjectPark, SmallParking, Parktalk, SmallValet, Valetalk, ValetST, NorayTalk, Ballard, Noray and Cruise. Please let us know which one is your favourite or help us find a new one. Another important subject is the team. There will be three "mentors", Esteban Lorenzano, Diogenes Moreira and myself, Mariano Martinez Peck; and three students: Guillermo Polito, Nicolas Scarcella and Santiago Bragagnolo. We are open to suggestions and ideas. In addition, we have defined a possible list of actions that I copy at the end of the email. For the moment, the url remains www.squeakdbx.org and the mailing list squeakdbx@lists.squeakfoundation.org Once again, we want to thank ESUG for their support and trust. Thank you very much, SqueakDBX team Possible list of actions: 1) Change SqueakDBX’s name. 2) Update GLORP version since the actual one is 3 years old. Port it again from VisualWorks, create a VW porting tool (may be). Complete support to Glorp. Today it works with PostgreSQL, Oracle and MySQL. Make it work with most databases OpenDBX supports. 3) Create a lightweight solution, alternatively to GLORP. There are some options: Make SqueakSave work with SqueakDBX. SqueakSave developers already contacted us because they wanted to do it. SqueakSave seems to be 20% slower than Glorp but you don't need to write the mappings :) Adapt Ramon Leon's active record to use an abstract database driver, and create a driver for SqueakDBX. Port the new Glorp’s kind of active record to Pharo. (included in 2). 4) Write a Pharo By Example 2 chapter based on the card game Stef built ;). 5) Cog compatibility. 6) Use Alien instead of FFI. Eliot is working on a threaded CogVM. One of the projects of the GSoC of this year was to make something similar to a threaded FFI. What the student did is a modification in Alien (I think) that can be run in a multithreaded envirorment. He worked with Eliot. The idea is when Eliot releases the threaded CogVM, this FFI would work our of the box, and would avoid locking the WHOLE vm while a C function is being invoked (as it happens today with FFI).....So....when that VM is released, we MUST migrate to that). 7) Explore performance issues (maybe with our approach of "In thread execution plugin"). 8) Complete integration with OpenDBX. For example, Oracle, for large objects (Clob, Blob, etc) use specific functions. There are specific functions in OpenDBX that have to be used if the database uses specific functions (oracle is the only one for the moment.). We don't manage those functions yet. 9) In this link http://www.squeakdbx.org/Targets%20and%20Features You can see a list of future possible features like Connection pooling (now it is done!), Prepared statement interface, Store procedures, Escape and avoid of SQL insertion, Authentication support: extends to other methods, not only user/password, Full text support, etc.
GC
Geert Claes
Fri, Mar 4, 2011 11:34 AM

I understand the reasoning behind the name change but I am unsure about some
of the possible names.

Since it is a Smalltalk solution to access relational databases the first
name that popped in my head was something like "RDBTalk"

Mariano Martinez Peck wrote:

...
So, these are some of the possible names:
ObjectPark
SmallParking
Parktalk
SmallValet
Valetalk
ValetST,
NorayTalk
Ballard
Noray
Cruise
..

--
View this message in context: http://forum.world.st/ANN-ESUG-supports-once-again-SqueakDBX-tp3334862p3335095.html
Sent from the ESUG mailing list archive at Nabble.com.

I understand the reasoning behind the name change but I am unsure about some of the possible names. Since it is a Smalltalk solution to access relational databases the first name that popped in my head was something like "RDBTalk" Mariano Martinez Peck wrote: > > ... > So, these are some of the possible names: > ObjectPark > SmallParking > Parktalk > SmallValet > Valetalk > ValetST, > NorayTalk > Ballard > Noray > Cruise > .. > -- View this message in context: http://forum.world.st/ANN-ESUG-supports-once-again-SqueakDBX-tp3334862p3335095.html Sent from the ESUG mailing list archive at Nabble.com.
MM
Mariano Martinez Peck
Sat, Mar 5, 2011 10:29 AM

On Fri, Mar 4, 2011 at 12:34 PM, Geert Claes geert.wl.claes@gmail.comwrote:

I understand the reasoning behind the name change but I am unsure about
some
of the possible names.

Since it is a Smalltalk solution to access relational databases the first
name that popped in my head was something like "RDBTalk"

Thanks Geert. We will take all suggetions into account. We received several
private emails also.

Mariano Martinez Peck wrote:

...
So, these are some of the possible names:
ObjectPark
SmallParking
Parktalk
SmallValet
Valetalk
ValetST,
NorayTalk
Ballard
Noray
Cruise
..

--
View this message in context:
http://forum.world.st/ANN-ESUG-supports-once-again-SqueakDBX-tp3334862p3335095.html
Sent from the ESUG mailing list archive at Nabble.com.


Esug-list mailing list
Esug-list@lists.esug.org
http://lists.esug.org/mailman/listinfo/esug-list_lists.esug.org

On Fri, Mar 4, 2011 at 12:34 PM, Geert Claes <geert.wl.claes@gmail.com>wrote: > I understand the reasoning behind the name change but I am unsure about > some > of the possible names. > > Since it is a Smalltalk solution to access relational databases the first > name that popped in my head was something like "RDBTalk" > > Thanks Geert. We will take all suggetions into account. We received several private emails also. > > Mariano Martinez Peck wrote: > > > > ... > > So, these are some of the possible names: > > ObjectPark > > SmallParking > > Parktalk > > SmallValet > > Valetalk > > ValetST, > > NorayTalk > > Ballard > > Noray > > Cruise > > .. > > > > > -- > View this message in context: > http://forum.world.st/ANN-ESUG-supports-once-again-SqueakDBX-tp3334862p3335095.html > Sent from the ESUG mailing list archive at Nabble.com. > > _______________________________________________ > Esug-list mailing list > Esug-list@lists.esug.org > http://lists.esug.org/mailman/listinfo/esug-list_lists.esug.org >