Skip to content
On this page

SQL

SQLBolt & SQL Teaching are nice SQL intros.

dsq is neat. SQL Indexing and Tuning book has many tips. PRQL & GlueSQL seem nice too.

Arctype is a nice tool. ReadySet is great SQL caching engine.

Partial State in Dataflow-Based Materialized Views is nice paper on which ReadySet & Noria are based.

Interested in using Malloy to query my Postgres db as it's plenty fast and is more ergonomic than SQL to use. It's query language reminds me of EdgeQL by EdgeDB.

Code

sql
-- get schema for table users
pragma table_info(users);

Notes