SQLite Query Optimization: Using Uncorrelated Subqueries to Skip Correlated Subqueries for Performance Gains

Batches in SQLite

Using batch statements to increase the query performance in SQLite databases.

Introducing the first alpha of Turso: The next evolution of SQLite

Faster schema changes for large SQLite databases

SQLite Retrieval Augmented Generation and Vector Search

ClickHouse® tips #6: Filtering data in subqueries to avoid joins

Faster JOINs without joining: use WHERE instead. This ClickHouse tip speeds up queries that don't actually need full joins.

Using Postgres as a task queue for rowdy Gophers

A tutorial on making fast and efficient queues in PostgreSQL