{"action":"created","issue":{"url":"https://api.github.com/repos/pouchdb/pouchdb/issues/3725","labels_url":"https://api.github.com/repos/pouchdb/pouchdb/issues/3725/labels{/name}","comments_url":"https://api.github.com/repos/pouchdb/pouchdb/issues/3725/comments","events_url":"https://api.github.com/repos/pouchdb/pouchdb/issues/3725/events","html_url":"https://github.com/pouchdb/pouchdb/issues/3725","id":67670758,"number":3725,"title":"db.remove not decreasing file size of Cordova SQLite DB","user":{"login":"TeeKz","id":4837696,"avatar_url":"https://avatars.githubusercontent.com/u/4837696?v=3","gravatar_id":"","url":"https://api.github.com/users/TeeKz","html_url":"https://github.com/TeeKz","followers_url":"https://api.github.com/users/TeeKz/followers","following_url":"https://api.github.com/users/TeeKz/following{/other_user}","gists_url":"https://api.github.com/users/TeeKz/gists{/gist_id}","starred_url":"https://api.github.com/users/TeeKz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TeeKz/subscriptions","organizations_url":"https://api.github.com/users/TeeKz/orgs","repos_url":"https://api.github.com/users/TeeKz/repos","events_url":"https://api.github.com/users/TeeKz/events{/privacy}","received_events_url":"https://api.github.com/users/TeeKz/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-04-10T20:01:11Z","updated_at":"2015-04-11T01:35:10Z","closed_at":"2015-04-10T21:53:26Z","body":"Hey there - So I'm having an issue with my app continually getting larger and larger as I add and remove entries from PouchDB. \r\n\r\nPouchDB registers that I removed entries successfully and when I call `db.allDocs()` I see that the entry has been removed. I also have auto_compact enabled to ensure any leftover data is cleaned up. \r\n\r\nI've tried `db.destroy()` and re-opening, no success. I was hoping that using the `sqlitePlugin.deleteDatabase` and reopening a new PouchDB database under the same name would work.. but no success.\r\n\r\nAny idea why `db.remove` is not actually removing all the document? \r\n\r\nThanks!"},"comment":{"url":"https://api.github.com/repos/pouchdb/pouchdb/issues/comments/91737480","html_url":"https://github.com/pouchdb/pouchdb/issues/3725#issuecomment-91737480","issue_url":"https://api.github.com/repos/pouchdb/pouchdb/issues/3725","id":91737480,"user":{"login":"nolanlawson","id":283842,"avatar_url":"https://avatars.githubusercontent.com/u/283842?v=3","gravatar_id":"","url":"https://api.github.com/users/nolanlawson","html_url":"https://github.com/nolanlawson","followers_url":"https://api.github.com/users/nolanlawson/followers","following_url":"https://api.github.com/users/nolanlawson/following{/other_user}","gists_url":"https://api.github.com/users/nolanlawson/gists{/gist_id}","starred_url":"https://api.github.com/users/nolanlawson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nolanlawson/subscriptions","organizations_url":"https://api.github.com/users/nolanlawson/orgs","repos_url":"https://api.github.com/users/nolanlawson/repos","events_url":"https://api.github.com/users/nolanlawson/events{/privacy}","received_events_url":"https://api.github.com/users/nolanlawson/received_events","type":"User","site_admin":false},"created_at":"2015-04-11T01:35:10Z","updated_at":"2015-04-11T01:35:10Z","body":"Interesting, maybe we should look into doing vacuum automatically then. Never worked with it much myself."}}