idea Allow different filenames for sqlite databases in ArcGIS Pro Ideas

Allow different filenames for sqlite databases

Gisbert — Wed, 05 Apr 2023 12:14:25 GMT

ArcGIS Pro can open .sqlite files directly in the Catalog Pane TM in a folder connection, which is great!

Sqlite databases come with different names, the most prominent being .sqlite, .sqlite3, .db and .db3.

https://en.wikipedia.org/wiki/SQLite

You can test if a e.g. .db file is a sqlite database by checking the header for the string "SQLite format 3" as described here https://www.sqlite.org/fileformat2.html or check for the magic number described in the wiki article.

It would be great if ArcGIS Pro would check the afore mentioned files if they are sqlite databases and also open them if this is the case.

Re: Allow different filenames for sqlite databases - Status changed to: Needs Clarification

SSWoodward — Thu, 06 Apr 2023 18:41:38 GMT

Thanks for the idea @Gisbert

To make sure I understand your idea, can you confirm that the below statement is in line with your ask?

Currently, ArcGIS Pro will open a .sqlite file in the catalog. You would like the catalog to also be able to open sqlite database files with other valid sqlite names (such as .sqlite3, .db, and .db3) in the same manner.

Is that correct?

Betreff: Allow different filenames for sqlite databases

Gisbert — Tue, 11 Apr 2023 07:28:36 GMT

Hello @SSWoodward , yes this is correct.

Or to be more precise, I want to use a table from a sqlite database with the file ending .db in a map project and join it with a point geometry from a rest service.

To elaborate on the task, our sqlite database is generated automatically by a service on local computers of the users and comes with the ending .db. We could ask (pay) the developers of the service to change the service to use a different ending or install the 64bit odbc driver for sqlite on all the clients and create an odbc connection, so for us this is just a convenience feature. But since the necessary tools to open sqlite databases seem to be available on ArcGIS Pro side, this seems like a low hanging fruit for your developers. I´m not sure if there are security implications or conflicts with other files with .db ending, so feel free to correct me or discard the idea. The idea arose from the question why does it work with .sqlite and doesn´t work with .db.

Re: Allow different filenames for sqlite databases - Status changed to: Open

SSWoodward — Tue, 11 Apr 2023 16:27:45 GMT

Thanks for clarifying @Gisbert

I've moved this back to open to collect support.