Deleting images won't reduce the file size from the first saved size.

[spinear]

Describe the bug
Deleting images won't reduce the file size from the first saved size.

System info
BeeRef version number: 0.3.2 (2024-01-21)
Your operating system: Windows 11 23H2

To Reproduce
Steps to reproduce the behavior:

1. Image Storage Format: Always JPG
   Drag and drop around 100 images.

2. Select All - Arrange - Optimal
   Ctrl+S Save
   Name the file
   Check the file size

3. (It doesn't matter restart the app or not.)
   Delete images around 90 images.
   Ctrl+S Save

4. The file size is the same as before.

5. The file size will continue to increase if you keep adding images, deleting, adding again, and so on.

Expected behavior
if images are deleted, the file size should be reduced.

Screenshots
If applicable, add screenshots to help explain your problem.

Debug log:
For crashes and similar, provide the last 20 lines or so of your debug log. To get the debug log, open BeeRef and go to Help -> Show Debug Log. If in doubt, paste the whole debug log to a paste service like paste.bin

[rbreu]

Good catch, thank you. The fix will go out with the next release.

Technical background: bee files are sqlite databases, and sqlite by default hangs on to the disk space of deleted data to be used for new data. (So the files also weren't growing further if you added the same amount of images data back in.) The fix vacuums the file on every save.

[spinear]

Thank you. I've tested the Dev version. It works great!