User-defined functions in SQLite

Write functions in plain SQL.

Common Table Expressions in SQL

Use them instead of subqueries.

Temporary tables in SQLite

For faster exploratory data analysis.

JSON and virtual columns in SQLite

Faster JSON handling in a relational database.

Generated columns in SQLite

Simplify queries without storing additional data.

Multi-line queries in SQLite shell

How to edit a big query without leaving the CLI

SQLite CLI command history

Search for the query instead of typing it by hand.

The ultimate SQLite extension set

Regexes, math, file IO and over 100 other functions.

What's new in SQLite 3.37

Strict tables, any type and a new pragma.

SQLite playground in the browser

I have built an online SQL playground with vanilla JS and a bit of GitHub API. Here's how.

SQLite is not a toy database

Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.

How to create a 1M record table with a single query

With recursive CTE and randomized data.

SQLite is not so easy to compile

But with GitHub Actions it is.

What's new in SQLite 3.35

Math functions, column removal and RETURNING clause.