Postgres extensions are extremely powerful, and there’s an abundance of them out there. But if you’re looking to create one either for the broader community or your narrow use case there’s less tools to get started, here’s a great guide to getting started writing your own.
If you want to build a large scale website, you’ll need to cleverly manage the database side. A key to scalability with Postgres is locking, and Postgres now has some cool new features to reduce locking and speed things up via improved concurrency.
Your time is valuable, but a highly tuned and optimized DBMS is even more important. Learn practical, safe, and highly efficient ways to optimize the performance of a PostgreSQL Server with an on-demand training course.
Pub/Sub, or as it’s known in Postgres as Listen/Notify is awesome and powerful. Here’s a look at how to take advantage for one of the more popular PHP frameworks–Laravel.
Postico one of the better options for a GUI client for Postgres is now available directly in the Mac App store. If you’re looking for a client that’s something more than psql give it a look.
JSONB, often talked about by now, is very awesome for document storage in Postgres. Here’s a great talk running you through it and various techniques for interacting with it.
