Unleash the power of storing JSON in Postgres

An article by Sarah Mei titled “Why you should never use MongoDB” discusses the issues you’ll run into if you…

Read More »

Postgres indexes

Recently, I had a situation where I needed to think how I was using Postgres indexes. I had a simple…

Read More »

Discovering the Computer Science Behind Postgres Indexes

This is the last in a series of Postgres posts that Pat Shaughnessy wrote based on his presentation at the…

Read More »

Following a Select Statement Through Postgres Internals

This is the third in a series of Postgres posts that Pat Shaughnessy wrote based on his presentation at the…

Read More »

Heroku PostgreSQL vs. Amazon RDS for PostgreSQL

PostgreSQL is becoming the relational database of choice for web development for a whole host of good reasons. That means…

Read More »

PostgreSQL’s Best-Kept Secret, and how to Use it with jOOQ

PostgreSQL has a lot of secret data types. In recent times, PostgreSQL’s JSON and JSONB support was hyped as being…

Read More »

The Awesome PostgreSQL 9.4 / SQL:2003 FILTER Clause for Aggregate Functions

Sometimes when aggregating data with SQL, we’d love to add some additional filters. For instance, consider the following world bank…

Read More »

Adding OpenSSL User-Defined Types to PostgreSQL

PostgreSQL supports user-defined types (UDT). These types can be used to provide type-safety on user-defined functions when we would otherwise…

Read More »

Integrating jOOQ with PostgreSQL: Partitioning

Introduction jOOQ is a great framework when you want to work with SQL in Java without having too much ORM…

Read More »