Lock table from drop

Gwyneth's profile image Gwyneth posted 10 months ago in General Permalink

The table KiB information is a waste of space. Who cares if the table is 32.2 KiB or 74.6 kiB.

Use that space to implement a locking mechanism to prevent unwanted 'drops'. That functionality is needed in HeidiSQL.

2 attachment(s):
  • Slide1
  • Slide2
ansgar's profile image ansgar posted 10 months ago Permalink

You can hide the size info:

  • Rightclick the tree somewhere
  • point to "Tree style options"
  • click "Display size of objects" to toggle that column.
Gwyneth's profile image Gwyneth posted 10 months ago Permalink

Thanks. Suggest it be hidden by default.

What about the lock icon? I think it would be an added value for HeidiSQL.

Gwyneth's profile image Gwyneth posted 6 months ago Permalink

Angsar, I just deleted by mistak a table. It will take me significant effort to get that table back. Why are you reluctant to add a lock mechanism?

ansgar's profile image ansgar posted 6 months ago Permalink

Such a "lock" mechanism looks non-intuitive and duplicated to me. Especially as MySQL already provides a way to restrict drop privileges. Also, HeidiSQL shows a warning dialog before actually dropping a table. That dialog is meant to be the last warning.

TTSneko's profile image TTSneko posted 6 months ago Permalink

I just deleted by mistak a table. It will take me significant effort to get that table back. Why are you reluctant to add a lock mechanism?

It is your fault for not working with (or having) backups. It is your fault for ignoring the in-place warnings.

So tell me, what would yet another mechanism change ? Surely it would not cure stupid, so why bother?

Gwyneth's profile image Gwyneth posted 6 months ago Permalink

Have you guys never studied probability? The probability of dropping a table at any given time is very low. Given enough the though and you will mistakenly drop a table. Why not provide the feature and let people hide it or ignore it if they don't want to use it?

Honestly, have you never been working late at night and really tired? Seems pretty intuitive to me.

Gwyneth's profile image Gwyneth posted 6 months ago Permalink

Given enough time though...

Gwyneth's profile image Gwyneth posted 6 months ago Permalink

How about a compromise?

A message box pops up "Save this table to your desktop just in case you need it later" with a "Save" button right below the text. How could that be a bad idea?

Please login to leave a reply, or register at first.