SQLite - Version / Release

Sqlite Banner


This page is about the version (or release) of SQLite


Get the Version with a select statement

select sqlite_version();

same as Sqlite version number is in the database header (position 100)

Get the version via the magic header of the binary File

See magic header string of Sqlite format 3

with a hex editor

Sqlite Magic Header String


head -c 16 "C:\Users\gerard\.db\db.db"
SQLite format 3

See the Release timeline and changes

Discover More
Sqlite Banner

sqlite can query the json format with the JSON extension since the version 3.9.0 (2015-10-14) If you have a json string stored in a text data type, you can extract...
Card Puncher Data Processing
How to upgrade SQLite to the latest shared library version

This howto shows you how to upgrade your shared SQLite library
Sqlite Banner
Sqlite - (Compile) Options

Options in Sqlite permits to see which feature is enabled or not. The options are dependent: of the compile option. They may be or not enabled when creating the sqlite application on the sqlite...

Share this page:
Follow us:
Task Runner