Обсуждение: pgAdmin 4.x vs pgAdmin 3.x
Hi, Regarding the release of pgAdmin 4 I need to point out some problems I'm facing with the new version. First and most annoying - it is slow, really slow - one thing that pgAdmin had over other db management systems (MySQL Workbench,Microsoft Management Studio etc.) was its speed - now it's gone... There is a significant regress in functionality: - no favorites - no recent queries - no single line select (query tool) - no notepad - no bracket highlight (start-end, orphan) - after every query result columns resize to some predefined width (should stay as set) - no possibility to detach panel to window (multi monitor setup) - view data result is shown without oid (no option to set it up) - view data - disabled field edit when no primary key is set (that's why oids are for!) - cannot select and copy fields from result - triggers does not descent to its function (it's under properties) - no object search - no option to change database in query tool - history in query tool is useless - can't see query if it is little longer, no copy/paste - ... And also bugs: - only one error message for every query error: "Not connected to the server or the connection to the server has been closed." - view data last/first 100 does not work - always first 100 - view data query is not editable (why is it there???) - copy button does nothing - global copy/paste mess - in one place Ctrl+C works other not, the same for context menu - ... I've tried to work with version 4.x for few hours - gave up... The issues above are only from these few hours... -- Tomek
More to Add: Core features missing from pgadmin4 -There's no search functionality in the sql-query/function editor -You cannot dynamically change the font size bigger/smaller with ctrl-mouse-scroll -You cannot open a query in a new window -Functions all open up in a tab named 'Query-untitled' with no obvious way to change the title. Once you have 3+ functions open, the navigation is unwieldy -'View Data' opens up in tabs named 'Query-1', 'Query-2'...etc. navigation is unwieldy once the tab is opened. -my favorite feature of pgadmin3 data viewer: double click on a column to auto-side the column... is missing Things that would be nice to have: - View next 100/500/1000/etc rows instead of being limited to the top or bottom rows - ability to edit the query from a 'view data' click.. if there is a primary key on the table... still allow editing - reordering columns in the 'create table' dialog - show 'create script'-style sql for when clicking on an item (I think we all agree you can safely hide the dashboard once you're clicking around in the schema) While I completely understand the push to new technology and an easier codebase to maintain... but with all these major usability issues, pgadmin4 is definitely not ready for prime time and many of us would appreciate some continued development on pgadmin3 by the core team. I suggest starting up a page to keep track of all these features that are must-haves and then the community can vote and prioritize? On 11/23/16 09:54, Tomek wrote: > Hi, > > Regarding the release of pgAdmin 4 I need to point out some problems I'm facing with the new version. > > First and most annoying - it is slow, really slow - one thing that pgAdmin had over other db management systems (MySQLWorkbench, Microsoft Management Studio etc.) was its speed - now it's gone... > > There is a significant regress in functionality: > > - no favorites > - no recent queries > - no single line select (query tool) > - no notepad > - no bracket highlight (start-end, orphan) > - after every query result columns resize to some predefined width (should stay as set) > - no possibility to detach panel to window (multi monitor setup) > - view data result is shown without oid (no option to set it up) > - view data - disabled field edit when no primary key is set (that's why oids are for!) > - cannot select and copy fields from result > - triggers does not descent to its function (it's under properties) > - no object search > - no option to change database in query tool > - history in query tool is useless - can't see query if it is little longer, no copy/paste > - ... > > And also bugs: > > - only one error message for every query error: "Not connected to the server or the connection to the server has been closed." > - view data last/first 100 does not work - always first 100 > - view data query is not editable (why is it there???) > - copy button does nothing > - global copy/paste mess - in one place Ctrl+C works other not, the same for context menu > - ... > > I've tried to work with version 4.x for few hours - gave up... The issues above are only from these few hours... > > > -- > Tomek > >
On 2016-11-23 9:43 AM, Mark Murawski wrote: > While I completely understand the push to new technology and an easier codebase > to maintain... but with all these major usability issues, pgadmin4 is definitely > not ready for prime time and many of us would appreciate some continued > development on pgadmin3 by the core team. I think that what is more likely and reasonable to happen is that the core team continues to focus on pgAdmin 4, but that they address the issues you raised by adding the desired features to pgAdmin 4, and meanwhile the latest pgAdmin 3 release is still there for those who prefer it. > I suggest starting up a page to keep track of all these features that are > must-haves and then the community can vote and prioritize? I agree with having the addition of this tracking/voting page. In fact, I think there already exists a similar website for the Postgres DBMS itself. -- Darren Duncan
Hi, Almost six months passed and... > - no favorites > - no recent queries > - no single line select (query tool) > - no notepad > - no bracket highlight (start-end, orphan) > - after every query result columns resize to some predefined width (should stay as set) > - no possibility to detach panel to window (multi monitor setup) > - view data result is shown without oid (no option to set it up) > - view data - disabled field edit when no primary key is set (that's why oids are for!) > - cannot select and copy fields from result > - triggers does not descent to its function (it's under properties) > - no object search > - no option to change database in query tool > - history in query tool is useless - can't see query if it is little longer, no copy/paste Nope, none of the above put BACK in... As for bugs: > - only one error message for every query error: "Not connected to the server or the connection to > the server has been closed." We've got an improvement - now even "select 2/0;" returns successfully... > - view data last/first 100 does not work - always first 100 Ok. This is fixed. > - view data query is not editable (why is it there???) > - copy button does nothing > - global copy/paste mess - in one place Ctrl+C works other not, the same for context menu The above bugs - still unresolved... Sorry but this is a disaster, this software should be labeled praAlpha for testers only... You (developers) stripped features from already feature lacking pgAdmin 3 and replaced them with this slow blob. What is the point of creating standalone app using html/javascript??? New pgAdmin uses Qt - which is super - portable, modern, fast... but instead of using widgets developers used qwebengine and build everything on top of it... So basically it is server with bundled browser serving everything as a webpage... And it will never be as fast as pgAdmin 3.x. And yet I would agree that it could be good when the new technology although slower, improves functionality - but in this case we've got less and slower... Old phpPgAdmin had more features and was lighting fast in comparison. Everything You do in this soft takes 10 times more time than before, from queries to this annoying dashboard which always consumes cpu and can't be switched off... Every piece of interface drags behind mouse... Sorry but I'm sticking to pgAdmin 3 an psql. -- Tomek