Oracle LONG and LONG RAW Causing “Stream has already been closed” Exception

Like many old databases, Oracle has legacy data types, which are rather nasty to work with in every day SQL.…

Read More »

Using the JDBC Insert Features in Oracle

Introduction In this article I will show an example of how to use the JDBC bulk insert features supported by…

Read More »

Safe Database Migration Pattern Without Downtime

I’ve been doing a continuous delivery talk for a while now and during my talk I describe a pattern of…

Read More »

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 »

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 »

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 »

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 »

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 »

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 »