Mobile geodatabase created by ArcGIS Pro 3.0.3 — What SQLite version is the .geodatabase file?

[Bud]

I've created a mobile geodatabase using ArcGIS Pro 3.0.3.

What version of SQLite is the .geodatabase file? For example, is it SQLite 3.39?

Thanks.

[DanPatterson]

ArcGIS Pro 3.0 requirements for SQLite—ArcGIS Pro | Documentation from the help

[VinceAngelo]

According to https://stackoverflow.com/questions/9646353/how-to-find-sqlite-database-file-version, you'd run a query in the resulting database:

select sqlite_version();

It's probably going to be the release that was stable when 3.0 development started (3.39 isn't even listed as supported in the table provided by Dan).

- V 

[JoshuaBixby]

---

@Bud wrote:

What version of SQLite is the .geodatabase file?

---

The question taken literally/explicitly doesn't have an answer, or at least a single answer.  SQLite as a file-based, serverless database has lots of different "versions."  Looking at Database File Format - SQLite Documentation, there are:

• File format write version
• File format read version
• Schema format number/version
• "user version"
• version-valid-for number
• SQLITE_VERSION_NUMBER

One might assume your question is regarding the last version in the list above, but it is important to note that SQLITE_VERSION_NUMBER isn't the version of the SQLite client that created the database file, but the version of the SQLite client that "most recently modified the database file."  Upon first creating a SQLite database file those two are one of the same, but that isn't always the case.

So is your question really "what version of SQLite is bundled with ArcGIS Pro 3.0.3?"  If so, just open up the ArcGIS Pro  Python Command Prompt:

(arcgispro-py3) C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3> sqlite3 --version

3.38.2 2022-03-26 13:51:10 ......

The above is for Pro 3.0.2.

[Bud]

It looks like the SQLite version that is bundled with ArcGIS Pro 3.0.3 is SQLite 3.38.2 as well.

Thanks.