search

scylladb / scylla-cqlsh

A fork of the cqlsh code
Apache License 2.0
11 stars 29 forks source link

RFC: CQLSh safe mode. Example: are you sure prompt before dropping a table/keyspace #79

Open tzach opened 2 months ago

tzach commented 2 months ago

This is from a disclose user

I accidentally dropped the wrong keyspace... We don't have backups running . Is there any way that I can stop the keyspace from dropping and losing all the data?

It would be nice if cqlsh can validate before doing an irreversible dangerous action, like dropping a keyspace.

For example:

Are you sure you want to DROP KEYSPACE xxx? [N/y]

This can be part of a "safe-mode" or Garudrail CQLSh mode (not sure it is needed) https://issues.apache.org/jira/browse/CASSANDRA-12349

One can claim this should be a core feature, but since IMHO, it does not make sense to add such limits on API calls.