Databases
-
Software Development
SPOOLing Queries with Results in psql
SQL*Plus, the Oracle database‘s command-line tool, provides the SPOOL command to “store query results in a file.” The next screen…
Read More » -
Software Development
SQL for Application Developers
“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level…
Read More » -
Software Development
Agile Databases
Any project following an Agile methodology will usually find itself releasing to production at least 15 – 20 times per…
Read More » -
Software Development
Solving Problems with the Right Technology: Hadoop and RDBMS
In some circles today there is a sort of ‘Hadoop vs. RDBMS’ debate ongoing. Often the discussion casts Hadoop as…
Read More » -
Software Development
A tale of troubleshooting database performance, with Cassandra and sysdig
Gianluca Bordello is an engineering manager at Sysdig, where he wears many hats. He’s a core developer of sysdig, an…
Read More » -
Enterprise Java
Using Oracle AQ via Java 8 Streams
One of the most awesome features of the Oracle database is Oracle AQ: Oracle Database Advanced Queuing. The AQ API…
Read More » -
Scala
Reactive Database Access – Part 3 – Using jOOQ with Scala, Futures and Actors
We’re very happy to continue our a guest post series on the jOOQ blog by Manuel Bernhardt. In this blog…
Read More » -
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 »
