5 ms·
The day PostgreSQL had a decent development suite, that's the day PGSQL is going to rocket, it's sad that even the freaking MySQL and SQLite have better (free)
by SadWebDeveloper 10y ago
The day PostgreSQL had a decent development suite, that's the day PGSQL is going to rocket, it's sad that even the freaking MySQL and SQLite have better (free) tools.
- cookiecaper 10y agoCan you expand on what you think is missing that's available for MySQL and SQLite?
- nvivo 10y agoI completely agree with SadWebDeveloper. Postgres is seriously lacking a good UI. Or maybe another way to put it is that as someone coming from MSSQL and MySql, it seems the "postgres people" are used to a completely different way of work that feels odd to me. Having worked with MSSQL for years, MS hit the right spot with Management Studio. It's an UI focused on writing SQL, and any wizard has a "Generate SQL for this" button. It let me write huge SQL files, save them, reopen then and run them. When I found dbForge Studio for MySql, I felt at home. I wish postgres had something like that. Last week I went through ALL the GUIs in the postgres wiki page and found nothing good. Valentina Studio and EMS are good, but not great. EMS has a lot of features, but honestly it bothers me it cannot even use the default system font in windows, the environment it's built to run on. It's like it's stuck in 2002. If I could sum it up, the thing I miss the most is being able to work with SQL. I want the first button in the toolbar to be a "New SQL Query" that opens a huge editor that lets me write and run SQL. Not a "new database", not "new project". Amazingly, most postgresql UIs are simply terrible at writing and running sql. It's like postgres uis are like the PHP of database UIs: people that like it have no idea how bad they are, and the very few people go elsewhere to see how much better the world is outside.
- jeltz 10y agoI think this is because most PostgreSQL professionals use the command line tools, especially psql, which is miles ahead of any command line tools the competition has. And when the experts do not use the GUI tools there will not be any feedback from people who know what a UI for a database must be able to perform. It is a chicken and the egg problem.
- g8oz 10y agoCompletely agree about MS SQL Server Management Studio, such an amazing DB management GUI. If it could be cloned, screen for screen for PG then there would be no obstacle to world domination.
- cookiecaper 10y agoI mostly use psql but I use pgadmin3 when I use a GUI (apparently now pgadmin4, but I haven't tried the new version yet) and there's a new query button that opens a big text window in which one can write SQL. You can press F5 to run the query in that window, and can highlight parts of the query to run them specifically. The output is in an adjustable-size pane with adjustable-size columns at the bottom of the window. I have used other database management tools. To me, it seems that pgadmin3's New Query window behaves pretty similarly to Microsoft's New Query window. I've used several other database GUIs (SQLyog, others) but there are none that, IMO, are night-and-day better than pgadmin3 for my basic uses. I definitely believe that pgadmin3's interface for adding columns to tables is onerous, but that doesn't happen very often since MVC frameworks brought schema definition as code into the mainstream.
- SadWebDeveloper 10y agoIMHO pgadmin X is a mess... finding were the tables, indexes and views when you first run pgadmin is dauting. Then setting permissions or properties for tables is mostly useless since they don't work at all (most of the time you have to get and fix the SQL generated rather than using the GUI). To this day its still baffles me why Python developers choose PGSQL as his defacto DB standard.
- gaius 10y agoSSMS is fantastic. Missing indexes alone is a killer feature.