Sqlite

Links

• https://www.sqlitetutorial.net/sqlite-tutorial/

Performance tuning sqlite

TODO

Cheatsheetje

Show tables

.tables

Select all from table

select * from mytable;

Describe table

.schema mytable

Describe all tables

.schema

FAQ

Check integrity

PRAGMA integrity_check;