[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
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