SQLite

An OLTP DBMS

Difference From Standard SQL Query

• There is support for LEFT OUTER JOIN but not RIGHT OUTER or FULL OUTER.
  • To get equivalent output to RIGHT OUTER you can reverse the order of the tables (i.e. A RIGHT JOIN B is the same as B LEFT JOIN A.
  • While it isn’t required to complete this assignment, the equivalent to FULL OUTER JOIN can be done by UNIONing RIGHT OUTER and LEFT OUTER
• There is no regex match (~) tilde operator. You can use LIKE instead.
• There is no ANY or ALL operator.

Architecture

SQLite works by compiling SQL text into bytecode, then running that bytecode using a virtual machine.

Links

• Litestream SQLite Replication
• DuckDB
• Architecture of SQLite
• Why SQLite Uses Bytecode