Upgrading SQLite

This document lists the steps needed to upgrade the sources in this repository with the latest revision from upstream.

Source Directory

The upgrade takes place on androidx-main. The primary directory is below.

external/sqlite

The upgrade steps are:

  • Select a version for the upgrade.
  • Find the amalgamation zip file. For release 3.50.1, the URL is sqlite-amalgamation-3500100.zip.
  • Extract the content of the direcoty into external/sqlite/src, it should contain the following files:
    • shell.c
    • sqlite3.c
    • sqlite3.h
    • sqlite3ext.h
  • Update the version and year in sqlite-bundled's build file:
frameworks/support/sqlite/sqlite-bundled/build.gradle

    it.sqliteVersion.set("3.50.1")
    it.sqliteReleaseYear.set(2025)
  • Update METADATA and README.version located in external/sqlite.

LICENSE

This file contains the license that allows Android to use the third-party software. SQLite is unusual because it has no license: it is in the public domain. The current file content is below.

The author disclaims copyright to this source code.  In place of
a legal notice, here is a blessing:

   May you do good and not evil.
   May you find forgiveness for yourself and forgive others.
   May you share freely, never taking more than you give.

Version Test

There is a test that verifies the SQLite version. This must be updated as well and it must be updated within androidx-main at the same time as the source.

frameworks/support/sqlite/integration-tests/driver-conformance-test/src/commonTest/kotlin/androidx/sqlite/driver/test/BaseBundledConformanceTest.kt

Update the following constant:

    const val EXPECTED_SQLITE_VERSION = "3.50.1"

Recommended Tests

It is recommended to execute the following test script before committing an update:

frameworks/support/sqlite/scripts/runConformanceTest.sh