Deletion protection
Right now its too easy to delete a production database! Like AWS would be great to have a deletion protection on some databases turned on which requires maybe multiple confirm screens / email link verification or something else to make it safer? and it has to be "turned off" to be deletable.
12 Replies
fascinating-indigo•2y ago
Would love to learn more about your use case. not sure if you're familiar with our branching model, but by default when a project is created it's represented by branch. This branch includes all of the data, roles, databases, etc. Are you not using branches and instead are creating databases?
deep-jadeOP•2y ago
Its what AWS has. You can't just go in and delete a db and poof its gone. It requires you to switch protection off explicitely. Also when deleting it gives by default a "final snapshot" option in all cases and hence provides from my perspective a better experience. https://aws.amazon.com/about-aws/whats-new/2018/09/amazon-rds-now-provides-database-deletion-protection/ https://aws.amazon.com/blogs/database/how-to-use-deletion-protection-to-enhance-your-amazon-dynamodb-table-protection-strategy/
Amazon Web Services, Inc.
Amazon RDS Now Provides Database Deletion Protection
Amazon Web Services
How to use deletion protection to enhance your Amazon DynamoDB tabl...
Authorized Amazon DynamoDB users can perform actions against tables using the AWS Management Console, API, AWS CLI/SDK, or AWS CloudFormation. One of many possible operations that authorized users can perform is deleting a table. During the course of regular table management operations, authorized users might accidentally delete a table. Acciden...
fascinating-indigo•2y ago
Interesting. I'll share your feedback with the team. Thanks for sharing!
deep-jadeOP•2y ago
Any project or branch with delete protection would not be deletable via the API as well. So prevents mistakes.
correct-apricot•2y ago
I would like to second this request. It's frighteningly easy to delete a database at the moment, especially considering automated backups aren't yet supported.
In my mind, something like this would be ideal:
- Delete protection option that must be explicitly switched off before the db can be deleted (as proposed by OP)
- When deleting, you have to manually type the name of the database to confirm.
- Maybe give the option to download a pg_dump of the database upon deletion? Sounds excessive, but it couldn't hurt, right?
fascinating-indigo•2y ago
This is good feedback. I'll share it with our Product team
ambitious-aqua•2y ago
100% with this
afraid-scarlet•2y ago
+1 from me
ambitious-aqua•2y ago
I found Neon is extremely dangerous.
Deleting a whole project is as easy as calling a single API by accident, and there is absolutely no backup....
dependent-tan•2y ago
We have some plans in the works for this 🙂
flat-fuchsia•2y ago
Is it possible to have an ETA on that feature?
As much as i love the product, no deletion protection and no MFA on the dashboard. It makes a dangerous mix 🫣 .
dependent-tan•2y ago
Not a promise: I hope within 3 months.