PostgreSQL
-
Enterprise Java
Installing PostgreSQL PL/Java as a PostgreSQL Extension
In 2011 I wrote a series of articles on PostgreSQL PL/Java. The basic information is still solid but there is…
Read More » -
Software Development
Extending PostgreSQL: Complex Number Data Type
A few years ago I discussed creating user-defined types using PL/java. (Introduction to PostgreSQL PL/Java, part 4: User Defined Types)…
Read More » -
Software Development
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 » -
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 »