few notes on beginning
Nice start is playing with sqlite3 from command line:
sqlite3: A command-line access program for SQLite databases
Another a while we would like to start trying with C/C++ code…. no problem:
greate place to learn C coding of sqlite are MultiC sources: http://multic.sourceforge.net/ -> http://sourceforge.net/projects/multic/ .
few tips and tricks
Combination of INSERT and UPDATE
have you ever wanted to put sth into SQL table without worring about wheter is already exists ?
I've found here a nice solution from "Jens Miltner <jum () mac ! com>" :
Assuming you know the profile id, just use an INSERT OR REPLACE query
INSERT OR REPLACE INTO profile VALUES(...)
Will insert a new record if none with that id exists or replace the
data of the record with the given ID if it already exists.