A lack of replication support in Postgres was a key reason for people picking MySQL over Postgres until about 5 years ago. Since then, Postgres has come a long way with replication and here’s a look at how it all came together.

For single-node deployments Postgres is now a clear winner when it comes to document storage (versus MongoDB). This deep dive looks at how to take advantage of Postgres’ document storage, how to use indexes for optimization and also highlights cases where Postgres particularly excels.

AppDynamics' self-learning platform allows you to analyze actual database performance and detect anomalies automatically. It takes the guesswork out of defining optimal performance. Installs in Minutes. Start Free Monitoring

The first major update to the Postgres workload analyzer (PoWA) includes the ability to identify missing indexes your app would benefit from.

Hierarchical structures are common in apps but don’t lend themselves to simple representations in relational databases. Fortunately, Postgres has a few tools to make things a bit smoother for you.

A look at how JSON in Postgres can work well for you.

A provoking opinion piece. “Stored Procedures are not inherently bad – you’ve been told this because someone thinks you’re not capable of thinking for yourself.”

This older post is still very relevant if you’re running Postgres on your own hardware. The short version is that Postgres generally works well out of the box, but if you’re configuring your own system there are some useful things to pay attention to.

If you're passionate about food and building supply chain and warehouse management systems from the ground up, give us a look. Our team's at 16 developers and growing...quickly.