SQLite includes a number of extensions providing additional functionality. All extensions are disabled by default and you need to take steps to have them available at compilation time, to enable them and then to use them.


FTS5 is the full text search extension.


The ICU extension provides an International Components for Unicode interface, in particular enabling you do sorting and regular expressions in a locale aware way. The documentation shows how to use it.


Provides resumable bulk update intended for use with large SQLite databases on low power devices at the edge of a network.


The RTree extension provides a spatial table - see the documentation. There are no additional APIs and the documented SQL works as is.