Cheatsheet request: SQLite

[timogoosenwork]

SQLITE.

Some stuff to add:

Enable foreign key support
PRAGMA foreign_keys = ON

Turn on WAL:

PRAGMA journal_mode=WAL;

[boxxeronfly]

A few more that I find helpful

General Examples

SELECT * FROM table WHERE value IS 'correct value'

SELECT column_name As new_name FROM table WHERE value LIKE 'similar value'

Get Tables from database

SELECT name FROM sqlite_master WHERE type='table'

Query JSON embed fields (that are not null, make sure JSON extension is enabled.)

SELECT json_extract(json_column_name, '$.first_key.second_key) FROM myTable WHERE json_extract(json_column_name, '$.first_key.second_key) IS NOT NULL