Here’s part one of the series of using Postgres as a document store. In short, it works, but could use a bit of usability tuning. Fortunately much of this is coming but it’s still quite workable today - take a look at how.

Window functions are extremely powerful and you can do many things with them. One very common capability is computing month over month growth without having to break out a scripting language or Excel.

A CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster.

Bruce Momjian teaches the popular course Comprehensive PostgreSQL Administration again in September, covering foundational and advanced topics needed for success. Join Bruce and learn from his tips in this live on-line session. 20% off promo code COMB-WEB-01.

Here’s an incredibly handy tool for importing CSV and JSON data directly into PostgreSQL.

Should a SQL injection vulnerability occur in your application it could be a huge disaster, here’s a newer approach for helping prevent such by analyzing every query and alerting on unknown queries against your system.

Row Level Security (RLS) allows the contents of a table to be filtered before being returned to the user.

A look at searching documents stored in Postgres. It can be extremely performant thanks to JSONB and a combination of indexing and full text search.

Meteor now has a preview version of Postgres support available.

PgBouncer is still the best solution for connection pooling with Postgres in your application. With the newest release from just a few weeks ago there’s a number of improvements that make it even more usable.