Friday, January 21, 2005

SQLite: An embeddable database

OK, this has been written about by others, but it's so cool, I had to mention it myself!

As the home page explains, "...SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.." It's ACID compliant, the data files are portable across different machine architectures, it can handle respectable amounts of data (up to 2 TB) and it comes with Python bindings. :-P

It's seems like a great way to store application data without having to force users to install MySQL/PostgreSQL or hacking up a custom (probably buggy) solution.

I can't wait to use it!

2 comments:

Anonymous said...

It's really very fast, simple and portable...

Arsalan Zaidi said...

Sure is! I'm using it as a development DB for TurboGears. Very easy to use and set up. Fast too.