Home » Tag Archives: Databases

Tag Archives: Databases

AutoCommit in PostgreSQL’s psql

postgresql-logo

One potential surprise for someone familiar with Oracle database‘s SQL*Plus when being introduced to PostgreSQL database‘s psql may be psql‘s default enabling of autocommit. This post provides an overview of psql’s handling of autocommit and some related nuances. By default, Oracle’s SQL*Plus command-line tool does not automatically commit DML statements and the operator must explicitly commit these statements as part ...

Read More »

SPOOLing Queries with Results in psql

software-development-2-logo

SQL*Plus, the Oracle database‘s command-line tool, provides the SPOOL command to “store query results in a file.” The next screen snapshot shows SPOOL used in SQL*Plus to spool the listing of user tables to a file called C:\pdf\output.txt.                 Both the executed query and the results of the query have been spooled to ...

Read More »

SQL for Application Developers

software-development-2-logo

“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level removed from SQL. JPA and the Entity Framework each provide more abstract (and OO-friendly) query languages, and it’s often unnecessary to write any queries at all. If you ever diagnose production support issues, though, being proficient with SQL can greatly ...

Read More »

Agile Databases

software-development-2-logo

Any project following an Agile methodology will usually find itself releasing to production at least 15 – 20 times per year. Even if only half of these releases involve database changes, that’s 10 changes to production databases so you need a good lean process to ensure you get a good paper trail but at the same time you don’t want ...

Read More »

Solving Problems with the Right Technology: Hadoop and RDBMS

apache-hadoop-logo

In some circles today there is a sort of ‘Hadoop vs. RDBMS’ debate ongoing. Often the discussion casts Hadoop as the obvious heir apparent in the data processing world, with RDBMS cast as your father’s Oldsmobile. This debate is somewhat misdirected and the discussion could lead organizations away from the strategy they really should be following, namely a strategy of ...

Read More »

A tale of troubleshooting database performance, with Cassandra and sysdig

apache-cassandra-logo

Gianluca Bordello is an engineering manager at Sysdig, where he wears many hats. He’s a core developer of sysdig, an open source troubleshooting tool for Linux and containers, and spends his days dealing with backend development, performance analysis and cloud infrastructure management. Introduction As far as databases go, I’m a  huge fan of Cassandra: it’s an incredibly powerful and flexible ...

Read More »

Using Oracle AQ via Java 8 Streams

java-interview-questions-answers

One of the most awesome features of the Oracle database is Oracle AQ: Oracle Database Advanced Queuing. The AQ API implements a full fledged, transactional messaging system directly in the database. In a classic architecture where the database is at the center of your system, with multiple applications (some of which written in Java, others written in Perl or PL/SQL, ...

Read More »

Reactive Database Access – Part 3 – Using jOOQ with Scala, Futures and Actors

scala-logo

We’re very happy to continue our a guest post series on the jOOQ blog by Manuel Bernhardt. In this blog series, Manuel will explain the motivation behind so-called reactive technologies and after introducing the concepts of Futures and Actors use them in order to access a relational database in combination with jOOQ. Manuel Bernhardt is an independent software consultant with ...

Read More »

Using the JDBC Insert Features in Oracle

java-interview-questions-answers

Introduction In this article I will show an example of how to use the JDBC bulk insert features supported by Oracle — and which are specific to Oracle. For more details on why one might like to resort to using bulk inserts in general, e.g., performance considerations when certain circumstances warrant, see the JCG article, “JDBC Batch Insert Example ” ...

Read More »

Want to take your Java skills to the next level?

Grab our programming books for FREE!

Here are some of the eBooks you will get:

  • Spring Interview QnA
  • Multithreading & Concurrency QnA
  • JPA Minibook
  • JVM Troubleshooting Guide
  • Advanced Java
  • Java Interview QnA
  • Java Design Patterns