Add/edit rows

[Rid]

Describe the solution you'd like At the moment we have to use a 3rd party tool for manipulating existing tables, such as for quick table row edits or additions. It would be great if we had one tool inside VS code for doing this.

I have been using @devexpress/dx-react-grid-material-ui myself in another project in uncontrolled mode, it's quite simple to add this kind of manipulation. I've not had a great chance to look at this project's code to ascertain what the dependencies would be regarding the different dialects, have you thought about this?

Describe alternatives you've considered Previously we've been using DataGrip from jetbrains: https://www.jetbrains.com/datagrip/features/data_editor.html

It has many features such as edit/addition/clone.

[mtxr]

This is upcoming!

I've started a new PR to switch from react-table to @devexpress/dx-react-grid-material-ui as seen on #297 .

I'm now working on add the vscode color scheme to it and I'll release it.

Add and edit rows will be done right after that, because it requires some work on the dialects to respect the changes required by the user. SQLTools needs to be very careful with this kind of change on the DB. Queries are written by the user, we just execute it. But to add and edit rows from the UI needs to be 100% reliable on all dialects

[mtxr]

Just moved to react-grid. Next step is to allow editing :tada: :tada: :tada:

[Rid]

Great job @mtxr!

[regniblod]

Hello! Any updates on this? Is one of the few things left keeping me from moving from IntelliJ IDEs to VSCode.

[Gruntfuggly]

Just found this extension and it seemed awesome, until I needed to modify a value in a table. Was hoping to ditch Squirrel and use this...

[mtxr]

@Gruntfuggly as awesome as todo-tree? 🤣 I use yours as well

[Gruntfuggly]

Lol. Glad it's helping somebody! I think I'm still going to be able to get rid of squirrel, but i assume the only way to update the table at the moment is via a query?

[mtxr]

Yeah, for now.

I had to do some changes in the extension and the way we create queries automatically in the extension to make it possible. So I expect this to be the next major feature coming.

[fela93]

Great job @mtxr! Any update when this feature will be available?, very required feature

Thanks

[dcrystalj]

@mtxr any code available already. we can contribute as this is kind of must have feature ?

[smaartdata]

Any update?

[Phara0h]

Would love to have this feature.

[bfine9618]

I would use this extension exclusively with this feature

[emil14]

Any updates? This one is extremely needed!

[miztizm]

Hello, any news on this feature ?

[Enubia]

I'd also like to see this one added, would be a huge benefit!

[dcrystalj]

I ended using this plugin https://marketplace.visualstudio.com/items?itemName=cweijan.vscode-database-client2

[arifur]

Any update on this?

[gjsjohnmurray]

I'm not aware of any in-progress work in this area, nor of plans to start.

[bombillazo]

It seems like this is the essential feature missing for this extension.

[Tyrenn]

Would love to have this feature

[piavgh]

@mtxr : hi, is there any ongoing progress with this issue?

[gjsjohnmurray]

@piavgh none that I am aware of.

[Ioann44]

No updates still?

[gjsjohnmurray]

@Ioann44 no. If you are in a position to fund development of this feature please get in touch.