If you’ve ever run a query only to wait and realize you’re slowly bringing your database to a halt because of what’s happening under the covers, this may help. This module prevents certain queries from running if their query plans meet certain criteria.

GraphQL is a data querying language designed to describe the complex, nested data dependencies of modern applications. Essentially, a graph interface to relational data.

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

If for some reason you’re not yet on Postgres 9.4 and therefore able to take advantage of JSONB, there are still some great flexible data options available. The array and hstore datatypes, in particular, can give you some flexibility in your schema.

If you haven’t gotten to play with the new JSONB (in case your wondering B is for ‘better’… ;-)) in Postgres, here’s a look at some of the basics. Learn how to search for certain keys, interact with text within the object, and more.

Ever needed an intermediary when trying to manipulate in some form or another? This quick example from Honeybadger shows how they use temporary tables to make the process a bit smoother.

A few weeks back Rob had a post about how to do auth well with Postgres, but now he’s followed it up with an actual working example in Node.

A great Capistrano tool for fast and sophisticated remote database import using the best of Postgres 9.2.x

Are you or someone you know looking to find a good resource for learning SQL? Here’s a great walkthrough of the basics.

DevOps-Kollegen mit Gespür für modernste Technologien und Spaß an der Optimierung von Workflows und Prozessen für unser zentrales Ops-Team in einem Kanban-getriebenen Umfeld gesucht! Bewerbung gerne an gundula.pabst@kaufhof.de