PostgreSQL
-
Enterprise Java
PostgreSQL on Open Liberty
Open Liberty is an interesting new OSS Java EE application server that originated from WebSphere Liberty. You can configure Open…
Read More » -
Software Development
Tuning PostgreSQL with pgbench
When it comes to performance tuning an environment, often the first place to start is with the database. The reason…
Read More » -
Software Development
More on Spooling Queries and Results in psql
In the recent blog post SPOOLing Queries with Results in psql, I looked briefly at some PostgreSQL database psql meta-commands…
Read More » -
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 »
