Databases
-
Software Development
A beginner’s guide to read and write skew phenomena
Introduction In my article about ACID and database transactions, I introduced the three phenomena described by the SQL standard: dirty…
Read More » -
Software Development
How to Quickly Enumerate Indexes in Oracle 11gR2
Do you want to know real quick what kind of indexes there are on any given table in your Oracle…
Read More » -
Software Development
Single Quotes in Oracle Database Index Column Specification
In my previous post, I mentioned that a downside of using double quotes to explicitly specify case in Oracle identifiers…
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
Benchmarking Aurora vs MySQL: Is Amazon’s New DB Really 5x Faster?
Amazon Aurora: The next generation of hosted database services put to the test In this post we’re taking a closer…
Read More » -
Software Development
jOOQ Tuesdays: Thomas Muller Unveils How HSQLDB Evolved into the Popular H2 Database
Welcome to the jOOQ Tuesdays series. In this series, we’ll publish an article on the third Tuesday every other month…
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 » -
Software Development
Mysql versions prior to 5.7 do not fully support two phase commit
While doing some tests for the recently released generic JCA adapter which is capable of binding remote calls to microservices…
Read More »