SQLite 3: What's New, Release History & EOL Status

What Is New in SQLite 3

SQLite 3 introduces a range of updates from performance enhancements to new syntax and functions. The changes are focused on making the database faster, more reliable, and easier to work with in modern applications.

What JSONB support does SQLite 3 add?

SQLite 3.45.0 introduced a new JSONB format for storing and processing JSON data. This is a binary representation of JSON that is both faster to parse and more compact to store compared to the traditional text-based JSON.

In practice, this means functions like json() and json_extract() can operate more efficiently. The original text JSON format remains fully supported, so existing applications won't break. You can choose the format that best fits your needs for each specific use case.

How have STRICT tables evolved?

STRICT tables, introduced in an earlier version, now offer even better data integrity. They enforce type constraints on every column, rejecting any insert or update that uses a value of the wrong datatype.

This matters because it moves SQLite closer to the type safety found in other SQL databases. It prevents a whole class of subtle data errors that can happen when integers get stored as strings or vice versa. For new development, using STRICT tables is a smart way to write more robust applications.

What performance optimizations were made?

The query planner received significant attention, with optimizations for Bloom filters and ORDER BY clauses. These changes help the database avoid unnecessary sorting and filtering steps, speeding up complex queries.

There were also under-the-hood improvements to reduce memory allocation (malloc) pressure. This translates to better overall performance, especially in applications that execute a high volume of database operations or handle large datasets.

What new SQL functions are available?

Several new built-in functions were added to extend SQLite's capabilities. The math library was expanded with functions like cbrt() (cube root) and sqrt() (square root).

Datetime handling got easier with the new unixepoch() function. The CLI saw additions too, like the .connection command for managing multiple database connections. These functions provide more tools for data manipulation directly within your SQL queries.