SQLite

http://www.sqlite.org/

Important Notes

Omitted SQL Language Features
http://www.sqlite.org/omitted.html

SQLite Keywords
http://www.sqlite.org/lang_keywords.html
you cannot choose table names from the keywords list!!!

enforce foreign keys
SQLite Foreign Key Trigger Generator: http://www.rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_trigger_generator
http://glossar.hs-augsburg.de/SQLite_Foreign_Keys_erzwingen
http://sqlzoo.net/howto/source/u.cgi/tip241028/sqlite

Jump Start

SQLite with Python

http://docs.python.org/library/sqlite3.html
http://www.wdvl.com/Authoring/python/SQLite/Watts07162009.html

Admin tools / GUIs

SQLiteStudio

http://sqlitestudio.one.pl/

Open Source, cross platform!

SQLite Database Browser

http://sqlitebrowser.sourceforge.net/

sudo apt-get install sqlitebrowser

Sqliteman

http://sqliteman.com/

sudo apt-get install sqliteman

SQLite Plugin for Firefox

http://sqlite-manager.googlecode.com/
https://addons.mozilla.org/en-US/firefox/addon/5817

Comments