Postico 4+

I was using PGAdmin on my Mac and dealing with constant usability issues.

With PGAdmin I would have windows randomly resizing on me while trying to administer my local dev environment.

I switched to Postico and everything works great! The software’s UI is not only stable but much more responsive than PGAdmin ever was. I have been a happy user for quite some time but just got around to reviewing it. I wish there was a free version for developers to give it a try with a paid upgrade inside of the app for the full release. That would give me the ability to promote it more to others.

I used postgres via homebrew and postico to automate a linux to windows server migration. A nearly identical project was 24 man years into an estimated 36 man year project using manual data corrilation.

My project was in 2016. II am sure that Postico has only gotten better. As I was using it for the project, there were several updates that improved it for my project.

Being able so sort my data on various columns in the result window without re-running the queries greatly sped up my work. My record barely fit on 3 monitors side by side. The postico features made my project viable, so I only needed to pull the results into excel when sending reports to management.

Finding intersections of keywords in arrays (records can contain arrays), a postgres feature, was instrumental in my solution.

This is one of the best DB GUIs I've used. I'm comfortable with raw SQL, but I like a lightweight GUI for navigating the data and making quick changes.

This tool makes it seemless and natural to view/edit your data as well as jump into SQL mode to run raw queries.