PostgreSQL
-
Software Development
AutoCommit in PostgreSQL’s psql
One potential surprise for someone familiar with Oracle database‘s SQL*Plus when being introduced to PostgreSQL database‘s psql may be psql‘s…
Read More » -
Software Development
Does PostgreSQL Have an ORA-01795-like Limit?
The Oracle database requires that no more than 1000 entries be used in a SQL IN portion of a WHERE…
Read More » -
Software Development
NoSQL vs. SQL: Choosing a Data Management Solution
Table Of Contents 1. Introduction 2. Distributed systems: the CAP theorem 3. Relational data stores 3.1. MySQL / MariaDB 3.2.…
Read More » -
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 »
