Weblog entry #69 for Steve
See all weblog entries made by Steve.
The more I use SQLite the more I love it.
If only I had something interesting to actually use it for. Right now I'm just experimenting with mixing SQLite with Memcache.
I'm sure I could use it for something but I'm not sure what.
Oh well. Maybe I'll get inspired later.
Comments on this Entry
I have a few functions that record when I change directories (cd, pushd, popd) and log various information to a few files. I use SQLite with perl to read in those files and join them so I have a complete audit trail of where I've been and what I've done. SQLlite is the perfect solution for this as there is no other access from other users, and I don't need a outside connection.
Another advantage that SQLite has over mysql is the EXCEPT keyword. This is very handy when trying to find something that does not exist in a table without using the 'NOT IN' or 'NOT EXIST' constructs (which are extremely slow, noticably on large tables).
The script is in crude state but I can send it to you if you like.
(libdave@gmail.com)
[ Parent | Reply to this comment ]
[ Send Message | View Steve's Scratchpad | View Weblogs ]
I'd not need that level of auditing to be honest, although it sounds like an interesting solution!
My approach is to use revision control to each of my service control files, e.g. apache's setup. That allows me to keep track of changes, and allow synchronised updates across an array of machines.
[ Parent | Reply to this comment ]
why do you choose sqlite over a version control system for that task?
Are there any hidden advantages or is it just a fun way to learn something new? (which is a very valid point, imho).
[ Parent | Reply to this comment ]