4 ms·
I've been thinking about making the switch from MySQL to PostgreSQL. For database design/GUI work SQLyog has been pretty awesome over the years (auto-complete,
by virtualwhys 13y ago
I've been thinking about making the switch from MySQL to PostgreSQL.
For database design/GUI work SQLyog has been pretty awesome over the years (auto-complete, drag & drop, tabbed editor windows, export query result to csv, etc.). Is there an equivalent for PostgreSQL?
When I hear web-based I think phpMyAdmin, which, while functional, pales in comparison to SQLyog (web app in question does look a lot more polished than phpMyAdmin)
- asnyder 13y agoThese apps are nice, but the best PostgreSQL editor and GUI I've seen is EMS PostgreSQL Manager, http://www.sqlmanager.net/en/products/postgresql/manager http://www.sqlmanager.net/en/products/postgresql/manager. It even has a pretty nice query builder. Though I believe it's windows only, and also costs money. I use it every day and vastly prefer it over every other tool I've used.
- virtualwhys 13y agoLinux workstation here but run a couple of Windows VMs for browser testing and Windows only apps. EMS looks pretty feature rich, thanks for the tip.
- SkyMarshal 13y agoQuite a few: http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQ... http://www.postgresonline.com/journal/index.php?/archives/133-Database-Administration,-Reporting,-and-Light-application-development.html http://www.postgresonline.com/journal/index.php?/archives/13... Navicat is a good one if you don't mind paying $80-$250 for the personal version. http://www.navicat.com/ http://www.navicat.com/