PostgreSQL
-
Software Development
Postgres indexes
Recently, I had a situation where I needed to think how I was using Postgres indexes. I had a simple…
Read More » -
Software Development
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 » -
Software Development
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 » -
DevOps
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
PostgreSQL’s Table-Valued Functions
Table-valued functions are an awesome thing. Many databases support them in one way or another and so does PostgreSQL. In…
Read More »