Databases
-
Software Development
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 » -
Enterprise Java
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 » -
Software Development
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 » -
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
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 »
