sqlectron-gui icon indicating copy to clipboard operation
sqlectron-gui copied to clipboard

Edit Data and Update

Open wavecoders opened this issue 3 years ago • 3 comments

When we have a query, we can see the data in the grid, why not allow for editing that field instead of an update at least for simple updates to values

wavecoders avatar Mar 24 '21 10:03 wavecoders

I plan to support this, but there are a few other issues I need to work on first.

maxcnunes avatar Mar 24 '21 13:03 maxcnunes

We should look to support editing a DB table in the same way as other editors do, where you can "explore" a table (opening it into a table) and from there edit values and then commit the changes once done. I'm envisioning a similar mechanism for how DataGrip and Beekeeper work in this regard (for two examples).

Not really sure I agree in editing the data that comes back for arbitrary select clauses. It's maybe doable, but probably requires augmenting the query identifier to have a more complete AST and such to allow editing result sets from certain queries and not other, etc.

MasterOdin avatar Mar 24 '21 14:03 MasterOdin

That is what I had in mind actually.

maxcnunes avatar Mar 24 '21 21:03 maxcnunes