[Q] Databases -- Gadfly vs Metakit vs SQLite

[David LeBlanc]

> -----Original Message-----
> From: python-list-admin at python.org
> [mailto:python-list-admin at python.org]On Behalf Of achrist at easystreet.com
> Sent: Saturday, March 15, 2003 17:02
> To: python-list at python.org
> Subject: Re: [Q] Databases -- Gadfly vs Metakit vs SQLite
>
>
> "yaipa h." wrote:
> >
> > If you are not worried about cross platform, then why not
> > use the Jet (access) DB.
>
> Yes, that's part of Windows, so it's almost safe to assume that it's
> there, and you can get to it through com.  However, I don't want to
> worry one bit about what version is there or if MS will put in changes
> in subsequent releases that will break my application.  And I'd rather
> embed the database so that I don't have to worry about the user changing
> it with an MS desktop app to violate my rules of relational integrity
> and crash my app.
>
>
> Al

Aside from it's dubious parentage, Jet has a reputation for being
excruciatingly slow. I believe, but am not positive, that Outlook uses Jet
and there are times when Outlook is incredibly slow. With a lot of saved
mail message, and after a normal shutdown, Outlook can take several minutes
to startup. It can take a noticable time to switch from viewing one email to
another in the same folder!

Sqlite is my db of choice for it's rubustness, performance, licensing
(totally unencumbered!) and the fact that it comes from a developer with a
sterling reputation across no less than 3 language groups.

Dave LeBlanc
Seattle, WA USA