SQLite Forum

SQLite version jumble

SQLite version jumble

(1) By anonymous on 2021-02-25 14:44:06 [link] [source]

When I start SQLite from the command line I get: SQLite version 3.35.0 2021-01-02 23:56:37

When I connect via the API II get SQLite v3.30.

What went wrong? Did I forget to build also the lib?

(2.1) By Larry Brasfield (larrybr) on 2021-02-25 15:00:59 edited from 2.0 in reply to 1 [link] [source]

The SQLite library is statically linked into the CLI shell, sqlite3(.exe). Its version may differ from that of whatever library bits are linked (statically or dynamically) to whatever calling entity you impersonate as "I". a

Nothing necessarily went wrong other than your expectation.

a. I presume, without good evidence, that you run as wet-ware and are not in fact capable of calling into the SQLite API.

(3) By anonymous on 2021-02-25 15:02:41 in reply to 2.1 [link] [source]

This is the instruction std::cout << sqlite3_version << std::endl;

(4) By Warren Young (wyoung) on 2021-02-25 15:21:19 in reply to 3 [source]

You have two or more versions of SQLite on your system. Check your library link path.

Or, statically build SQLite against your app, rather than use a system library.

(5) By Larry Brasfield (larrybr) on 2021-02-25 15:35:56 in reply to 3 [link] [source]

The SQLite library bits you(r app) is calling are different from the ones the CLI shell is calling. You need to control where you(r app) gets its bits from. You are not doing so now, hence your perplexity.

It does not matter how you(r app) told the mystery bits to reveal their version.