Skip to content

Add a mode to link images in a different folder #1597

@SilvioGrosso

Description

@SilvioGrosso

Describe the new feature

It would be great to have a new option to add a link (url) pointing to a folder with some images in order to visualize them in Sqlitebrowser one by one.

In essence, each row of the database might contain the path of one image.
For example,
ID | description | Location
1 |rose_flower | C:\Users\silvio\Desktop\flower\rose.jpg
2 |tulip_flower | C:\Users\silvio\Desktop\flower\tulip.jpg

At present, you can import an image into your database as blob. In the long run, however, you quickly increase the database size and make it much slower to work with.
By having the images separated from the database this one would remain small as regards its size.

Additional info

As regards the link, it would be important to get the path of your image saved as relative in order to easily move the database and the folder with your images in different drives (whenever you decide to backup them).
For instance, you create a new folder in the C:\ drive and save in this same folder your database and your images as well.
Later on, whenever you move this folder, with both your Database and your images, for example into the D:\ drive, Db Browser is able to visualize your images even though the path has been changed (from C to D).

Does this feature exist in another product or project?

This options is available with QGIS, an open source GIS software.
Usually the images have their GPS data (latitude and longitude) so that you can visualize them in their exact position in your map [1]

[1] https://gis.stackexchange.com/questions/251023/link-pdf-jpeg-to-locations-in-qgis-all-coming-from-a-standard-folder

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions