Squeak and SQlite Database

Avi Bryant avi at beta4.com
Thu Jul 25 16:36:12 UTC 2002


On Thu, 25 Jul 2002, Jarvis, Robert P. (Contingent) wrote:

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

We'll have to wait a few more days, but Magma is about to be released:
http://minnow.cc.gatech.edu/squeak/2632

There's also the GOODS interface, which I haven't used or worked on for a
while, but somebody could resurrect if they felt like it:
http://swiki.squeakfoundation.org/sea/20




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