[Question] Extension support: json1, fts5

[rodydavis]

How can I install extensions for SQLite?

In drift for example I declare a build.yaml:

targets:
  $default:
    builders:
      drift_dev:
        options:
          store_date_time_values_as_text: true
          mutable_classes: true
          sql:
            dialect: sqlite
            options:
              version: "3.35"
              modules:
                - json1
                - fts5
                - math

[rkistner]

For Drift, those options control the SQL dialect used when compiling queries, not the modules being installed.

JSON1 is enabled by default in all SQLite builds since 3.38.0. FTS5 is also included by default when you use sqlite3_flutter_libs.

For other extensions:

1. You need a binary distribution for all relevant platforms, or a build script to produce it.
2. Use a custom SqliteOpenFactory to load the extension whenever a connection is opened.
3. See SqliteExtension from the sqlite3 package for details on loading that.

An example for steps 2 and 3 above is here.