Allow different filenames for sqlite databases

[Gisbert]

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.

[SSWoodward]

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?

[Gisbert]

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.

[SSWoodward]

Thanks for clarifying @Gisbert 

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