Multimedia data should be store within database
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Pigeon Planner |
Confirmed
|
Wishlist
|
Timo Vanwynsberghe |
Bug Description
Hello,
It is bad idea to keep multimedia data outside the database. Right now, the pigeon planner stores image data as hard-coded paths for example "~/pictures/
To fix that problem PigeonPlanner:
- should make copy of the image and put it in database
- all images should be displayed from database data, not images from disk
The main disadvantage of this approach is that the size of the database will be bigger, but you could store compressed image data. But, basing on the current hardware specification it is not the problem. 512 GB SSD is no standard, so let's assume that you have 100 pigeons and each image weights 3Mb. The overall database weight will increase by 300 Mb. In brief, this is relatively low cost for the atomic stability.
You could also consider this as an option, however it should be enable by everyone by default.
Regards,
Stefan
Hey Stefan, perfect timing. It's on my ToDo list for the next version.
There's two possible solutions:
1. store the images itself in the database (like you suggest)
2. copy the images to a dedicated directory and store that path in the database
Point 1 will be the easiest solution. Everything sits nicely in the database, backups and moving the database will be seamless. But last time I checked it wasn't really advised to store images in the database itself. And what about other posible media files ("Media" tab at the bottom)?
Point 2 is currently my choice, but has some drawbacks. The program will have to manage these files (addition, deletion, duplicates), link it to the database, include in backups, ...
I'm not a database expert, so any input from others is welcome.