When I started working on Postico, the other PostgreSQL client apps all had a really dated Windows 95 / Java UI style, with hundreds of toolbar icons, assistants for everything, and lots of modal dialogs. They were such a kludge that many people just used psql on the command line instead.

I wanted to make a modern database app for PostgreSQL, like Sequel Pro or Base. I also took a lot of inspiration from other modern Mac apps, like Transmit from Panic, or all the Omni Group apps.

One of the features that best showcases what I consider "modern" is the table structure editor, where I spent a lot time on the interaction design. I'm pretty proud of how it turned out (even though there are issues with it and I never finished all the features I would like to have in there).

In the last 10 years, a few other "modern" database apps for PostgreSQL have been developed, like PSequel, SQLPro Studio, and as other people have commented here, Table Plus, so Postico is probably no longer unique in trying to be modern.

At some level, Postico is even starting to look a bit dated, since I haven't been keen on the direction Apple has been going in the last few years. So maybe it's not entirely accurate to call Postico modern any more, but I do keep looking at what other Mac apps are doing, and what Apple is doing with their apps, and use that as a guiding post to keep Postico a "modern" app that feels at home on the Mac.

Thanks so much for your work on Postico. I had been using Sequel Pro working with MySQL and was looking for something as good, when i switched to a company that uses Postgres. Postico has fit that bill entirely and then some, and has been one of the few tools i've been wiling to pay money for, along with Sublime Text.

I suggest using more descriptive words than 'modern'. Simple, uncluttered, native, and interactive seem like better words to describe the effort you've put into the application.

On the Postico 2 website I do use the word "native" to describe the app.

Some parts of the UI in Table Plus have been inspired by Postico, which is probably why it looks similar at a first glance. But the apps are different, and they have a very different focus. As far as I can tell Table Plus tries be the best client for everybody (every platform + every databases), while Postico tries to be the best client just for PostgreSQL on the Mac.

As the developer of Postico I'm probably biased, and I'm not really up to date where Table Plus is right now, so take my thoughts with a grain of salt. You probably have to try both to see which of the two clicks with you.

Thanks for your work on Postico. Was looking for a Mac based GUI when I made the switch from MySQL to Postgresql almost 10 years ago. Sequel Pro was my go to interface for understanding my database tables in MySQL and I wanted something similar for Postgresql. I bought a license years ago and it is part of my daily workflow. Didn't know about v2, will have to check that out!

It feels weird to say but postico is what finally convinced me use postgres as my main db almost a decade ago.

The tools are the face of the database and while I didn’t love MySQL, sequel pro made working with it really nice.

And all the postgres guis at the time were really ugly.

When Postico came around I could finally have a smooth experience running queries and I’ve never looked back.

Now if redgate added PG support to sql data compare I’d be in Heaven.

Thanks so much for your work on Postico. I use it every day and recommend it highly. It’s fast, stable, and a Mac app through and through (increasingly a rarity).

Hey I bought a license for postico recently because I used it for six months everyday. Love it, all the best. Thanks

I've been using Postico for years and love it.

The only feature I miss is some sort of schema designer.

Postico is fantastic, thanks for all your work. Also Table Tool is very useful.

It's feature complete, and a few thousand people are already using it. It's probably the better choice for most users. But there are still a few issues with the file editor that I want to fix before I officially release it, because I have a lot of corporate users who presumably prefer to have fewer features but more stability.