SUSPECT: Re: Python, xml, databases, ...

[Gerhard Häring]

Pieter Claerhout wrote:
> SQLite is easier to embed since you don't need to install anything
> seperately. Include the neccesary Python modules and shared libraries, and
> you can create databases. With Firebird, MySQL and PostgreSQL, you need to
> install separate software. If I'm not mistaking, performance wise, SQLite
> will be faster, 

Well, it depends. In one simple-minded benchmark I've once done, PostgreSQL was 
significantly faster. The SQL was nontrivial and I suppose PostgreSQL was better 
at optimizing it. As akways with databases, it'll depend on the benchmark and the 
amount of (query) optimization effort you put in for each database.

> but I'm not sure how it handles large databases (let's say 100 MB or more).

SQLite works fine with databases of several Gigabytes from what I hear on its 
mailing list, sufficient hardware and tuning provided.

-- Gerhard