Skip to content

SQLite 3.34.1 New Features

Xojo 2021 Release 1 updates its SQLite engine to 3.34.1 (from 3.33.0). This release does not have a lot of new features, but there are a few notable ones that you might find useful.

First, the performance of WAL mode (write-ahead logging) is improved when there are lots of connections all accessing the same database file. This ought to provide noticeable improvements for web apps that use SQLite databases.

If you use full text searching with FTS5, you can now enable trigram indexing to allow search terms to better match within text blocks.

A minor change is that the “substr()” SQL function can now also be called “substring()” for compatibility with SQL Server.

There are a few other performance improvements as well. Visit the SQLite site to read the official release notes.

Find more SQLite tips