SQLite is nifty

[lilfluff]

If you've spent any time wanting to play around with programming involving in SQL database, take a look at SQLite. A database engine so compact that the driver is the engine. Where MySQL's download is measured in megabytes, SQLite's is measured in kilobytes.

And despite that it's still quite useful. Decent SQL support, triggers, transactions, and other nifty stuff. It's included as a start feature in PHP 5.0, is supported in Perl, Python, C, Java, multiple DLL's to use it from Visual Basic, there's an ODBC driver to let any program that talks ODBC use it (again, the engine is embedded into the drivers) Ruby, and plenty of languages from Ada to Tcl/Tk.

Over the course of an hour I whipped together a set of perl programs that created a database, put a few entries in, and then viewed them. Which included time refreshing my limited perl skills.

Nifty.

Comments

[snipersock.livejournal.com]

Very true. I do a lot of perl development and sometimes it is hard to test larger applications that use database interfaces. Instead of trying to time and lock in mysql or pgsql handlers, I'll setup a dummy sqlite file and have all of the perl tests use that local database instead.

On a side note, there are a ton of applications that use SQLite that you wouldn't of expected. Iti s really getting a lot of attention.