Does DataGrip have an safe guards when working on live databases?
I've just started a trial of DataGrip after being impressed by the database stuff inside Rider. And MySQL Workbench is sooo unstable it's driving me crazy.
Rarely but occasionally I need to do a live change to important databases, Workbench can block changes unless theres a LIMIT or clause for a specific ID. This is a nice piece of mind against accidental changes. Does DataGrip have any settings to help confirm changes. I also like how on submit Workbench will prompt and show you the script that's about to be executed and ask you to confirm. This is a step above simply disabling "auto commit" which is the first thing I did in DataGrip.
Also what about other monitoring things, like showing the live connections etc? I guess DataGrip can't do any of that because it's just a generic SQL editor?
Please sign in to leave a comment.
Hi,
If you edit data in grid editor you submit data to a database only when you press Ctrl+Enter (Submit). All changed data marked with color.
As for query preview, we've got plans for it in our roadmap.
As for database administration features, we do not support them at the moment.
Thank you.