-
-
Notifications
You must be signed in to change notification settings - Fork 2.3k
Description
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]