Compile and load SQLite extensions
How to compile the UUID extension
Archive
Today I Learned (TIL)
SQLite and primary key UUID columns
Auto-Generating UUID Primary Keys in SQLite: A Simple Default Value Trick
How to improve performances for SQL queries with IN and thousands of values
Using temporary tables to optimize queries