SQLite 3.33.0 Released
August 14, the developers of SQLite announced the latest release of the relational database “SQLite 3.33.0”. It is available for download from the project website.
SQLite is an SQL database written in C language. It is designed to be lightweight, fast, reliable, and versatile. It can be used as a standalone database to run on and be embedded into any OS. With a stable file format, SQLite promises backward compatibility until 2050.
SQLite 3.33 is the successor of v3.32, released in May. This latest release increased the maximum size of database files to 281 TB.
This release has added support for UPDATE-FROM, which executes UPDATE statement driven by other tables. Being compatible with PostgreSQL syntax, this allows you to join the target table against the other tables in the database.
It also added the decimal extension for doing arbitrary-precision decimal arithmetic. PRAGMA integrity_check statement has been extended so that it can optionally be limited to verifying just a single table and its indexes, rather than the entire database file.
There are improvements added to the command-line interface (CLI) and query planner. CLI now includes four new output modes, “box”, “json”, “markdown”, and “table”. “Column” output mode automatically extends to contain the longest output row. The WAL (Write-Ahead Logging) is also improved.