SqueakDBX 1.2 release

We are realeasing SqueakDBX 1.2, just an small release. For those who doesn’t know, SqueakDBX is a database driver to connect to most of the existing databases.

For more details, please read www.squeakdbx.org

The main changes in this release are:

• ConfigurationOfSqueakDBX version: 1.2
• Comments: SqueakDBX stable 1.2
• OpenDBX version: 1.5
• New Features
  • GlorpDBX connection pool for SqueakDBXDriver.
  • New support for Firebird 100% green tests in Windows.
  • New support for MySQL 4.
  • New tests for PostgreSQL sequences, for bad data settings.
  • We now let a platform to set special options ALWAYS before opening the connection.
  • Packages remodularization and little changes so that to easily support ports, for example to Dolphin.
  • Start to support large objects. For the moment: Postgresql supports TEXT, MySQL supports TEXT and BLOB, and SQLite CLOB (error with BLOB), Oracle supports CLOB and NCLOB.
  • Added the possibility to enable or disable automatic release of connections using WeakRegistry.
• Notes
  • Tested with Cog, resulting in an average of 3x increase.
  • Tested in Pharo 1.0 and 1.1.
  • Updated Metacello configurations

To install it:

Gofer new squeaksource: ’MetacelloRepository’; package: ’ConfigurationOfSqueakDBX’; load.

(ConfigurationOfSqueakDBX project version: ’1.2’) load.

In Pharo 1.1 I recommend to evaluate the following:

DBXPlatform disableAutomaticConnectionReleaseOnGC

Cheers

Mariano

New support for Firebird!!!

We are glad to announce that we now support Firebird as backend. The good news for us is that it just took 4 hours to get it working and even with the 100% of the tests in green.

OpenDBX supports Firebird since a lot of time but we didn’t have too much time to try it. I wanted to "give a hand" to Norbert generating all dlls for each new release. I didn’t have ever used Firebird neither Sybase. So, I started with Firebird and now it is working like a charm.

I have only tested in Windows (sorry, I am having some problems with my Linux machine) but it should work also in Linux and Mac.

To use Firebird you must be sure to use the version OpenDBX-Core-MarianoMartinezPeck.252. You can install the latests version of SqueakDBX using our new Metacello configuration. To do this, take a Pharo image and evaluate the following:

Gofer new

squeaksource: ’MetacelloRepository’;

addPackage: ’ConfigurationOfSqueakDBX’;

load.

And then evaluate:

(ConfigurationOfSqueakDBX project version: ’1.1-baseline’) load

This will download the latest version, which will be 1.1 and is still in development.

Finally, I wrote all my notes of how to compile OpenDBX with Firebird in Windows using MinGW. Of course, you don’t need to do this as you have already the dll, but just in case. The link is: http://www.squeakdbx.org/Firebird%20for%20Win

Cheers

New OpenDBX 1.5.0 release

Hi folks. Just wanted to let you know that Norbert released a new version of OpenDBX. This version is the first one of the new series 1.5. I have tested all backends in Linux and Windows and works perfect with the latets versions of SqueakDBX.

However, I will look deeper in the new features because maybe there are some improvements I can do in SqueakDBX because of this new release.

This release is important because it shows that OpenDBX is alive, with a lot of work and good progress.

Here is the link of the ANN: http://www.linuxnetworks.de/doc/index.php/News and here you can see the changelog: http://linuxnetworks.de/opendbx/download/ChangeLog-devel

Thanks Norbert!

Mariano

Metacello configurations

Hi folks!

We just wanted to let you know that we have just build Metacello configurations for SqueakDBX and GlorpDBX. You can find both in the repository

http://www.squeaksource.com/MetacelloRepository

You can download the configurations and evaluate something like this:

(ConfigurationOfSqueakDBX project version: ’1.1’) load

And that will loaded all the necesarry stuff for SqueakDBX version 1.1.

The same with GlorpDBX:

(ConfigurationOfGlorpDBX project version: ’0.9.1’) load

Cheers,

SqueakDBX with MySQL in Snow Leopard 64 bits

As you may know, there are some problems with the SqueakVM on 64 bits and FFI. So, if you have a 64 architecture, the most common approach is to use a 32 bits Squeak/Pharo VM. The problem here is how to install OpenDBX and the client libraries.

In this case, we had:

• Mac Snow Leopard 64 bits
• SqueakVM is 32 bits.
• MySQL

So, let’s start installing the MySQL client libraries. To do that, you should do something like:

sudo port install mysql5-devel

But...that library is compiled with 64 bits by default. Thus, when OpenDBX tries to load that library, you may get the following error:

oLoadModule(libopendbx.dylib): dlopen(libopendbx.dylib, 10): no suitable image found. Did find: libopendbx.dylib: mach-o, but wrong architecture /usr/local/lib/libopendbx.dylib: mach-o, but wrong architecture

So, we tried to do something like this:

CFLAGS="-m32" CXXFLAGS="-m32" sudo port install mysql5-devel

but we got the same results. Probably the flags are ignored :(

So, the solution we found was to download a precompiled MySQL client library for 32 bits. It is here: http://dev.mysql.com/downloads/mysql/5.1.html and download the file titled: "Mac OS X 10.5 (x86)"

Install it.

After that, you should compile OpenDBX like this:

CFLAGS="-m32" CXXFLAGS="-m32" CPPFLAGS="-I/usr/local/mysql-5.1.40-osx10.5-x86/include" LDFLAGS="-L/usr/local/mysql-5.1.40-osx10.5-x86/lib" ./configure --enable-singlelib --disable-utils --with-backends="mysql"

With this, you should have all SqueakDBX tests in green :)