sqlectron-gui
sqlectron-gui copied to clipboard
Edit Data and Update
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
I plan to support this, but there are a few other issues I need to work on first.
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.
That is what I had in mind actually.