[squeak-dev] Now available: a database conectivity API and its MySQL implementation

Anindya Haldar anindya_haldar at yahoo.com
Thu Sep 29 08:11:15 UTC 2011

I am extremely pleased to offer to the community a generic Smalltalk API for database connectivity API, along with a MySQL implementation written from ground up. Think of JDBC and DBI like interfaces in other languages and environments, and this one offers abstract facilities like connection, prepared statement, resultset, row, metdata and so on for the application.

The API implementation uses driver delegates, and insulates the applications from the driver specific interfaces. As of now, a MySQL implementation is available, with other databases engine supports in the future plans.
The API supports server side prepared statements and cursor based fetch implemented in the MySQL driver.

The implementation is currently available in 3 parts:

1) StdbCore project: This is primarily the API definitions and the delegation logic 
URL: http://www.squeaksource.com/StdbCore.html

2) StdbMysqlImpl project: This is the MySQL implementation of the StdbCore API
URL: http://www.squeaksource.com/StdbMysqlImpl.html

3) StdbMysqlProtocol project: This is the underlying MySQL protocol driver, and used by the MySQL API implementation
URL: http://www.squeaksource.com/StdbMysqlProtocol.html

There is a package load ordering dependency (documented in the MySQL implementation project). Please load the core and the protocol driver packages first, before you load the implementation package.

Combined, the packages has around 200 tests (most of them in the protocol driver and the API implementation) and are running green on Pharo 1.1.1 one click, Squeak 4.2 one click, Squeak 3.10 (with Seaside 2-8-573 dev image) under Mac OS X 10.5.8 with MySQL server 5.0.67.

This was in the making for some time; and I feel it is time to share it with the community. I will continue to post more documentation and code snippets in the project page Wiki sections. For now, looking up the tests may be your best guide.

Happy programming!

Anindya Haldar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeak-dev/attachments/20110929/fb14add0/attachment.htm

More information about the Squeak-dev mailing list