Here are a few ways to check your version of SQLite.

Actually, you probably already saw which version you were using when you connected to SQLite.

In any case, if you found this page, maybe you need another method to check your SQLite version.

Connecting to SQLite

When you first connect to SQLite using a command line interface (such as Terminal on the Mac), the first thing you should see is the version number.

sqlite3

Result on my system:

SQLite version 3.28.0 2019-04-15 14:49:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.

Perhaps slightly paradoxically, this obviously requires that you enter the major version number anyway. However, once connected, you then see the full version number.

Without Connecting

You can also use the following command if you just want to check the version without actually connecting to SQLite.

sqlite3 --version

The version_number() Function

If you’re already connected to SQLite, you can find out which version it is with the version_number() function.

SELECT sqlite_version();

Result on my system:

3.28.0

Numbering System

Starting from version 3.9.0, SQLite uses semantic versioning, which presents the major version number, followed by the minor version number, followed by the patch number.

Prior to version 3.9.0, SQLite employed a version identifier that contained between two and four numbers.

See Version Numbers in SQLite on the SQLite website for more information about this.

Also, here’s a History of SQLite Releases in case you’re interested.