SQLite - Version / Release

Sqlite Banner

About

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

Management

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

or

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

See the Release timeline and changes





Discover More
Sqlite Banner
How to read JSON data in SQLite ?

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