Delete button needs confirmation

[simonw]

It's really easy to click by accident and it's irreversible!

[simonw]

I'm going to do a cheap JavaScript confirm() for the moment.

A better solution would be to make this a reversible action. One way to do that:

• Teach Datasette that _X tables are hidden by default
• On delete, rename the table to _deleted_tablename
• Put a record in a _internal table that records when it was deleted and sets a deadline for it to be dropped - maybe 5 minutes after deletion?
• Have the plugin run an occasional background task that looks for tables which are marked for deletion and have run out their timer and drops them.
• After the delete button is clicked, give the user a "undo delete" button and a "delete permanently right now" button.

I'm not going to implement this yet though, partly because of complexity but mainly because if delet table becomes reversible then how about drop column etc? And adding a full undo stack is way out of scope for the moment.