sqlite3

Information

License

Public Domain

Recipe updated

2026-10-18T11:34:33.000Z

Platforms

• android: armeabi, armeabi-v7a, arm64-v8a, riscv64, x86, x86_64, mips, mip64
• msys: i386, x86_64
• mingw: i386, x86_64, arm, arm64
• windows: x86, x64, arm, arm64, arm64ec
• linux: i386, x86_64, armv7, armv7s, arm64, mips, mips64, mipsel, mips64el, loong64, riscv64, s390x, ppc, ppc64, ppc64el, sparc64
• bsd: i386, x86_64, arm, arm64, ppc, ppc64, ppc64el, riscv64, sparc64
• harmony: armeabi-v7a, arm64-v8a, x86, x86_64
• cross: i386, x86_64, arm, armv7, arm64, mips, mips64, mips64el, riscv, riscv64, loong64, s390x, ppc, ppc64, ppc64el, sh4, sparc64
• wasm: wasm32, wasm64
• iphoneos: arm64, x86_64
• macosx: x86_64, arm64

Options

column_metadata

Enable column metadata APIs. · Type: boolean · Default: false

dbpage_vtab

Enable the SQLITE_DBPAGE virtual table. · Type: boolean · Default: true

dbstat_vtab

Enable the dbstat virtual table. · Type: boolean · Default: true

default_wal_synchronous

Set the default Write-Ahead Logging synchronous level in WAL mode: 0 (OFF), 1 (NORMAL), 2 (FULL), or 3 (EXTRA). · Type: string · Default: 1 · Values: 0, 1, 2, 3

explain_comments

Inserts comment text into the output of EXPLAIN. · Type: boolean · Default: true

math_functions

Enable the built-in SQL math functions. · Type: boolean · Default: true

omit_deprecated

Omit deprecated interfaces. · Type: boolean · Default: false

omit_shared_cache

Omit shared-cache support. · Type: boolean · Default: false

rtree

Enable R-Tree. · Type: boolean · Default: false

safe_mode

Use thread safe mode in 0 (single thread) | 1 (serialize) | 2 (mutli thread). · Type: string · Default: 1 · Values: 0, 1, 2

stmt_vtab

Enable the SQLITE_STMT virtual table logic. · Type: boolean · Default: true

Versions

• 3.23.0+0
• 3.24.0+0
• 3.34.0+100
• 3.35.0+300
• 3.35.0+400
• 3.36.0+0
• 3.37.0+200
• 3.39.0+200
• 3.43.0+200
• 3.45.0+300
• 3.45.0+200
• 3.45.0+100
• 3.46.0+0
• 3.46.0+100
• 3.47.0+0
• 3.47.0+200
• 3.47.0+100
• 3.48.0+0
• 3.49.0+0
• 3.49.0+100
• 3.49.0+200
• 3.50.0+400
• 3.50.0+100
• 3.50.0+200
• 3.50.0+300
• 3.50.0+0
• 3.51.0+0
• 3.51.0+100
• 3.51.0+200
• 3.51.0+300
• 3.53.0+100
• 3.53.0+400
• 3.53.0+0
• 3.53.0+200
• 3.54.0+100

Dependencies

No dependencies declared.

Used by (8)

Packages declaring this dependency; requirements can vary by platform and configuration.

• colmap
• libgda
• poco
• proj
• rpm
• sqlite-vec
• sqlite_orm
• vectorscan

Install with xrepo

Install the package independently of a project and inspect its available configuration.

install

xrepo install "sqlite3 3.54.0+100"

show info

xrepo info "sqlite3"

Link a library to your target

Declare the requirement, then attach the library to the target that uses it.

xmake.lua

add_requires("sqlite3 3.54.0+100")

target("demo")
    set_kind("binary")
    add_files("src/*.cpp")
    add_packages("sqlite3")

Open a package environment

Open a shell with the environment exported by this package. Use the executable names documented by the package.

enter shell

xrepo env -b "sqlite3 3.54.0+100" shell