sqlite3 v3.49.1

Created: 2016-09-18
Updated: 2025-02-20

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

https://sqlite.org/

# Usage

sqlite3 provides pkgconfig bindings.
sqlite3 provides CMake targets:

find_package(unofficial-sqlite3 CONFIG REQUIRED)
target_link_libraries(main PRIVATE unofficial::sqlite3::sqlite3)

# License

blessing

SQLite Blessing

# Supported Platforms

All platforms are supported

# Features

Default feature: json1

# dbpage-vtab

Enable the recovery extension

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# dbstat

Enable the DBSTAT virtual table

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# fts3

Enable the FTS3 extension

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# fts4

Enable the FTS4 extension

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# fts5

Enable the FTS5 extension

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# geopoly

Enable geopoly functionality for sqlite3

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# json1 default

Enable JSON functionality for sqlite3

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# limit

Enable the UPDATE/DELETE LIMIT clause

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# math

Enable math functions

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# memsys3

Enable MEMSYS3

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# memsys5

Enable MEMSYS5

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# omit-load-extension

Enable loading of external extensions

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# rtree

Enable the RTREE extension

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# session

Enable the SESSION extension

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# snapshot

Enable the snapshot function

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# soundex

Enable the SOUNDEX scalar function

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# tool

Build sqlite3 executable

Supports: !uwp

✅ linux
✅ osx
✅ windows

❌ ~~uwp~~

Dependencies:

No dependencies.

Host Dependencies:

No dependencies.

# unicode

Enable unicode support

Dependencies:

No transitive dependencies.

Host Dependencies:

3 transitive dependencies:

# zlib

Build sqlite3 command line tool with zlib support; has no effect on the library itself

Dependencies:

zlib

No transitive dependencies.

Host Dependencies:

one transitive dependency:

vcpkg-cmake (by zlib )

# Dependencies

No dependencies.

# Host Dependencies

No transitive dependencies.

# Dependents

3fd
arrow-adbc (feature sqlite )
buck-yeh-bux-sqlite
colmap
dlib (feature sqlite3 )
drogon (feature sqlite3 )
gdal (feature sqlite3 )
gz-transport
libdjinterop
libodb-sqlite
libsndfile (feature regtest )
libsoup
libspatialite
mapnik (feature input-sqlite )
mapnik (feature utility-pgsql2sqlite )
nss
oatpp-sqlite
openslide
osgearth
poco
proj
python3 (feature extensions )
qt5-base
qtbase (feature sql-sqlite )
rtabmap
sese (feature sqlite3 )
soci (feature sqlite3 )
spatialite-tools
sqlite-modern-cpp
sqlite-orm
sqlitecpp
sqlpp11 (feature sqlite3 )
vtk (feature sql )
wt (feature sqlite3 )

# Host Dependents

proj

# Contributors

Alexander Karatarakis
Ninetainedo
Robert Schumacher
Chris Bond
Charles Barto
Dale Stammen
flysha
Mikhail Paulyshka
pravic
Daniel Strommen
pastdue
Robert Colton
Andy Li
Patrick Geltinger
Xiao Ai
Kevin Lu
Jackie Ng
Jack·Boos·Yu
NancyLi1013
huangqinjin
Richard H
Phoebe
sanjaychugh
JonLiu1993
Be
Koby Kahane
Matthias Kuhn
Frank
Cheney Wang
MSP-Greg
Burak Arslan
Kai Pastor
Billy O'Neal
klaus triendl
Thomas1664
autoantwort
Weihang Ding
Jia Yue Hua
Osyotr
c8ef
arasan01
MonicaLiu
Kadir
jim wang
Egor Krugletsov

# Changelog

ebebb1c
ebebb1c [sqlite3] update to 3.49.1 (#43922)
2025-02-20
2e887b4
2e887b4 [sqlite3] update to 3.49.0 (#43685)
2025-02-10
8b6ee89
8b6ee89 [sqlite3] update to 3.48.0 (#43266)
2025-01-21
d77feb3
d77feb3 [sqlite3] update to 3.47.2 (#42590)
2024-12-09
b69ad09
b69ad09 [sqlite3] update to 3.47.1 (#42356)
2024-11-26
c6841ac
c6841ac [sqlite3] Prepend whitespace to pkgconfig Requires.private string (#41885)
2024-10-31
b505fa7
b505fa7 [sqlite3] Add unicode support (#41753)
2024-10-31
a39a21b
a39a21b [sqlite3] update to 3.47.0 (#41758)
2024-10-26
c3f7523
c3f7523 [sqlite3] update to 3.46.1 (#40435)
2024-08-16
8b2599c
8b2599c [sqlite3] Add feature recovery (#39424)
2024-07-02

and 85 more commits:

960d1bd
960d1bd [sqlite3] Update to version 3.46.0 (#39149)
2024-06-07
c30bf9d
c30bf9d [sqlite3] Fix feature dbstat (#38711)
2024-05-14
80c87b9
80c87b9 [sqlite3] update to 3.45.3 (#38238)
2024-04-19
4d61c5b
4d61c5b [sqlite] update to 3.45.2 (#37404)
2024-03-13
86e3ce7
86e3ce7 [sqlite3] Ability to enable the database snapshot (#36925)
2024-03-05
779f797
779f797 [sqlite3] Update to 3.45.1 (#36874)
2024-02-21
bbad296
bbad296 [sqlite3] Update to 3.45.0, add windows version info (#36302)
2024-01-23
2383d33
2383d33 Ability to enable the SOUNDEX() scalar function (#35867)
2023-12-27
b6f6f6e
b6f6f6e [sqlite3] update to 3.43.2 (#34950)
2023-11-08
8ec31e9
8ec31e9 [sqlite3] update to 3.43.1 (#34178)
2023-10-05
44e1ee7
44e1ee7 [sqlite3] Bump to 3.43.0 (#33632)
2023-09-13
0a4cefa
0a4cefa [sqlite3] tool no uwp (#33602)
2023-09-07
be82dd7
be82dd7 [sqlite3] Fix option passing (#32404)
2023-07-10
079419e
079419e [sqlite3] Update to 3.42.0 (#31703)
2023-06-13
d18847f
d18847f [sqlite3] Fix tool installation with zlib (#31050)
2023-04-25
f60f31f
f60f31f [sqlite3] Ability to enable the DBSTAT eponymous virtual table (#30432)
2023-04-02
185a7aa
185a7aa [sqlite3] Control features with a configuration header (#29376)
2023-02-06
6099502
6099502 [sqlite3] Update to 3.40.1, misc fixes (#29130)
2023-01-23
f882be0
f882be0 [sqlite3] Fix typo for the Windows build (#28923)
2023-01-16
481ff85
481ff85 [sqlite3] Re-set option SQLITE_ENABLE_COLUMN_METADATA to 1 (#27969)
2022-11-28
8331113
8331113 [sqlite3] update to 3.40.0 (#27868)
2022-11-18
7d21ec6
7d21ec6 sqlite3: update to 3.39.2 (#26280)
2022-08-12
917a86a
917a86a [sqlite3] update to 3.39.1 (#25852)
2022-07-20
250d199
250d199 [sqlite3] Remove the restriction of using find_dependency(Threads) only under static linking (#25460)
2022-06-30
7f3e168
7f3e168 [sqlite3] Add more features (#23009)
2022-02-16
4f2d305
4f2d305 [sqlite3] update to <3.37.1> (#22795)
2022-02-01
1cd11e2
1cd11e2 [sqlite3] Fix .pc (#22121)
2021-12-21
793256e
793256e [sqlite3] Update to 3.37.0 (#21729)
2021-11-29
93885af
93885af [libdjinterop] update to 0.16.0 (#20136)
2021-09-22
a07c157
a07c157 [sqlite3] update to 3.36.0 (#19847)
2021-09-09
2cc4ca3
2cc4ca3 [sqlite3] Update to 3.35.5 (#18374)
2021-06-11
bf2aaf9
bf2aaf9 [sqlite3] Embed dllimport in header (#16646)
2021-05-28
820b31c
820b31c [sqlite3] Update to 3.35.4 (#17067)
2021-04-07
ce86092
ce86092 [sqlite3] Update to 3.35.2 (#16834)
2021-03-23
1575c83
1575c83 [sqlite3] Update to 3.35.0 (#16679)
2021-03-15
6e8aaa7
6e8aaa7 [sqlite3] Update to 3.34.1 (#16125)
2021-02-24
998ecbc
998ecbc [sqlite3] Update to 3.33.0 (#13501)
2020-09-14
7c5ea94
7c5ea94 [sqlite3] Sqlite3 geopoly and json1 features (#11532)
2020-08-14
f3221c0
f3221c0 [sqlite3] Namespaced targets with unofficial:: (#12516)
2020-08-05
66b906e
66b906e [sqlite3] update to 3.32.3 to deal with security issues (#12185)
2020-07-01
8bd2b60
8bd2b60 [sqlite] Updated to 3.32.1 to fix a security vulnerability (#11716)
2020-06-11
53a17b9
53a17b9 update sqlite3 to 3.32 (#11635)
2020-06-01
b0c42cb
b0c42cb [sqlite3] Enable build for android (#11267)
2020-05-15
ae8a224
ae8a224 [sqlite3] Update to 3.31.1 (#10241)
2020-02-28
6ece7ae
6ece7ae [sqlite3] Rename sqlite3 tool as sqlite3.exe (#9437)
2020-01-09
75dd38c
75dd38c [proj4] Upgrade version to 6.1.1 and remove patches. (#7917)
2019-10-17
aac5a17
aac5a17 [sqlite3] Update to 3.30.1
2019-10-12
2abd03c
2abd03c [sqlite3] Update to 3.29.0 (#7342)
2019-07-21
e1870a9
e1870a9 [sqlite3-tool]Fix build error on arm/uwp platform. (#7202)
2019-07-15
dfd5bb4
dfd5bb4 [sqlite3]: Shared library support for Linux (#6856)
2019-06-20
8de7aa1
8de7aa1 [sqlite3] Update to 3.28.0 (#6921)
2019-06-17
18b029a
18b029a [WIP] Add a Homepage URL entry for vcpkg ports (#2933)
2019-06-15
81ecf51
81ecf51 update sqlite3 to 3.27.2 (#6002)
2019-04-08
afdca91
afdca91 [sqlite3] Update to SQLite 3.26.0 because of "Magellan" vulnerability (#4995)
2018-12-18
a0d6a29
a0d6a29 [Sqlite3] update to 3.25.2 (#4600)
2018-11-06
473d63c
473d63c Qt 5.11 and static build fixes (#4164)
2018-10-22
3726ce9
3726ce9 [sqlite3] Improve usage on non-Windows; Fixes example and Fixes #3703
2018-06-16
b2c295e
b2c295e [sqlite3] update to 3.24.0
2018-06-05
90db2c7
90db2c7 [sqlite3] Fix tool feature with static builds
2018-04-24
cde623c
cde623c [sqlite3] update to 3.23.1
2018-04-24
182450a
182450a [sqlite3] update to 3.23.0
2018-04-03
62a015b
62a015b [sqlite3] Fix build failure when VCPKG_BUILD_TYPE is set to "release"
2018-03-19
9f9778c
9f9778c [many ports] Improve behavior on Linux and general cleanup
2018-03-11
ba3f552
ba3f552 Install sqlite3.exe as part of sqlite3 port (#2525)
2018-02-27
ae48463
ae48463 [sqlite3] update to 3.21.0
2017-10-25
601661e
601661e [sqlite3] update to 3.20.1
2017-09-11
26516fe
26516fe vcpkg_configure_cmake (and _meson) now embed debug symbols within static libs (/Z7)
2017-09-09
14c3c51
14c3c51 [sqlite3] update to 3.19.1
2017-05-24
e5a4f03
e5a4f03 [sqlite3] update to 3.18.0
2017-04-01
13940af
13940af [sqlite3] fix uwp builds
2017-04-01
cad7e2a
cad7e2a [sqlite3] upgrade to 3.17.0
2017-02-15
c128d00
c128d00 use VCPKG_CMAKE_SYSTEM_NAME instead of TRIPLET_SYSTEM_NAME
2016-12-06
1808d46
1808d46 triplet is now automatically included before portfiles.
2016-11-08
2dad2a8
2dad2a8 fixed typo in sqlite3 config file
2016-10-19
284d50c
284d50c added a config file for sqlite
2016-10-19
035952b
035952b added static build support to sqlite
2016-10-18
20a9bb8
20a9bb8 added rtree and unlock_notify support to builds of sqlite (odb needs this)
2016-10-18
796e65e
796e65e [sqlite3] Remove parentheses from version field
2016-10-17
56f8c6a
56f8c6a [sqlite3] Use SOURCE_PATH in a similar manner as other portfiles
2016-10-17
8d1d8df
8d1d8df updated control and cmake files for latest version of sqlite
2016-10-16
b1fe038
b1fe038 Remove use of vcpkg_build_cmake() across all portfiles. Fixes #123
2016-10-06
3679955
3679955 Introduce SOURCE_PATH to almost all portfiles
2016-09-28
930d0a7
930d0a7 URL and MIRRORS are now URLS
2016-09-25
fc26083
fc26083 Second part of updated portfiles
2016-09-22
ccca198
ccca198 Initial commit
2016-09-18

sqlite3 v3.49.1

# Usage

# License

# Supported Platforms

# Features

# dbpage-vtab

# dbstat

# fts3

# fts4

# fts5

# geopoly

# json1 default

# limit

# math

# memsys3

# memsys5

# omit-load-extension

# rtree

# session

# snapshot

# soundex

# tool

# unicode

# zlib

# Dependencies

# Host Dependencies

# Dependents

# Host Dependents

# Contributors

# Changelog

# Source