4 ms·
I'm still on the hunt for an OSX PostgreSQL client with a table editor as awesome as aqua data studio's [0] (their java client doesn't work great on mac). With
by stevepike 12y ago
I'm still on the hunt for an OSX PostgreSQL client with a table editor as awesome as aqua data studio's [0] (their java client doesn't work great on mac). With ADS you can edit the results of any query as if it was a spreadsheet, hit "save", and ADS will generate the correct insert/update statements for you and run them. It handles copy/paste across multiple rows pretty well, even with thousands of update/inserts, and I haven't found any other editors (I've tried pgadmin, jetbrains thing, navicat, this PSequel, and some others) that do this.
http://www.aquafold.com/aquadatastudio/table_data_editor.html http://www.aquafold.com/aquadatastudio/table_data_editor.htm...
- bsg75 12y agoDbVisualizer has a similar feature, and works as well on a Mac as the Win and Linux versions - subject to occasional issues common to the JRE on your machine. http://www.dbvis.com/ http://www.dbvis.com/
- stevepike 12y agoThanks, just tried it out. This is almost there - it doesn't seem to handle copy/pasting multiple rows from excel into the grid.
- yliang 12y agoThanks for your suggestion! The feature of editing query results is actually the second highest priority item in my todo list. (The first one is Query Bookmarks.)
- captainchaos 12y agoThe latest PyCharm 4.0 IDE from JetBrains support just this feature, and it's great. I am guessing that the upcoming 0xDBE will support this in a standalone app if you don't need a full blown IDE for another language outside of SQL. https://www.jetbrains.com/dbe/ https://www.jetbrains.com/dbe/
- stevepike 12y agoLooking forward to trying it out! I've got the evaluation version of Intellij IDE and it doesn't handle copy/paste across multiple cells.