types

  • text -> str
  • int -> int
  • timestamp

where stmt

where <col1> <op1> <value1> <logic op1> <col2> <op2> <value2> ...

initialization

python / sqlite3

conn = sqlite3.connect(<db path>, detect_types=sqlite3.PARSE_DECLTYPES | sqlite3.PARSE_COLNAMES)
conn.row_factory = sqlite3.Row

notice: sqlite objects can't be used across different threads

create table

create table [if not exists] <name> (<col1 name> <col1 type>, <col2 name> <col2 type>, ...)

drop table

drop table [if exists] <name>

insert

insert into <table name> values (?, ?, ...)

delete

delete from <table name> where <where stmt>

update

update <table name> set <col1 name>=?, <col2 name>=?, ... where <where stmt>

query

select <cols> from <table name> [where <where stmt>] [order by <order col>] [offset <skip count>] [limit <result limit>]