Open
Description
Currently, database deletes are soft deletes. They mark the database as deleted in the Catalog and rename it so that the name can be used, but keep the underlying files around.
Databases marked for deletion should be hard deleted after some period of time. Let's set this to 72 hours. Once a database has been soft deleted, 72 hours later, a background task should remove all underlying table files and then remove the database and its schema from the Catalog.
We should also have an API and CLI to run this process earlier for a specific database. I.e. a user deletes a database. Then they can make another call to have that database hard deleted. The follow up call should use the database ID as an identifier, not the name.