1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
.. currentmodule:: apsw
.. _extensions:
Extensions
**********
SQLite includes a number of extensions providing additional
functionality. All extensions are disabled by default and you need to
:ref:`take steps <setup_build_flags>` to have them available at compilation
time, to enable them and then to use them.
.. _ext-fts3:
FTS5
====
`FTS5 <https://www.sqlite.org/fts5.html>`__ is the full text search
extension.
.. _ext-icu:
ICU
===
The ICU extension provides an `International Components for Unicode
<https://en.wikipedia.org/wiki/International_Components_for_Unicode>`__
interface, in particular enabling you do sorting and regular
expressions in a locale aware way. The `documentation
<https://sqlite.org/src/tree?name=ext/icu>`__
shows how to use it.
.. _ext-rbu:
RBU
===
Provides `resumable bulk update <https://www.sqlite.org/rbu.html>`__ intended for
use with large SQLite databases on low power devices at the edge of a network.
.. _ext-rtree:
RTree
=====
The RTree extension provides a `spatial table
<https://en.wikipedia.org/wiki/R-tree>`_ - see the `documentation
<https://sqlite.org/rtree.html>`__. There are no additional APIs and
the `documented SQL <https://sqlite.org/rtree.html>`__ works as is.
|
