Re: SQLite and friends

[prev] [thread] [next] [lurker] [Date index for 2005/05/26]

From: Matt McLeod
Subject: Re: SQLite and friends
Date: 03:05 on 26 May 2005
Chris Devers wrote:
> On Wed, 25 May 2005, Simon Wistow wrote:
> 
> > I'm using SQLite for rapid prototyping
> 
> ...and now you see why it probably isn't appropriate for anything other
> than rapid prototyping.

There are cases where you want some pretty basic data storage,
don't want to depend on having a server running, and would like
to use SQL for queries anyway.  A package manager would be a good
example of something where SQLite isn't as bad a choice as you
make it sound.

That said, we reject lots of open source packages as possible
solutions because they depend on MySQL.  If you have to stuff
data in a real database (and we'd rather you didn't, usually)
then it's Postgres, Ingres, or nothing at all.

For me, MySQL hate is about people doing stupid shit with it that 
would've been better off either not in a database at all or in a real 
database.  SQLite is better suited to much of the former category.

Matt
(A monitoring system that requires MySQL?  Why, what a clever idea!
 So what happens to your monitoring when MySQL is being updated?)

There's stuff above here

Generated at 04:00 on 26 May 2005 by mariachi 0.52