Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Why people care about PostGIS and Postgres

pathtocituscon.transistor.fm

Post reply on HN
Print view View original

11–20 of 42 posts

Re: Why people care about PostGIS and Postgres

#11

Post by GiorgioG »

JamesMcMinn wrote: post #6
systems wrote: post #4

It kinda always baffled me that MySQL always had better (free) GUIs (MySQL WorkBench) while what was in my opinion (and nowadays I think most others) didnt have any good ones There were always some commercial GUIs for PGSQL, but the free or opensource ones were very bad PgAdmin is very bad in my opinion, functional, but .. i guess i never really liked that it was web based, it felt slow and clunky and the aesthetics…

I've found DBeaver [1] to be a good replacement after giving up with pgAdmin3 (I did love pgAdmin2, however). Datagrip is also fine if you're a Jetbrains user. [1] https://dbeaver.io/

+1 for DataGrip. It's not perfect, but it's miles ahead of anything else I've used in the recent past.

Re: Why people care about PostGIS and Postgres

#12

Post by pelagicAustral »

systems wrote: post #4

It kinda always baffled me that MySQL always had better (free) GUIs (MySQL WorkBench) while what was in my opinion (and nowadays I think most others) didnt have any good ones There were always some commercial GUIs for PGSQL, but the free or opensource ones were very bad PgAdmin is very bad in my opinion, functional, but .. i guess i never really liked that it was web based, it felt slow and clunky and the aesthetics…

You are absolutely right. The current state of pgAdmin is enfuriating. I was forced to work with it recently, and I thought after all these years maybe something happened... oh dear, how wrong I was. That app is a full-rewrite away from production level.

I mainline DataGrip. It just works.

Re: Why people care about PostGIS and Postgres

#13

Post by epcoa »

systems wrote: post #4

It kinda always baffled me that MySQL always had better (free) GUIs (MySQL WorkBench) while what was in my opinion (and nowadays I think most others) didnt have any good ones There were always some commercial GUIs for PGSQL, but the free or opensource ones were very bad PgAdmin is very bad in my opinion, functional, but .. i guess i never really liked that it was web based, it felt slow and clunky and the aesthetics…

Pgadmin became web based only relatively recently. The old pgadmin was ugly but functional.

Re: Why people care about PostGIS and Postgres

#14

Post by whalesalad »

j45 wrote: post #8
whalesalad wrote: post #5

Earlier quoted context omitted.

postgres has some cool tools these days. postico if you are on macos or my personal fav lately has been https://www.beekeeperstudio.io/ which is also multi-db

Sequel Pro is the one I keep comparing all Postgres clients to. Beekeper is nice but lacks some of the GUI Tools, there's no point in having a nice GUI but not any good amount of functionality. At times I see folks new to Postgres using 2 or 3 different GUIs to do different things.

sequel pro (which afaik has not been updated since 1928?) could be compared with postico2 as far as native look and feel go - https://eggerapps.at/postico2/

never realized sequel pro was open source: https://github.com/sequelpro/sequelpro

Re: Why people care about PostGIS and Postgres

#15

Post by arvidkahl »

Love the episode and the guests, but let me point out just how good the hosted pages look at Transistor, the podcast hosting used here. I'm not affiliated, though I run my own shows there, too. The UI just vanishes into the background and puts the conversation right into the center. That's good SaaS :D

Re: Why people care about PostGIS and Postgres

#16

Post by pmontra »

JamesMcMinn wrote: post #6
systems wrote: post #4

It kinda always baffled me that MySQL always had better (free) GUIs (MySQL WorkBench) while what was in my opinion (and nowadays I think most others) didnt have any good ones There were always some commercial GUIs for PGSQL, but the free or opensource ones were very bad PgAdmin is very bad in my opinion, functional, but .. i guess i never really liked that it was web based, it felt slow and clunky and the aesthetics…

I've found DBeaver [1] to be a good replacement after giving up with pgAdmin3 (I did love pgAdmin2, however). Datagrip is also fine if you're a Jetbrains user. [1] https://dbeaver.io/

Agreed. I do recommend DBeaver to customers that want a GUI for PostgreSQL. It's better at almost everything and it handles ssh tunnels well. Even certificates.

I don't have any GUI client installed now. I ssh to servers and use psql there. I use psql locally and inside docker containers. I used pg-cli (?) years ago but I probably lost it during one of the various reinstalls (usually one for each Ubuntu LTS, I'm on Debian now) and I forgot about it.

Re: Why people care about PostGIS and Postgres

#17

Post by mooneater »

Because postgres and postgis are awesome!

I migrated to them in 2005 (from mysql) and was amazed by how much happier I was. And it never cost me a dollar.

I loved it so much I visited its authors in Victoria and bought consulting from them. They are amazing folks.

Re: Why people care about PostGIS and Postgres

#19

Post by mooneater »

arvidkahl wrote: post #15

Love the episode and the guests, but let me point out just how good the hosted pages look at Transistor, the podcast hosting used here. I'm not affiliated, though I run my own shows there, too. The UI just vanishes into the background and puts the conversation right into the center. That's good SaaS :D

Yeah I like transistor for my reinforcement learning show https://www.talkrl.com/ , their design has really improved

Re: Why people care about PostGIS and Postgres

#20

Post by antupis »

mooneater wrote: post #17

Because postgres and postgis are awesome! I migrated to them in 2005 (from mysql) and was amazed by how much happier I was. And it never cost me a dollar. I loved it so much I visited its authors in Victoria and bought consulting from them. They are amazing folks.

I would say postgres is python of databases, second best to everything.
Post reply on HN