And it doesn't even say anything about it. Oh, and pgAdmin 4 doesn't support older versions of PostgreSQL either. So why don't I use pgAdmin 3? Because it doesn't support PostgreSQL 9.5 or 9.6.
And this is done by people in the core team, who I would think use this daily and want it to work as smoothly as possible. And if you rerun the query you have to resize them all over again. No, you can't just double click to make them fit, or become bigger, like in pgAdmin 3. You can imagine the white space on the left of them, all wasting screen space.Ĭolumn widths in the result grid are by default too small. Table names are the 8th level on the tree. But you will see a lot of white space because the information you want is on the 8th level and above. Let's waste screen space for making the treeview larger than needed, otherwise you can't see the information there. The tree view doesn't have a horizontal scrollbar. Why bother showing the run time and row count on a status bar when I can mouse around and switch tabs? Oh, wait, I can switch to Messages tab to check it out. It was there for a second and now it's gone. How many rows did the query return? Who knows.
This is a professional tool.Īnother issue about this flashy fading thing: the information disappears. I don't need distracting fading boxes, this isn't a consumer web page.
In pgAdmin 3 they just had a status bar which showed this info. Oh, and all queries show a nice fading messagebox when they finish. Truncate table? I'll show some random alert with the title AlertifyJS saying "Are you sure you want to truncate table ?" which doesn't really make me want to click Yes since I have no idea if the table I want will be truncated. Want to copy some value from a result table? No. Want to switch between tabs? Ctrl-Tab? No, we don't support that. Want to resize query result windows? You can kinda do it, but only inside the main window.
Want to put two query windows into different monitor than the main program? Nope, we have one window and that's all you get. Want to jump to beginning or end? Don't support that either. View data from a table and want to use PgUp/PgDn to move in it? You're out of luck. Sure, I an run the query with F5, but how about refreshing the tree when I create a new table from SQL query? Right click, refresh, wait. There is no concept of keyboard commants. This wouldn't be the worst thing usually, but I have a lot of tables and a lot of information I want to just see easily. It has headings and whatnots that waste screenspace. PgAdmin 3 had a small font and everything was nice as lists. And sucks all the power from one core on my Intel i7 machine! And then it even crashes. It darkens the window and has a rolling thing. This is very annoying.Īlso noticed a major issue: put a long-running query in pgAdmin 4. pgAdmin 3 showed properties of a table in sub-second times.
I don't know why this is, I guess it's loading too much data. It takes ages to load data from the server. But at least it did things reasonably.įirst of all, it's slow. Sure, it hung itself if you had two long queries running at the same time. Now, pgAdmin 3 wasn't perfect or wonderful in any way, but it got the job done. I'll add some pictures later probably to showcase some of these issues. It's because it really doesn't work the way it should. And it's not because I don't want change. This is just a quick rant about it because I'm trying so hard to get things done with it but it's just not letting me. This makes no sense to me, since after using it for 15 minutes I saw so many problems with it that it cannot really be the application they wanted to produce. A tweet I saw mentioned 10k hours spent on the first version. It looks like the PostgreSQL development team has decided to rewrite pgAdmin into a new version and I guess they're quite happy about it.