Last week I was granted the task of creating a relational database for a web application. Being more familiar with non-relational databases like MongoDB, I was a bit intimidated by the task. However, with the help of the Postico client, created by the team at Egger Apps, over the extremely powerful PostGreSQL database, I was able to format my database within MINUTES.

Postico makes using PostgreSQL a breeze.

Postico provides an extremely Mac friendly interface. This is tailored for an experience that is beneficial for newcomers and relational theorist alike. It's as simple as a connecting to database to being working with tables and views. Once you familiar yourself with the structure and content of your tables, constructing advanced tables and design logic could not be easier.

None

Get a live analysis of the content of your database.

The killer feature for me is being able to get a live look at the contents of your database without having to use a command line or advanced queries. You can create, read, update, and destroy data from Postico. The GUI also grants the ability to view images and extremely long within the the app. You can view related rows from referenced tables. Postico allows you to filter rows, sort them, rearrange columns. You can even change multiple rows at once. Batch saving (with SQL preview) lets you commit changes to multiple rows in a single transaction.

None

Query, Enquire, Investigate.

PostGreSQL offers many tools for robust data analysis like recursive queries, filter aggregates, common table expressions, and window functions. Postico flexes an extremely powerful query view that supports multiple result sets. The editor has all the standard features you expect, like syntax highlighting and automatic indentation.

Conclusion

Download Postico for your Mac if you need to exploit the true power of PostGreSQL. I can see my self using this application for all of my database needs. You shouldn't have to have a degree in relational theory to be able to harness the capabilities of one of the most powerful databases accessible..