Postgres can provide great queue-like functionality for your application but sometimes the locking mechanisms required can create pain on production load systems.
Every time a query is run, Postgres forms a ‘plan’ of how it will execute it. You can look at this plan with EXPLAIN - here’s a post that provides an overview of its use.
A New Gartner report predicts open source databases will overtake proprietary solutions. By 2018, 70% of new apps will be deployed on OS databases with Postgres playing a huge role. Download the report. (Registration Required.)
Postgres 9.5 is coming and the final set of features are making their way in. Here’s the rundown of improvements to JSONB with a new awesome operator to concatenate two JSONB values.
Last week we looked at how ‘upsert’ functionality was finally landing in Postgres (in 9.5). This article takes another look at how it will work with an in-depth dive.
Visualizing your data model can often provide some clarity as to how you’re interacting with it. ERAlchemy is a tool that makes generating Entity Relation Diagrams simple and easy.
