![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
SQLite is nifty
Feb. 13th, 2006 11:57 pmIf 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.
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.
