2009 Sqlite3

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:
http://www.sqlite.org/cintro.html
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
(see <http://sqlite.org/lang_insert.html>):

   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.

HTH,
</jum>

O ile nie zaznaczono inaczej, treść tej strony objęta jest licencją Creative Commons Attribution-ShareAlike 3.0 License