SQLite
Function Reference

This SQLite function reference covers all built-in functions with real SQL examples, version notes, and SQLite-specific quirk warnings. It is part of pgref.dev, which also covers PostgreSQL — making it easy to compare the two databases side by side.

SQLite is the world's most widely deployed database engine, used in mobile apps, browsers, embedded systems, and serverless environments. Unlike PostgreSQL or MySQL, SQLite is serverless, file-based, and uses flexible typing rather than rigid SQL types.

Key areas covered include: JSON functions (json_extract, json_set, json_each), date and time functions (strftime, unixepoch, timediff), window functions (row_number, lag, lead), and all core scalar functions.

Check the Quirks & Gotchas page for the most common SQLite surprises: flexible typing, foreign keys off by default, double-quoted string literals, and AUTOINCREMENT behaviour differences.