{"action":"created","issue":{"url":"https://api.github.com/repos/keepassxreboot/keepassxc/issues/2549","repository_url":"https://api.github.com/repos/keepassxreboot/keepassxc","labels_url":"https://api.github.com/repos/keepassxreboot/keepassxc/issues/2549/labels{/name}","comments_url":"https://api.github.com/repos/keepassxreboot/keepassxc/issues/2549/comments","events_url":"https://api.github.com/repos/keepassxreboot/keepassxc/issues/2549/events","html_url":"https://github.com/keepassxreboot/keepassxc/issues/2549","id":390744390,"node_id":"MDU6SXNzdWUzOTA3NDQzOTA=","number":2549,"title":"ISO feature to defragment the database","user":{"login":"lsiden","id":136536,"node_id":"MDQ6VXNlcjEzNjUzNg==","avatar_url":"https://avatars2.githubusercontent.com/u/136536?v=4","gravatar_id":"","url":"https://api.github.com/users/lsiden","html_url":"https://github.com/lsiden","followers_url":"https://api.github.com/users/lsiden/followers","following_url":"https://api.github.com/users/lsiden/following{/other_user}","gists_url":"https://api.github.com/users/lsiden/gists{/gist_id}","starred_url":"https://api.github.com/users/lsiden/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lsiden/subscriptions","organizations_url":"https://api.github.com/users/lsiden/orgs","repos_url":"https://api.github.com/users/lsiden/repos","events_url":"https://api.github.com/users/lsiden/events{/privacy}","received_events_url":"https://api.github.com/users/lsiden/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-12-13T15:59:18Z","updated_at":"2018-12-13T16:52:45Z","closed_at":null,"author_association":"NONE","body":"When I first began using KeepassXC, I added an image file to one of my entries.  My database went from 14K in size to 1.3M.  I removed the image, but the database is still 1.3M, even after empying the recycle bin.  \r\n\r\nI'm sure there is a gaping hole of unused space in the file that can be eliminated to bring the file back to its original size of a few kilobytes, but I don't know how, other than exporting the DB to a CSV file and then import it again.\r\n\r\nIt would be cool if there were a way to eliminate unused space in order to keep the file size small when saving it.  I know that 1.3M hardly registers on modern storage mediums and networks, but small is still good when you want to save your file to a thumb drive or copy it to your phone.\r\n\r\nIf I didn't have a day job I'd poke around and see what kind of storage its using and whether there's a way to do that."},"comment":{"url":"https://api.github.com/repos/keepassxreboot/keepassxc/issues/comments/447040985","html_url":"https://github.com/keepassxreboot/keepassxc/issues/2549#issuecomment-447040985","issue_url":"https://api.github.com/repos/keepassxreboot/keepassxc/issues/2549","id":447040985,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NzA0MDk4NQ==","user":{"login":"droidmonkey","id":2809491,"node_id":"MDQ6VXNlcjI4MDk0OTE=","avatar_url":"https://avatars2.githubusercontent.com/u/2809491?v=4","gravatar_id":"","url":"https://api.github.com/users/droidmonkey","html_url":"https://github.com/droidmonkey","followers_url":"https://api.github.com/users/droidmonkey/followers","following_url":"https://api.github.com/users/droidmonkey/following{/other_user}","gists_url":"https://api.github.com/users/droidmonkey/gists{/gist_id}","starred_url":"https://api.github.com/users/droidmonkey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/droidmonkey/subscriptions","organizations_url":"https://api.github.com/users/droidmonkey/orgs","repos_url":"https://api.github.com/users/droidmonkey/repos","events_url":"https://api.github.com/users/droidmonkey/events{/privacy}","received_events_url":"https://api.github.com/users/droidmonkey/received_events","type":"User","site_admin":false},"created_at":"2018-12-13T16:52:45Z","updated_at":"2018-12-13T16:52:45Z","author_association":"MEMBER","body":"There is no reason for defragmenting. If you go into the database settings there will be an option in there to limit the size of history. Move that down to whatever you please and the old image should be erased at that point."}}
{"actor":{"display_login":"droidmonkey"}}