search

sqlectron / sqlectron-gui

A simple and lightweight SQL client desktop with cross database and platform support.
https://sqlectron.github.io/
MIT License
4.55k stars 523 forks source link

Edit Data and Update #609

Open wavecoders opened 3 years ago

wavecoders commented 3 years ago

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

maxcnunes commented 3 years ago

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

MasterOdin commented 3 years ago

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.

maxcnunes commented 3 years ago

That is what I had in mind actually.