Alecaddd / sequeler

SQL Client built in Vala
GNU General Public License v3.0
800 stars 66 forks source link

Double click on a line should open a window #67

Open bilelmoussaoui opened 6 years ago

bilelmoussaoui commented 6 years ago

I think that double clicking on a line of the SELECT results should open a new window with the data of it shown as key : value and with the possiblity to modify the data (or not).

The reason why I'm asking for this, is that I need to read a database with articles and it's impossible to read if the data is correctly being saved :(

Alecaddd commented 6 years ago

Yes, this behavior is listed in an upcoming release. I'm aware that right now it's a bit annoying how the results table works >_>

coleander commented 6 years ago

Maybe not open it in a new window, but handle it like Sequel Pro does it, basically when you double click a field it turns into an editable field, and if you unfocus it, it's saved(You could add a button so that you have to explicitly press save, just like DBeaver does it).

If the content is large maybe allow for opening the specific fields content in a popup(That you can edit it in).

Alecaddd commented 6 years ago

I'll work on this implementation later this month, but I have to decide how to properly handle it. Already the table names on the left sidebar are editable with this method, double click to edit, enter to confirm, esc to cancel.

For long data or multiple options, I need to find a viable solution to properly handle it. Sequel Pro is really smart and I'd love to emulate its behavior. Will see how complicated it is 😄

coleander commented 6 years ago

Sounds great. If you follow Sequel Pro's behavior I don't think much can go wrong design-wise :)

fernandofreamunde commented 5 years ago

I came here to open a ticket requesting the double click to edit like Sequel Pro... I like what I see in this thread and I see I'm not the only one asking for this :)

Thanks keep up the good work I'm going to donate sooner rather than later. keep up the good work!

Alecaddd commented 5 years ago

I start working on this issue and here's the upcoming UX behavior to tackle this feature.

Double Click on a row will transform the cell into an inline entry field where you can edit the content directly inline.

Right click -> Edit Row will open a Dialog with the full list of editable data with an ordered grid of key:value as column_label:gtk_entry

Finger crossed!

fbnlsr commented 3 years ago

Any update on this feature?