Thread: I'd like a lightweight alternative to pgAdmin4 ?
Hi call me oldfashioned but I'd like to have a lightweight alternative to pgAdmin4. pgAdmin3 does in 99% of the time all I have to do with PG, throwing SQL at the server and getting some stuff back. It starts fast, offers multi-window and drag&drop of scripts into the editor. I really do appreciate all the work put into PG and pgAdmin4 but pgAdmin4 is more nice to look at than to work with. pgAdmin3 sadly doesn't like PG 10, so I'm looking in a dead end. Is there any other tool to talk with PG that doesn't carry so much bulk? Regards Andreas
Thanks and Regards,
Francis
07764 225 942
Pharmarketeer is a registered company in England and Wales 06940361, registered office 64 Westbank Road, Birkenhead, Merseyside, CH42 7JP
"So when targets seem stupid, arbitrary and unfair it's because they are. The only way to improve is to look at the whole system people are operating with, the basic tools, their training, how much initiative they are allowed, are you measuring the right things (more about that later) and then you can improve. But it's the system you improve, not the people you beat into performing even worse." Unicorns in the mist
Hi
call me oldfashioned but I'd like to have a lightweight alternative to pgAdmin4.
pgAdmin3 does in 99% of the time all I have to do with PG, throwing SQL at the server and getting some stuff back.
It starts fast, offers multi-window and drag&drop of scripts into the editor.
I really do appreciate all the work put into PG and pgAdmin4
but pgAdmin4 is more nice to look at than to work with.
pgAdmin3 sadly doesn't like PG 10, so I'm looking in a dead end.
Is there any other tool to talk with PG that doesn't carry so much bulk?
Regards
Andreas
Hi
call me oldfashioned but I'd like to have a lightweight alternative to pgAdmin4.
pgAdmin3 does in 99% of the time all I have to do with PG, throwing SQL at the server and getting some stuff back.
It starts fast, offers multi-window and drag&drop of scripts into the editor.
I really do appreciate all the work put into PG and pgAdmin4
but pgAdmin4 is more nice to look at than to work with.
pgAdmin3 sadly doesn't like PG 10, so I'm looking in a dead end.
Is there any other tool to talk with PG that doesn't carry so much bulk?
Regards
Andreas
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: Andreas <maps.on@gmx.net>
To: pgadmin-support@lists.postgresql.org
Sent: Monday, October 9, 2017 10:15 PM
Subject: I'd like a lightweight alternative to pgAdmin4 ?
pgAdmin 4 is allready at V 2.0 Am 09.10.2017 um 13:13 schrieb Francis Fish: > Try "upgrading" to version 1.2 > > > Thanks and Regards, > > Francis > > 07764 225 942 > > Pharmarketeer is a registered company in England and Wales 06940361, > registered office 64 Westbank Road, Birkenhead, Merseyside, CH42 7JP > > "So when targets seem stupid, arbitrary and unfair it's because they > /are/. The only way to improve is to look at the whole system people are > operating with, the basic tools, their training, how much initiative > they are allowed, are you measuring the right things (more about that > later) and then you can improve. But it's the /system/ you improve, not > the people you beat into performing even worse." Unicorns in the mist > <https://leanpub.com/unicorns> > > CV http://www.pharmarketeer.com/francis.html > > Lean Teams Consultancy <http://lean-teams.co.uk> > > On Mon, Oct 9, 2017 at 10:15 AM, Andreas <maps.on@gmx.net > <mailto:maps.on@gmx.net>> wrote: > > Hi > call me oldfashioned but I'd like to have a lightweight alternative > to pgAdmin4. > > pgAdmin3 does in 99% of the time all I have to do with PG, throwing > SQL at the server and getting some stuff back. > It starts fast, offers multi-window and drag&drop of scripts into > the editor. > > I really do appreciate all the work put into PG and pgAdmin4 > but pgAdmin4 is more nice to look at than to work with. > > pgAdmin3 sadly doesn't like PG 10, so I'm looking in a dead end. > > Is there any other tool to talk with PG that doesn't carry so much bulk? > > > Regards > Andreas > >
Am 09.10.2017 um 13:19 schrieb Murtuza Zabuawala: > On Mon, Oct 9, 2017 at 2:45 PM, Andreas <maps.on@gmx.net > <mailto:maps.on@gmx.net>>wrote: > > Hi > call me oldfashioned but I'd like to have a lightweight alternative > to pgAdmin4. [...] > Is there any other tool to talk with PG that doesn't carry so much bulk? > > psql is a great tool for your need. Well, when I wrote "lightweight" I didn't mean THAT lightweight. ;) Really, I just need some SQL editor that can talk with the server like pgA 3 does. No fancy stuff like Backup and all that. I do use the great "mark some sql lines and execute just those with F5"-feature a lot. So this should be supported, too.
Thanks and Regards,
Francis
07764 225 942
Pharmarketeer is a registered company in England and Wales 06940361, registered office 64 Westbank Road, Birkenhead, Merseyside, CH42 7JP
"So when targets seem stupid, arbitrary and unfair it's because they are. The only way to improve is to look at the whole system people are operating with, the basic tools, their training, how much initiative they are allowed, are you measuring the right things (more about that later) and then you can improve. But it's the system you improve, not the people you beat into performing even worse." Unicorns in the mist
pgAdmin 4 is allready at V 2.0
Am 09.10.2017 um 13:13 schrieb Francis Fish:Try "upgrading" to version 1.2
Thanks and Regards,
Francis
07764 225 942
Pharmarketeer is a registered company in England and Wales 06940361, registered office 64 Westbank Road, Birkenhead, Merseyside, CH42 7JP
"So when targets seem stupid, arbitrary and unfair it's because they /are/. The only way to improve is to look at the whole system people are operating with, the basic tools, their training, how much initiative they are allowed, are you measuring the right things (more about that later) and then you can improve. But it's the /system/ you improve, not the people you beat into performing even worse." Unicorns in the mist <https://leanpub.com/unicorns>
CV http://www.pharmarketeer.com/francis.html
Lean Teams Consultancy <http://lean-teams.co.uk>
On Mon, Oct 9, 2017 at 10:15 AM, Andreas <maps.on@gmx.net <mailto:maps.on@gmx.net>> wrote:
Hi
call me oldfashioned but I'd like to have a lightweight alternative
to pgAdmin4.
pgAdmin3 does in 99% of the time all I have to do with PG, throwing
SQL at the server and getting some stuff back.
It starts fast, offers multi-window and drag&drop of scripts into
the editor.
I really do appreciate all the work put into PG and pgAdmin4
but pgAdmin4 is more nice to look at than to work with.
pgAdmin3 sadly doesn't like PG 10, so I'm looking in a dead end.
Is there any other tool to talk with PG that doesn't carry so much bulk?
Regards
Andreas
BigSQL has a pgAdmin 3 LTS fork they are providing minimal support for to ease the transition. It will connect to 10 without warnings, but it doesn’t support the new features.
https://www.openscg.com/2017/06/pgadmin3-lts-now-supports-postgresql-10/
I would suggest keep trying pgAdmin 4 and reporting on issues, so progress towards making it the tool we want it to be.
I too am finding it to be a rough time for PostgreSQL GUIs. I find myself hopping between pgAdmin 3, pgAdmin 4, and DataGrip.
--
Michael Rasmussen
Sr. Data Engineer
Porch
From: Francis Fish <francis.fish@pharmarketeer.com>
Date: Tuesday, October 10, 2017 at 1:06 AM
To: Andreas <maps.on@gmx.net>
Cc: "pgadmin-support@lists.postgresql.org" <pgadmin-support@lists.postgresql.org>
Subject: Re: I'd like a lightweight alternative to pgAdmin4 ?
I haven't tried 2.0 but all versions I have tried after 1.2 on my Mac are so slow to paint the screen they are unusable.
Thanks and Regards,
Francis
07764 225 942
Pharmarketeer is a registered company in England and Wales 06940361, registered office 64 Westbank Road, Birkenhead, Merseyside, CH42 7JP
"So when targets seem stupid, arbitrary and unfair it's because they are. The only way to improve is to look at the whole system people are operating with, the basic tools, their training, how much initiative they are allowed, are you measuring the right things (more about that later) and then you can improve. But it's the system you improve, not the people you beat into performing even worse." Unicorns in the mist
On Tue, Oct 10, 2017 at 8:38 AM, Andreas <maps.on@gmx.net> wrote:
pgAdmin 4 is allready at V 2.0
Am 09.10.2017 um 13:13 schrieb Francis Fish:Try "upgrading" to version 1.2
Thanks and Regards,
Francis
07764 225 942
Pharmarketeer is a registered company in England and Wales 06940361, registered office 64 Westbank Road, Birkenhead, Merseyside, CH42 7JP
"So when targets seem stupid, arbitrary and unfair it's because they /are/. The only way to improve is to look at the whole system people are operating with, the basic tools, their training, how much initiative they are allowed, are you measuring the right things (more about that later) and then you can improve. But it's the /system/ you improve, not the people you beat into performing even worse." Unicorns in the mist <https://leanpub.com/unicorns>
CV http://www.pharmarketeer.com/francis.html
Lean Teams Consultancy <http://lean-teams.co.uk>
On Mon, Oct 9, 2017 at 10:15 AM, Andreas <maps.on@gmx.net <mailto:maps.on@gmx.net>> wrote:
Hi
call me oldfashioned but I'd like to have a lightweight alternative
to pgAdmin4.
pgAdmin3 does in 99% of the time all I have to do with PG, throwing
SQL at the server and getting some stuff back.
It starts fast, offers multi-window and drag&drop of scripts into
the editor.
I really do appreciate all the work put into PG and pgAdmin4
but pgAdmin4 is more nice to look at than to work with.
pgAdmin3 sadly doesn't like PG 10, so I'm looking in a dead end.
Is there any other tool to talk with PG that doesn't carry so much bulk?
Regards
Andreas
try SQLeo hosted at sourceforge and not in the GUI list PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html
On 2017-10-12 15:59, Michael Rasmussen wrote: > I would suggest keep trying pgAdmin 4 and reporting on issues, so > progress towards making it the tool we want it to be. It won't happen, choices have been made that preclude it from ever being a fast, lightweight native app. "Stable", "Fast", and "Features" have been redefined; this project does not have the same goals as the previous one. -- Stephen
On 2017-10-12 9:16 PM, Stephen Cook wrote: > On 2017-10-12 15:59, Michael Rasmussen wrote: >> I would suggest keep trying pgAdmin 4 and reporting on issues, so >> progress towards making it the tool we want it to be. > > It won't happen, choices have been made that preclude it from ever being > a fast, lightweight native app. "Stable", "Fast", and "Features" have > been redefined; this project does not have the same goals as the > previous one. What distinguishes a "native" app from a "non-native" one really? In the modern day, pgAdmin 4 is just as much a "native" app as pgAdmin 3 was. Its a fallacy to think that just because something isn't written in C++ or similar pre-compiled language that by nature it can't be fast. Even pgAdmin 3 wasn't a "native" app by some strict standards either because it would work on multiple operating systems. (Anyone responding to this, don't include me in the recipient list, only send it to the pgadmin list, I will see that copy.) -- Darren Duncan
> On 13 Oct 2017, at 05:16, Stephen Cook <sclists@gmail.com> wrote: > >> On 2017-10-12 15:59, Michael Rasmussen wrote: >> I would suggest keep trying pgAdmin 4 and reporting on issues, so >> progress towards making it the tool we want it to be. > > It won't happen, choices have been made that preclude it from ever being > a fast, lightweight native app. "Stable", "Fast", and "Features" have > been redefined; this project does not have the same goals as the > previous one. Correct. pgAdmin 4 is now provably significantly faster than pgAdmin 3 where it counts the most (query tool), and has farfew known issues - not one universally repeatable crash bug that we know of, compared to various unfixable ones in pgAdmin3.
Maybe that will help to make pgAdmin4 feel a little bit lighter weight.
try SQLeo
hosted at sourceforge
and not in the GUI list
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin- support-f2191615.html
--
www.greenwoodmap.com