SQLite

select * from tools limit 1;

High-precision date/time in SQLite

A rich set of functions for working with date, time and durations.

Modern SQLite: Delete limit

To keep the query from taking forever.

Modern SQLite: Secure delete

Leave no trace of deleted data.

Modern SQLite: Generated columns

Build your own document database with SQLite.

Modern SQLite: STRICT tables

Strict column type checking, like in PostgreSQL or MySQL.

SQLite 3.45: Interactive release notes

JSONB has landed.

SQLite 3.44: Interactive release notes

Order by in aggregates, better string concatenation, and thorough date formatting.

Escaping macOS quarantine for SQLite extensions

Using the `sqlpkg` package manager.

Transferring SQLite extensions with Lockfile

Using the `sqlpkg` package manager.

SQLite package manager and registry

Find, install and manage SQLite extensions.

How to install an SQLite extension

To compensate for SQLite's missing features.

SQLite playground with extensions

70 additional functions are now available in Sqlime.

Python's sqlite3 with extensions

A drop-in replacement for the sqlite3 module, bundled with essential extensions.

Powerful string functions in SQLite

A rich set of Unicode-aware functions for working with text.

Hashing, encoding and decoding in SQLite

Calculating message digests and encoding/decoding binary data to a textual representation.

AI SQLite assistant

Ask AI to explain or troubleshoot your SQL query in a playground.

Interactive SQL examples in JavaScript

Turn static SQL code in your articles into executable examples.

Reading and writing files in SQLite

Working with files and traversing directories from SQL.

Building a pivot table in SQLite

Three ways to create a pivot table in plain SQL.

Regular expressions in SQLite

Use a robust pattern matching and text replacement tool from SQL.

User-defined functions in SQLite

Write functions in plain SQL.

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.