Today’s subject: SQLite
I’m a novice programmer. As such, I often find that a lot of the sample code and documentation I find online goes over my head. I can’t be the only one for whom this is true.
Thus, I thought I’d post a little sample application I wrote that demonstrates some of the basic functionality of SQLite, the “self-contained, serverless, zero-configuration, transactional SQL database engine.”
We’re using SQLite to track materials data in our GENIUS application, but this sample program, which I wrote for practice, creates two music-related tables: an iTunes-like table of song information and a table of phone numbers of Madison-area clubs (stored as arrays of integers to demonstrate how to handle blobs).
It doesn’t do much and certainly shouldn’t be used for any real applications, but I nevertheless hope that you find this program helpful if you’re trying to learn SQLite. I try to explain things as completely as possible, but I didn’t want to annotate the arguments for every function call, so you’ll need to consult the SQLite documentation as well. Finally, special thanks to the author of this example, which I unfortunately found much too late.