I've been really hung up on this program since I "discovered" it about a year ago. It's a honest to goodness SQL database engine implemented in less than 200 kilobytes. I am talking about SQLite.
The software is in the public domain, which is interesting all by itself, and it's been integrated into tons of commercial programs and devices. SQLite features include:
- No configuration or administration needed
- Serverless
- Supports transactions
- Cross platform
- Fast!
- Public domain
I use SQLite to track weather data that I collect at my home. I've also used the software as the heart of a simple, yet fairly smart, amateur radio logging program built with SQLite and a bash script.
SQLite fits nicely into the simple computing philosophy. It works well from the command line and without a lot of "moving parts" it's extremely reliable. The database files are portable across different OS's and filesystems and the entire database is in a single file which makes copying or backing up a database as easy as copying one file. In fact I carry several databases around on a small USB stick. For those that absolutely need a gui, there is a light weight front end available as a Firefox extension, however I prefer to use it from a command line.
No comments:
Post a Comment