QGIS » QGIS Application

It seems to me this is by design and would be hard to change. sqlite connections are stored in QGIS2.conf like this, there is now way to store 2 items with same name:

[SpatiaLite]
connections\\selected=gis.sqlite
connections\\gis.sqlite\\sqlitepath=/data/research/data/gis/tmp/gis.sqlite

How would you show 2 entries with the same name in the browser? You would need to add the path to the name which is not convenient.

Probably easier to just rename your second sqlite file before adding it to the browser.

For now it should be wise to show an error saying that you cannot add 2 connections with the same name.

Ideally, one should be able to rename sqlite items to do what you want.

Hi ! Thanks for quick reaction !!

Actually, I sometimes need specifically to have two spatialite databases with the same name.
This allows to have two variants of a project's database and simply duplicate the QGIS project to be able to display both.

About how to display them in the browser, I'd say displaying them with the same name and the file path on mouseover would be good enough. It means the ID would have to be the filepath, though...

Changing the way connection are stored in settings requires some thinking, in order to not break things.

Perhaps any new connections would use full path, and old connections would remain as is.

Would there be any portability issues with this? Let's say you have a project that was created in linux, if opened in windows the stored sqlite connection would not be found.

Adding other devs which contributed to this code, to get their feedback.

If you use the full file path as key, this is what gets stored in the settings, and this does NOT work.

connections\\data\
esearch\\data\\gis\\tmp\\gis.sqlite\\sqlitepath=/data/research/data/gis/tmp/gis.sqlite

Simple (but not very convenient) solution would be to add a counter to key name (e.g. gis.sqlite_2).