Important Features MISSING!

[puntloos]

I'm so amazed these features aren't in SQLyog since v1.0… 😮

When in Insert/Update Table mode (F11):

1/ Why am I not able to sort the table the way I want? Other than manually formulating SQL queries I see no way to efficiently find a row in a large table and update it. This functionality would be the PRIMARY reason for me to buy/use a program like SQLyog! Heck, even phpmyadmin allows me to find a row (okay, with a manual SQL query) but once it's on the screen I can quickly choose to edit it. Maybe Im grossly overlooking something..

2/ What's the use of the 'Cancel' button when all changes you make, accidental or no, are made to the tables instantly?

3/ Why can't I resize the I/U Table window?

If *I* were to design such an editor window (hah as if, I be no good at programming) I would:

1/ Allow users to sort tables (asc/desc) by clicking on the field names, like it's done in the view data window

2/ Allow to dynamically search either the entire table or a column (field). I'd create radio buttons above each field allowing me to select the field I wanna search through (or the leftmost column radio button to select entire table) and then update the view with each letter typed.

– For example if I had a user database with fields 'userid' 'nickname' 'email' and Id select the nickname field to search, then hit the 'p' key, only the rows containing nicknames starting with 'p' would still be displayed. “*p*” would display all nicks containing p… 'punt' would probably only still show my nickname ('puntloos') etc.

3/ Remember changes users WANT to make in this editor, and commit the changes when pressing the 'Done' button and NOT commit them if I hit 'Cancel'. I feel extremely uncomfortable editing a live table with your tool, knowing that one typo, wrong key could irrevokably damage my table.

4/ Allow me to resize the display window

5/ Make me go into this editor if I doubleclick the table in the main SQLyog window.

Again, maybe I'm missing something, or maybe this functionality will be enabled once I register/unlock the program, but if I were (able) to write a SQL client this would be the MAIN thing Id write, right after making it succesfully connect to the SQL server.. why write a SQL client if it doesnt really make basic table management more efficient?

[puntloos]

Oh, two more things I'd implement:

6/ Allowing people to sort by this, then sort by that, then..

So for example if I had a table with gender, email, nickname, age:

a/ click on gender: it puts all men and women together (a “1 <" appears next to 'gender') b/ click on age: sorts them by age (but keeps men/women together) (a “2 <" appears next to 'age') c/ click on age again: makes age sort descending instead of ascending (“2 >” next to age)

d/ click on age again: removes the sort by age and puts men/women in the order they appear in the DB (“2 >” disappears next to age)

7/ Make a tickable box “recheck DB before write” next to the 'Done' button, so before applying all changes I've made in my table editing session the program should check if the values haven't changed already, while I was busy. Of course you can't be sure the table doesnt change between the check and the write, but at least it'll be safER.

[Shadow]

1. You have grossly overlooked something! 😀

Type in a select statement with a WHERE clause to find the rows you want to update, then hit F8 – Select for update.

2. You are right about the Cancel problem.

3. SQLyog is a db admin tool and not an end-user front end, therefore it was not designed to handle problems arising from concurrent data manipulation. That's why I think there is absolutely no need for a “recheck DB before write” button.

4. Better searching in the I/U window might be useful, but apparently this function is not a priority (similar request was submitted before).

[puntloos]

Shadow> naw I didnt overlook THAT much, I am now a moderate PHP programmer so I'm aware of how to formulate SQL queries, Im just looking at this from an admin point of view. I'm the admin of a chat/mail site, and all I want (for christmas.. lala) is a 'GUI' for my database so I can also quickly change a few values here and there.

Thanks for your comments, I do think the 'recheck' function would be useful, however I see your point as well.. In my opinion sometimes you have to do things the ugly way 😛 I mean sure I could take my site offline every time I want to change some foulmouthed kid's user info, then edit, then put it up again, but just a quick recheck would be neat-o ™

[Shadow]

I thought you missed the 'Select for update' feature, that's why I was talkink about SQL statements…

Anyway, you can connect to the same db multiple times and before applying any chages from one connection, swith to the other and check for differences.

[puntloos]

Nah I found that feature.. but thanks! 🙂

And hmm yea multiple connects would sorta fix it..

Anyway.. SQLYog programmers actually reading this? Or are you hard at work implementing all my featurerequests? If not why not? 😛 – don't be a stranger now!

(oh and Merry Xmas etc.)

[Ritesh]

Quote:

1/ Allow users to sort tables (asc/desc) by clicking on the field names, like it's done in the view data window

2/ Allow to dynamically search either the entire table or a column (field). I'd create radio buttons above each field allowing me to select the field I wanna search through (or the leftmost column radio button to select entire table) and then update the view with each letter typed.

– For example if I had a user database with fields 'userid' 'nickname' 'email' and Id select the nickname field to search, then hit the 'p' key, only the rows containing nicknames starting with 'p' would still be displayed. “*p*” would display all nicks containing p… 'punt' would probably only still show my nickname ('puntloos') etc.

3/ Remember changes users WANT to make in this editor, and commit the changes when pressing the 'Done' button and NOT commit them if I hit 'Cancel'. I feel extremely uncomfortable editing a live table with your tool, knowing that one typo, wrong key could irrevokably damage my table.

4/ Allow me to resize the display window

All the features except “2” are planned for SQLyog Max.

[Author]

Posts