SQLite Forum

What version of Sqlite am I using?
Login

What version of Sqlite am I using?

(1) By doug (doug9forester) on 2020-06-05 21:16:28 [link]

I am using Qt 5.14.1 for my application. Under the covers I am using Sqlite for my database. I need to find out what version of Sqlite is installed for it. How can I do this?

(2) By anonymous on 2020-06-05 21:49:04 in reply to 1 [link]

```sql
select sqlite_version();
```

(3) By Larry Brasfield (LarryBrasfield) on 2020-06-05 21:59:24 in reply to 1 [link]

Run the query:

```
select sqlite_version()
```

and see what result you get.

(6) By doug (doug9forester) on 2020-06-06 05:54:04 in reply to 3 [link]

Thanks, Larry. I am on 3.28.0, which is the reason GENERATED fields are not recognized. Sigh... and it was such a good solution.

I don't really want to go through the learning curve of installing my own version of Sqlite in Qt. I don't know when Qt will get to 3.31. Is that information visible to Sqlite development?

(8) By anonymous on 2020-06-06 13:13:45 in reply to 6

> I don't know when Qt will get to 3.31.

Qt 5.15 [includes](https://github.com/qt/qtbase/blob/5.15/src/3rdparty/sqlite/sqlite3.h#L126) SQLite 3.32.1

(10) By doug (doug9forester) on 2020-06-07 18:00:58 in reply to 8 [link]

Seeing as how Qt 5.14.1 was supposed to have Sqlite 3.30.1 and in reality had version 3.28.0, I will believe it when I see it.

(4) By anonymous on 2020-06-05 23:51:26 in reply to 1 [link]

Here's the GitHub link to the SQLite sources included as part of Qt sources:
[](https://github.com/qt/qtbase/tree/5.14.1/src/3rdparty/sqlite)

Looking up the relevant part in [sqlite.h](https://github.com/qt/qtbase/blob/5.14.1/src/3rdparty/sqlite/sqlite3.h#L126), we get:

```
#define SQLITE_VERSION        "3.30.1"
```

(9) By doug (doug9forester) on 2020-06-07 17:56:57 in reply to 4 [link]

Sorry to report that what you see is not what you get. When I use
```
SELECT sqlist_version();
```
at run time, I get version "3.28.0". My version of Qt Creator is 5.14.1.

(5) By Jens Alfke (snej) on 2020-06-06 00:30:48 in reply to 1 [link]

Open sqlite3.h, scroll down about 100 lines, and look at the value of `SQLITE_VERSION`.

(7) By doug (doug9forester) on 2020-06-06 05:57:46 in reply to 5 [link]

Jens, Sqlite is buried in Qt for which I haven't downloaded the source.

"select sqlite_version();" worked fine to get my answer.