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 );

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.