Skip to content

sqlite3v3.54.1

Updated

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

#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

#Supported Platforms

!uwp

  • ✅linux
  • ✅osx
  • ✅windows
  • ❌uwp

#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.

#json1default

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.

#percentile

Enable the aggregate functions percentile, percentile_cont, percentile_disc, and median

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

Platforms: !uwp
  • ✅linux
  • ✅osx
  • ✅windows
    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:

    No transitive dependencies.

    Host Dependencies:
    2 transitive dependencies:

    #Dependencies

    No dependencies.

    #Host Dependencies

    No transitive dependencies.

    #Host Tool For

    #Contributors

    • Alexander Karatarakis's avatarAlexander Karatarakis
    • Ninetainedo's avatarNinetainedo
    • Robert Schumacher's avatarRobert Schumacher
    • Chris Bond's avatarChris Bond
    • Charles Barto's avatarCharles Barto
    • Dale Stammen's avatarDale Stammen
    • flysha's avatarflysha
    • Mikhail Paulyshka's avatarMikhail Paulyshka
    • pravic's avatarpravic
    • Daniel Strommen's avatarDaniel Strommen
    • pastdue's avatarpastdue
    • Robert Colton's avatarRobert Colton
    • Andy Li's avatarAndy Li
    • Patrick Geltinger's avatarPatrick Geltinger
    • Xiao Ai's avatarXiao Ai
    • Kevin Lu's avatarKevin Lu
    • Jackie Ng's avatarJackie Ng
    • Jack·Boos·Yu's avatarJack·Boos·Yu
    • NancyLi1013's avatarNancyLi1013
    • huangqinjin's avatarhuangqinjin
    • Richard H's avatarRichard H
    • Phoebe's avatarPhoebe
    • sanjaychugh's avatarsanjaychugh
    • JonLiu1993's avatarJonLiu1993
    • Be's avatarBe
    • Koby Kahane's avatarKoby Kahane
    • Matthias Kuhn's avatarMatthias Kuhn
    • Frank's avatarFrank
    • Cheney Wang's avatarCheney Wang
    • MSP-Greg's avatarMSP-Greg
    • Burak Arslan's avatarBurak Arslan
    • Kai Pastor's avatarKai Pastor
    • Billy O'Neal's avatarBilly O'Neal
    • klaus triendl's avatarklaus triendl
    • Thomas1664's avatarThomas1664
    • autoantwort's avatarautoantwort
    • Weihang Ding's avatarWeihang Ding
    • Jia Yue Hua's avatarJia Yue Hua
    • Osyotr's avatarOsyotr
    • c8ef's avatarc8ef
    • arasan01's avatararasan01
    • MonicaLiu's avatarMonicaLiu
    • Kadir's avatarKadir
    • jim wang's avatarjim wang
    • Egor Krugletsov's avatarEgor Krugletsov
    • toge's avatartoge
    • SunBlack's avatarSunBlack
    • acidx27x's avataracidx27x
    • Wilfried Karel's avatarWilfried Karel
    • William's avatarWilliam
    • Denis Rouzaud's avatarDenis Rouzaud

    #Changelog

    • 2016b65[sqlite3] Update to 3.54.1 (#54494)
    • 49d33e7[sqlite3] Keep the wrapper's INTERFACE target linked when SQLite3 is … (#54175)
    • ec0a12e[sqlite3] Fix the soundex feature having no effect (#53892)
    • c8d7561[sqlite3] Update to 3.53.4 (#53064)
    • 957952f[sqlite3] disable find_package for ICU when SQLITE_ENABLE_ICU is not … (#52613)
    • 1f5e034[sqlite3] Update to 3.53.3 (#52616)
    • 930ecc4[sqlite] new feature 'percentile' (#52551)
    • 4dbd4a4[sqlite3] Update to 3.53.2 (#52182)
    • 2f04408[sqlite3] Let wrapper handle aliased SQLite::SQLite3 (#51698)
    • d29e830[sqlite3][nss] fix missing -lm (#51591)
    Show 109 earlier changes