home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 612732453

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/97#issuecomment-612732453 https://api.github.com/repos/simonw/sqlite-utils/issues/97 612732453 MDEyOklzc3VlQ29tbWVudDYxMjczMjQ1Mw== 9599 2020-04-13T03:26:46Z 2020-04-13T03:26:46Z OWNER

I wonder if it should delete an recreate the file or if it would be safer to drop every table instead?

Dropping tables gets messy: then you need to drop triggers and views, and you need to run vacuum to clean up the space.

My worry with deleting and recreating the file is that it could trigger errors in other processes that are currently attached to that database file. But... if you know that's going to be likely, maybe you shouldn't use the recreate=True feature?

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
593751293  
Powered by Datasette · Queries took 0.907ms · About: github-to-sqlite