4 ms·
Why people care about PostGIS and Postgres
- rburhum 3y agoBecause Postgres+PostGIS is awesome
- deleted 3y ago[deleted]
- systems 3y agoIt 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
- whalesalad 3y agopostgres has some cool tools these days. postico if you are on macos or my personal fav lately has been https://www.beekeeperstudio.io/ https://www.beekeeperstudio.io/ which is also multi-db
- j45 3y agoSequel 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.
- whalesalad 3y agosequel 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/ https://eggerapps.at/postico2/ never realized sequel pro was open source: https://github.com/sequelpro/sequelpro https://github.com/sequelpro/sequelpro
- kawsper 3y agoSequel Pro have been abandoned and lacks support for some newer version of databases, and there is a maintained fork here: https://github.com/Sequel-Ace/Sequel-Ace https://github.com/Sequel-Ace/Sequel-Ace
- j45 3y agoThis is great to see. I hope this kind of client can be connected to Postgres one day.
- j45 3y agoYup, it’s crazy something unmaintained is still such a noticeably better experience than any of the Postgres clients I have seen. The note about sequel ace below is worth noting too for anyone wanting to try it out.
- andyonthewings 3y agoDBeaver 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.
- JamesMcMinn 3y agoI'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/ https://dbeaver.io/
- GiorgioG 3y ago+1 for DataGrip. It's not perfect, but it's miles ahead of anything else I've used in the recent past.
- tleilaxu 3y agoDatagrip’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.
- j45 3y agoBy chance has anyone who's used DataGrip also used Sequel Pro snd be able to comment?
- pmontra 3y agoAgreed. 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.
- j45 3y agoDBeaver is nice, but Sequel Pro is hard to unsee.
- laurensr 3y agoI 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 https://github.com/Wisser/Jailer
- userforcomment 3y agoBeeKeeper is good light alternative.
- pelagicAustral 3y agoYou 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.
- epcoa 3y agoPgadmin became web based only relatively recently. The old pgadmin was ugly but functional.
- joekrill 3y agoI actually prefer a web-based tool. I've been using pgweb - and I add it to my Docker Compose for development work so it provides a great, simple, lightweight way to interact with the database while working on a project. I'd definitely prefer something with a few more features, and have also been surprised there's not a lot of options. Desktop clients definitely have their use, but I like using a web-based tool that I can spin up alongside my project very easily with no config/setup.
- RicoElectrico 3y agoI 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.
- yetihehe 3y ago> The solution was to densify vertices of the square against which objects to be served were intersected. I remembered the easiest solution to query which lines with some width cross some bounding box (for putting them in quadtree). Just increase BB size by half a line width on each side and you have a very good approximation of a much harder and slower problem. A small percentage of lines will be returned and not drawn, but it's a good trade-off.
- arvidkahl 3y agoLove 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
- mooneater 3y agoYeah I like transistor for my reinforcement learning show https://www.talkrl.com/ https://www.talkrl.com/ , their design has really improved
- mooneater 3y agoBecause 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.
- antupis 3y agoI would say postgres is python of databases, second best to everything.
- j45 3y agoPostgres is a superior server to MySQL. It's clients are vastly inferior.
- sgarland 3y agoIt 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).
- ttfkam 3y agoThat isn't my experience at all. MySQL wins at serving a large number of very simple SELECT queries and plain bulk INSERTs. But Postgres wins hands down once the queries get slightly more complex, for larger numbers of concurrent UPDATEs, and kicks the pants off MySQL with a RETURNING clause where you don't have to perform a followup SELECT after each write, especially to get the new ID. (Necessary for writable CTEs and explains why MySQL doesn't support them.) And don't get me started on MySQL's lack of range types and their associated indexes. Exclusion constraints can be a godsend to data validity. MySQL has improved greatly since 8.x, but it's still very far behind the capabilities of Postgres, MS SQL Server, DB2, and Oracle. MySQL does simple things fast though not as fast as SQLite. It's getting squeezed on the high end by all the other big SQL vendors and squeezed on the low end by SQLite. It lives in a functionality gap that keeps getting narrower and narrower.
- martinky24 3y agoThis "transcript" format was so disappointing. Not at all intuitive or interesting to read.
- antm 3y agoTablePlus (https://tableplus.com/ 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.
- methou 3y agoLooked at pricing, whoa! That's a lot of money!
- richiebful1 3y ago$89 USD for a perpetual license for a GUI database management tool? That seems pretty cheap to me. We used to use Sql Server Management Studio with Red Gate SQL Prompt. That auto-completion / sql refactoring tool cost $200 a year per seat, and even that was worth it.
- folli 3y agoPostGIS is awesome! I use it quite extensively for the backend of my hobby project: https://cubetrek.com 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.