Select to view content in your preferred language

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

1678
4
12-10-2022 11:50 AM
Labels (1)
Bud
by
Esteemed Contributor

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.

0 Kudos
4 Replies
DanPatterson
MVP Esteemed Contributor
0 Kudos
VinceAngelo
Esri Esteemed Contributor

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 

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

@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
by
Esteemed Contributor

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

Bud_1-1670786633157.png

Bud_0-1670786570953.png

Thanks.

 

0 Kudos