PostgreSQL
-
Software Development
Setting PostgreSQL psql Variable Based Upon Query Result
When using PostgreSQL‘s psql command-line tool to interact with a PostgreSQL database via operator interaction or script, it is not…
Read More » -
Software Development
Procedure-Like Functions in PostgreSQL PL/pgSQL
PostgreSQL does not support stored procedures in the sense that a database such as Oracle does, but it does support…
Read More » -
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 »
