PostgreSQL
-
Scala
Listen to notifications from Postgresql with Scala
In the past I’ve written a couple of articles (Building a REST service in Scala with Akka HTTP, Akka Streams…
Read More » -
Software Development
Downsides of Mixed Identifiers When Porting Between Oracle and PostgreSQL Databases
Both the Oracle database and the PostgreSQL database use the presence or absence of double quotes to indicate case sensitive…
Read More » -
Software Development
Passing Arrays to a PostgreSQL PL/pgSQL Function
It can be handy to pass a collection of strings to a PL/pgSQL stored function via a PostgreSQL array. This…
Read More » -
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 »
