{"url":"https://api.github.com/repos/simonw/sqlite-utils/issues/159","repository_url":"https://api.github.com/repos/simonw/sqlite-utils","labels_url":"https://api.github.com/repos/simonw/sqlite-utils/issues/159/labels{/name}","comments_url":"https://api.github.com/repos/simonw/sqlite-utils/issues/159/comments","events_url":"https://api.github.com/repos/simonw/sqlite-utils/issues/159/events","html_url":"https://github.com/simonw/sqlite-utils/issues/159","id":702386948,"node_id":"MDU6SXNzdWU3MDIzODY5NDg=","number":159,"title":".delete_where() does not auto-commit (unlike .insert() or .upsert())","user":{"login":"spdkils","id":11712349,"node_id":"MDQ6VXNlcjExNzEyMzQ5","avatar_url":"https://avatars.githubusercontent.com/u/11712349?v=4","gravatar_id":"","url":"https://api.github.com/users/spdkils","html_url":"https://github.com/spdkils","followers_url":"https://api.github.com/users/spdkils/followers","following_url":"https://api.github.com/users/spdkils/following{/other_user}","gists_url":"https://api.github.com/users/spdkils/gists{/gist_id}","starred_url":"https://api.github.com/users/spdkils/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spdkils/subscriptions","organizations_url":"https://api.github.com/users/spdkils/orgs","repos_url":"https://api.github.com/users/spdkils/repos","events_url":"https://api.github.com/users/spdkils/events{/privacy}","received_events_url":"https://api.github.com/users/spdkils/received_events","type":"User","user_view_type":"public","site_admin":false},"labels":[{"id":993377882,"node_id":"MDU6TGFiZWw5OTMzNzc4ODI=","url":"https://api.github.com/repos/simonw/sqlite-utils/labels/bug","name":"bug","color":"d73a4a","default":true,"description":"Something isn't working","archived_at":null,"archived_by":null},{"id":2374328637,"node_id":"MDU6TGFiZWwyMzc0MzI4NjM3","url":"https://api.github.com/repos/simonw/sqlite-utils/labels/python-library","name":"python-library","color":"006b75","default":false,"description":"","archived_at":null,"archived_by":null}],"state":"closed","locked":false,"assignees":[],"milestone":null,"comments":11,"created_at":"2020-09-16T01:55:52Z","updated_at":"2026-07-08T02:19:41Z","closed_at":"2026-07-08T02:19:41Z","assignee":null,"author_association":"NONE","active_lock_reason":null,"sub_issues_summary":{"total":0,"completed":0,"percent_completed":0},"issue_dependencies_summary":{"blocked_by":0,"total_blocked_by":0,"blocking":0,"total_blocking":0},"body":"When you use the delete_where() function on a table, it never commits....\r\n\r\nIs that intentional?","closed_by":{"login":"simonw","id":9599,"node_id":"MDQ6VXNlcjk1OTk=","avatar_url":"https://avatars.githubusercontent.com/u/9599?v=4","gravatar_id":"","url":"https://api.github.com/users/simonw","html_url":"https://github.com/simonw","followers_url":"https://api.github.com/users/simonw/followers","following_url":"https://api.github.com/users/simonw/following{/other_user}","gists_url":"https://api.github.com/users/simonw/gists{/gist_id}","starred_url":"https://api.github.com/users/simonw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simonw/subscriptions","organizations_url":"https://api.github.com/users/simonw/orgs","repos_url":"https://api.github.com/users/simonw/repos","events_url":"https://api.github.com/users/simonw/events{/privacy}","received_events_url":"https://api.github.com/users/simonw/received_events","type":"User","user_view_type":"public","site_admin":false},"reactions":{"url":"https://api.github.com/repos/simonw/sqlite-utils/issues/159/reactions","total_count":2,"+1":2,"-1":0,"laugh":0,"hooray":0,"confused":0,"heart":0,"rocket":0,"eyes":0},"timeline_url":"https://api.github.com/repos/simonw/sqlite-utils/issues/159/timeline","performed_via_github_app":null,"state_reason":"completed","pinned_comment":null}