TablePlus (https://tableplus.com/) is my current goto - even has a nice iOS app for on the run queries. I have fond memories of Sequel Pro and this app scratches that itch.
Why people care about PostGIS and Postgres
21–30 of 42 posts
Re: Why people care about PostGIS and Postgres
#22Earlier quoted context omitted.
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.
Datagrip’s main selling point for me is that it’s a familiar UI over most databases one uses day to day.
I hop into the native apps for more complex, database specific features (GIS etc) but generally it’s perfect.
Re: Why people care about PostGIS and Postgres
#23It 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/
DBeaver is nice, but Sequel Pro is hard to unsee.
Re: Why people care about PostGIS and Postgres
#24Earlier quoted context omitted.
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.
By chance has anyone who's used DataGrip also used Sequel Pro snd be able to comment?
Re: Why people care about PostGIS and Postgres
#25Because 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.
Postgres is a superior server to MySQL. It's clients are vastly inferior.
Re: Why people care about PostGIS and Postgres
#26PostGIS is awesome! I use it quite extensively for the backend of my hobby project: https://cubetrek.com
It's basically a Strava-like webapp to manage activity data for running, hiking, biking etc.
PostGIS makes it very easy to query tracks in a given bounding box, get matching activities to compare past performances on the same tracks etc. Also the GeoJSON conversion is very handy to integrate it with MapLibre GL JS on the front end.
Re: Why people care about PostGIS and Postgres
#27It 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/
I also found DBeaver to be a huge improvement over tools I used earlier.
Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer
Re: Why people care about PostGIS and Postgres
#28TablePlus ( https://tableplus.com/ ) is my current goto - even has a nice iOS app for on the run queries. I have fond memories of Sequel Pro and this app scratches that itch.
Looked at pricing, whoa! That's a lot of money!
Re: Why people care about PostGIS and Postgres
#29Because 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.
Postgres is the absolute best you will get for diverse relational data with strict consistency needs and not a huge amount of data of each type (AKA, what databases were created for).
It's second best (or third) for the stuff that historically made people abandon relational databases. But it's absolutely the best choice for its core functionality.
(But well, Python is the best system scripting language around. So the phrase was always an exaggeration.)
Re: Why people care about PostGIS and Postgres
#30Earlier quoted context omitted.
I would say postgres is python of databases, second best to everything.
Postgres is a superior server to MySQL. It's clients are vastly inferior.
It depends on your needs. For example, with a write-heavy workload, MySQL will generally outperform Postgres, assuming you’re using it as intended (e.g. don’t use UUIDv4 or other random values as a PK).