MySQL vrs SQLite

[Alan Gauld]

On Wed, 05 May 2004 22:41:35 -0000, Dave Benjamin
<ramen at lackingtalent.com> wrote:
> In article <mailman.283.1083787205.25742.python-list at python.org>, Michael wrote:
> > I'm considering changing a Python program of mine, that uses MySQL as 
> > it's db backend, to use SQLite. .... Any draw backs to making this change?

No direct experience but doesn't SQLite store its data in memory?
If you have a large database that could lead to problems on PCs
with a small memory installation or running lots of apps?

On the other hand if the data volume is small SQLite could offer
significant performance gains over a disk oriented architecture
like MySQL etc.

Just a thought.

Alan G.
Author of the Learn to Program website
http://www.freenetpages.co.uk/hp/alan.gauld