Squeak and SQlite Database

Jarvis, Robert P. (Contingent) Jarvisb at timken.com
Thu Jul 25 13:33:15 UTC 2002


For a database used with Squeak (or any Smalltalk) I'd say that the
important thing is that it should store objects, i.e. be an object database.
Relational databases are too concerned with bits-and-bytes.  Minnestore is a
possibility, but its development has apparently ceased for the time being.
Are there any other open-source, publicly available object databases for
Smalltalk?

Bob Jarvis
Compuware @ Timken

> -----Original Message-----
> From: Stephen Pair [mailto:spair at acm.org]
> Sent: Thursday, July 25, 2002 9:20 AM
> To: squeak-dev at lists.squeakfoundation.org
> Subject: RE: Squeak and SQlite Database
> 
> 
> For me, the important thing for Squeak (as far as DBs are 
> concerned) is
> to have structured (Btree, Hash, etc) access to secondary 
> storage.  It's
> also good to have some options regarding where the physical storage
> resides and where the DB processing occurs (i.e. local or a remote
> machine and disk) as well as transactions, logging, rollback, 
> etc.  SQL
> access is far less important (IMHO).
> 
> So far, the only database that I've come across that meets these
> fundamentals is BerkeleyDB...does anyone know of others that 
> are similar
> in nature to BerkeleyDB (I'd like to have some options for what I'm
> working on).
> 
> In regard to a "platform independent common Squeak database," I think
> that it should be qualified as a "platform independent common 
> Squeak SQL
> database API"...meaning that rather than try and pick a single SQL
> database for all platforms and applications, you specify an 
> API that is
> sufficiently robust to handle a wide variety of SQL database
> implementations.  Also, we should be precise and call it an "SQL"
> database API to distinquish it from the many other types of databases
> that exist and would need their own API.
> 
> - Stephen 
> 
> > -----Original Message-----
> > From: squeak-dev-admin at lists.squeakfoundation.org 
> > [mailto:squeak-dev-admin at lists.squeakfoundation.org] On 
> > Behalf Of Torsten.Bergmann at phaidros.com
> > Sent: Thursday, July 25, 2002 3:03 AM
> > To: squeak-dev at lists.squeakfoundation.org
> > Subject: Squeak and SQlite Database
> > 
> > 
> > Is anybody using or planning to use the SQLite 
> > database with Squeak ? (http://www.hwaci.com/sw/sqlite/)
> > 
> > From the page:
> > 
> > SQlite is a C database engine in a small C library.
> > Programs that link with the SQLite library can have SQL database 
> > access without running a separate RDBMS process. 
> > 
> > Features:
> > - Implements a large subset of SQL92. 
> > - A complete database (with multiple tables and indices) is 
> stored in 
> >   a single disk file. 
> > - Atomic commit and rollback protect data integrity. 
> > - Small memory footprint: less than 20K lines of C code.
> > - Four times faster than PostgreSQL
> > - very simple C/C++ Interface requieres the use of only three 
> > functions
> >   and an opaque structure
> > - Build and tested under Linux and Win2000
> > - Source are uncopyrighted. Use for any purpose.
> > 
> > Could this be the base for platform independent common squeak 
> > database ?
> > 
> > Bye
> > Torsten
> > 
> > 
> 
> 


**********************************************************************
This message and any attachments are intended for the 
individual or entity named above. If you are not the intended
recipient, please do not forward, copy, print, use or disclose this 
communication to others; also please notify the sender by 
replying to this message, and then delete it from your system. 

The Timken Company
**********************************************************************




More information about the Squeak-dev mailing list