More lightweight software
12th March 2003
The other toy I’ve been playing with recently is SQLite. SQLite is an embeddable SQL database engine written in just under 25,000 lines of (heavily commented) C. Don’t let the size fool you—it’s phenomenally powerful and is released under a no-holds-barred public domain license that practically begs you to include it in your applications, commercial or not.
The feature list is pretty awesome—it’s two times faster than both mySQL and Postgres on simple operations, implements an impressive amount of the SQL92 standard (including transaction support) and has bindings for Tcl, PHP, Perl, Python and Java.
That said, the lack of a security model (databases are stored in a single file with no user authentication / permissions system) and the fact that it’s very much meant for embedding rather than featuring a client-server model mean it isn’t really suitable for web applications. Where it would shine (and where the author intended it to be used) is in applications that would benefit from an ultra fast relational database but don’t need the overhead of embedding a large system such as mySQL. The no-strings license makes it a tempting prospect for that kind of work as well.
Definitely one for the tool box.
More recent articles
- llamafile is the new best way to run a LLM on your own computer - 29th November 2023
- Prompt injection explained, November 2023 edition - 27th November 2023
- I'm on the Newsroom Robots podcast, with thoughts on the OpenAI board - 25th November 2023
- Weeknotes: DevDay, GitHub Universe, OpenAI chaos - 22nd November 2023
- Deciphering clues in a news article to understand how it was reported - 22nd November 2023
- Exploring GPTs: ChatGPT in a trench coat? - 15th November 2023
- Financial sustainability for open source projects at GitHub Universe - 10th November 2023
- ospeak: a CLI tool for speaking text in the terminal via OpenAI - 7th November 2023
- DALL-E 3, GPT4All, PMTiles, sqlite-migrate, datasette-edit-schema - 30th October 2023
- Now add a walrus: Prompt engineering in DALL-E 3 - 26th October 2023