IntelliJ IDEA X features a simple database table editor and viewer. You can add and remove rows, sort by specific column and choose columns to display just by pressing F4 on a table in the Data Sources view.
If you find the console-like way better than the GUI way, you can still run all those delete from… and insert into… statements in the Database console.
Try this in the latest IntelliJ IDEA 10 EAP and let us know your thoughts on it.
Now, if there were a way to make DbUnit-style XML files directly from IDEA, that would be one less program I need to have open at any given instance.
I’d like to try, but in 96.1020 I can’t even create a datasource
See http://youtrack.jetbrains.net/issue/IDEA-58147
@Rob feel free to create a feature request ticket at http://youtrack.jetbrains.net/
oh nice, since this will also be in PHPStorm, it would be nice if it could integrate into Doctrine and Propel schema definitions.