Why people care about PostGIS and Postgres

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 were off

Now Azure Data Studio have a PG Plugin, I didnt try it yet, but I used Azure Data Studio for MS SQL, and I am starting to like it a lot, I do hope Azure Data Studio continue to support many more DBMSes and hope that it get more adoption and support for PGSQL and from the PGSQL community

EDIT

One more thing I want to mention, Azure Data Stuido, have a feature that currently only support MS SQL, its the database project

In a DB Project on ADS (Azure Data Studio), you work on your DB declaratively , i.e. you work on a SQL script that describe your table or other objects (A Create Statement) and the Poject tooling auto generation to alt and deployment scripts by comparing changes vs target , you can deploy directly from ADS or generate a dakpac to be executed as part of your CI/CD

Also since all you code is simple .sql file you can easily use source control

All other tools mentioned below have nothing that come close, not even DataGrip from Jetbrain

I do hope that MS will add support for other DBs to their Database Project feature in ADS, its an amazing feature, and the only way one should work on a DB

Re: Why people care about PostGIS and Postgres

#5

Post by whalesalad » Wed, Sep 13, 2023, 2:39 PM UTC

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…

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

Re: Why people care about PostGIS and Postgres

#6

Post by JamesMcMinn » Wed, Sep 13, 2023, 2:42 PM UTC

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/

Re: Why people care about PostGIS and Postgres

#7

Post by andyonthewings » Wed, Sep 13, 2023, 2:43 PM UTC

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…

DBeaver is an amazing gui. It works with Postgres, MySQL and many more.

MySQL WorkBench was always crashing on my Windows machine. That was some years ago so it may have improved.

Re: Why people care about PostGIS and Postgres

#8

Post by j45 » Wed, Sep 13, 2023, 2:43 PM UTC

whalesalad wrote: post #5

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…

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.

Re: Why people care about PostGIS and Postgres

#9

Post by userforcomment » Wed, Sep 13, 2023, 2:46 PM UTC

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…

BeeKeeper is good light alternative.

Re: Why people care about PostGIS and Postgres

#10

Post by RicoElectrico » Wed, Sep 13, 2023, 2:49 PM UTC

I helped some hotshot developer (who is clearly better Python programmer) debug an app which serves vector tiles. He insisted he wants to use MongoDB, because "he doesn't need to learn SQL". The app worked mostly fine except for low zoom levels in which some country outlines got chopped. The issue was that MongoDB only has spherical geometry as a first-class citizen. If you make a query against a 4-vertex bounding box, then on low zoom there's a discrepancy between querying on a sphere vs querying on WGS84 or Mercator. The solution was to densify vertices of the square against which objects to be served were intersected.