[SqueakDBX] [ANN] SqueakDBX, Glorp and GlorpDBX loads easily in Pharo

[Mariano Martinez Peck]

On Wed, Aug 19, 2009 at 5:58 AM, Torsten Bergmann <astares at gmx.de> wrote:

> Hi Mariano,
>
> thanks. I appreciate that someone is looking into
> RDMBs interfacing and OR-Mapping, although I had'nt yet
> time to play with all your recent work.
>
> Three questions:
>
> Whats the state of SqueakDBX (supported DB's, ...)
>

You can see this information here: http://wiki.squeak.org/squeak/6108
In summary PostgreSQL, Oracle and Sqlite3 works ok in Mac, Linux and
Windows.
MySQL works on Mac and Linux but we have problems in Windows :(
SQL Server works on Linux and Windows and wasn't tested on Mac.
Firebird, Interbase and Sybase ASE are supported by OpenDBX but were never
tested in SqueakDBX. So, they *should* work.


>
> Is PostgreSQL still required for Glorp?


If you evaluate GlorpPharoLoader loadGlorpWithNativePostgreSQLDriver
this will download the normal Glorp which requieres PostgreSQL. However, we
have refactored this and now Glorp doesn't depends on a particular driver
but to an abstract class DatabaseDriver. This refactor is now in SqueakDBX
repo (it will then be in Glorp repo) with the name of GlorpDBX.
So, if you download GlorpDBX you won't require PostgreSQL native driver, but
SqueakDBX. You can also download only Glorp and use another driver.
All of this stuff (GlorpDBX) is still in development and only works with
PostgreSQL and Oracle


> What if I want to
> use Glorp with say SQLite?
>

You can, but not right now. You have to wait a bit ;)   You will be able to
use SqueakDBX with Sqlite or create a Glorp Driver (subclass of
DatabaseDriver) for it if there exist another SQLite driver.


>
> Any comments on Glorp vs. SqueakSave?


I must admit I have never (yet) used any of them to production applications.
So I will give only my point of view:

Glorp:

- seems to have more "successful stories"
- Has the CINCOM sponsor (in VW of course)
- More flexible and useful for medium / big applications
- Requieres time doing the mappings
- The Squeak version is old (thanks Diógenes is doing a new port)

SqueakSave:

- Not yet in stable release
- Excellent situation for small / medium projects
- You don't spend time doing mappings
- I don't know if it works on Pharo.
- Use MySQL or PostgreSQL but perhaps they create another adaptor for
SqueakDBX


Torsten know there is a SqueakDBX mailing list in case you have particular
questions of it. It is here:
http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx

Best,

Mariano


>
>
> Thanks
> Torsten
>
> --
> Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
> für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02
>
> _______________________________________________
> Pharo-project mailing list
> Pharo-project at lists.gforge.inria.fr
> http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20090819/8e57d09b/attachment.htm