SQLite essentials

SQLite docs: http://www.sqlite.org/docs.html

Date Types: http://www.sqlite.org/datatype3.html

• null, inteteger, real, text, blob

SQLite does not have a date/time time – dates stored in either text, real or integer columns are converted appropriately to that type.

Table relationships

create table person (id integer primary key asc, name text);

create table address( id integer primary key asc,
  person_id references person( id ),
  add_line1 text );