Database Table Editor in IntelliJ IDEA 10
August 30th, 2010 by Gregory ShragoIntelliJ 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.

August 30th, 2010 at 9:18 am
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.
August 30th, 2010 at 11:40 am
I’d like to try, but in 96.1020 I can’t even create a datasource
See http://youtrack.jetbrains.net/issue/IDEA-58147
August 30th, 2010 at 2:15 pm
@Rob feel free to create a feature request ticket at http://youtrack.jetbrains.net/
September 4th, 2010 at 6:58 am
oh nice, since this will also be in PHPStorm, it would be nice if it could integrate into Doctrine and Propel schema definitions.