[Q] How suitable is Squeak for Database work

Cees de Groot cg at cdegroot.com
Sat Jan 4 11:36:12 UTC 2003


Avi Bryant <avi at beta4.com> said:
>Sorry, I wasn't very clear: I've used Squeak with ODBC on Windows, Linux,
>and Mac OS X, and been grateful for it.  However, unlike Dolphin or other
>Windows-only systems, Squeak cannot (IMO) rely on ODBC to provide
>database abstraction.  Installing and configuring the ODBC
>libraries on unix or Mac OS, and making them work with Squeak, is a
>non-trivial chore, whereas the MySQL driver, for example, works as soon as
>you file it in - even, I imagine, on an Acorn ;).
>
That's a matter of making choices and acting on it. The Unix ODBC package
consists of two parts: a driver manager and drivers. The driver manager is a
thing you could probably do away with; the drivers are .so files that all
conform to the same interface. If you rewrites part of the driver manager in
Smalltalk (basically, the thing manages a mapping of 'data source names' to
driver+configuration instances), you can create a bundle of .so files for the
various platforms and off you go. For Windows, the 'Squeak driver manager'
could simply reroute everything to the native ODBC layer. 

BTW: we may ask Exept - I just did a locate for 'odbc' on my box in order to
find the license for iODBC, and it turns out that Exept seems to have an ODBC
library...

BTW2: iODBC (www.iodbc.org) comes under a dual license, LGPL and BSD. 


-- 
Cees de Groot               http://www.cdegroot.com     <cg at cdegroot.com>
GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD  1986 F303 937F E098 9E8B
Cogito ergo evigilo



More information about the Squeak-dev mailing list