{"action":"created","issue":{"url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/264","labels_url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/264/labels{/name}","comments_url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/264/comments","events_url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/264/events","html_url":"https://github.com/oysteinkrog/SQLite.Net-PCL/issues/264","id":121062253,"number":264,"title":"Need to delete the database completely, can I close the database or delete it from the API?","user":{"login":"gtas-verisk","id":14896282,"avatar_url":"https://avatars.githubusercontent.com/u/14896282?v=3","gravatar_id":"","url":"https://api.github.com/users/gtas-verisk","html_url":"https://github.com/gtas-verisk","followers_url":"https://api.github.com/users/gtas-verisk/followers","following_url":"https://api.github.com/users/gtas-verisk/following{/other_user}","gists_url":"https://api.github.com/users/gtas-verisk/gists{/gist_id}","starred_url":"https://api.github.com/users/gtas-verisk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gtas-verisk/subscriptions","organizations_url":"https://api.github.com/users/gtas-verisk/orgs","repos_url":"https://api.github.com/users/gtas-verisk/repos","events_url":"https://api.github.com/users/gtas-verisk/events{/privacy}","received_events_url":"https://api.github.com/users/gtas-verisk/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-08T17:53:00Z","updated_at":"2016-01-26T15:38:27Z","closed_at":null,"body":"I have a requirement of deleting the database when the logout action happens.\r\n\r\nI can't seem to find any delete database method, and maybe that's OK but when manually try to delete the file with the path, it gives me an exception \"readonly\".\r\n\r\n```\r\nSQLite.Net.SQLiteException: ReadOnly\r\n  at SQLite.Net.SQLiteCommand.ExecuteNonQuery () [0x000db] in <filename unknown>:0 \r\n  at SQLite.Net.SQLiteConnection.Execute (System.String query, System.Object[] args) [0x00044] in <filename unknown>:0 \r\n  at SQLite.Net.SQLiteConnection.Update (System.Object obj, System.Type objType) [0x00104] in <filename unknown>:0 \r\n--- End of stack trace from previous location where exception was thrown ---\r\n```\r\n\r\nLooks like it still is open executing a query.\r\n\r\nAny ideas how to close and delete the database?"},"comment":{"url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/comments/175081547","html_url":"https://github.com/oysteinkrog/SQLite.Net-PCL/issues/264#issuecomment-175081547","issue_url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/264","id":175081547,"user":{"login":"valdetero","id":781994,"avatar_url":"https://avatars.githubusercontent.com/u/781994?v=3","gravatar_id":"","url":"https://api.github.com/users/valdetero","html_url":"https://github.com/valdetero","followers_url":"https://api.github.com/users/valdetero/followers","following_url":"https://api.github.com/users/valdetero/following{/other_user}","gists_url":"https://api.github.com/users/valdetero/gists{/gist_id}","starred_url":"https://api.github.com/users/valdetero/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/valdetero/subscriptions","organizations_url":"https://api.github.com/users/valdetero/orgs","repos_url":"https://api.github.com/users/valdetero/repos","events_url":"https://api.github.com/users/valdetero/events{/privacy}","received_events_url":"https://api.github.com/users/valdetero/received_events","type":"User","site_admin":false},"created_at":"2016-01-26T15:38:27Z","updated_at":"2016-01-26T15:38:27Z","body":"Will dropping all of the tables be sufficient? I loop through and drop all of the tables and then call VACUUM to reclaim disk space."}}