Postgres is great at storing and retrieving data, including JSON these days. But what if you need to find a specific value in JSON then manipulate it? That takes a little more effort, but as highlighted here can be easily done with a little PLV8.
PG Bouncer, the best connection pooling application for Postgres, has a new home along with a release that contains some great updates. A good excuse to update your version or check it out if you’ve not yet.
Discover a collaborative and entirely browser-based environment for your team's queries and data-driven insights. JackDB adds a security layer to your organization's entire data infrastructure. Try it for free.
Pakyow, a framework in Ruby that’s focused on view-first development, plays well with many databases, but most importantly Postgres. Here’s a look at plugging in Postgres via Sequel (one of the best Ruby ORMs).
A big part of the performance improvements over time come from reducing when and how long locks are held for on certain operations. Take a look at this recently landed feature to no longer hold locks when running an alter table for triggers.