Databases
-
Enterprise Java
PostgreSQL on Open Liberty
Open Liberty is an interesting new OSS Java EE application server that originated from WebSphere Liberty. You can configure Open…
Read More » -
Enterprise Java
Database testing with TestContainers
If you have ever written code that tests database interactions, such as data access objects, you very possibly have run…
Read More » -
Software Development
Tuning PostgreSQL with pgbench
When it comes to performance tuning an environment, often the first place to start is with the database. The reason…
Read More » -
Enterprise Java
Work with Parallel Database Streams using Custom Thread Pools
Parallel Database Streams In my previous post, I wrote about processing database content in parallel using parallel streams and Speedment. Parallel…
Read More » -
Software Development
Using Named Database Locks
In a beginner’s guide to concurrency, I mentioned advisory locks. These are not the usual table locks – they are…
Read More » -
Enterprise Java
How To: Insert and Read From a Database using Json
In this article we will create a plugin for Speedment that generates serialization and deserialization logic using Gson to make…
Read More » -
Software Development
AutoCommit in PostgreSQL’s psql
One potential surprise for someone familiar with Oracle database‘s SQL*Plus when being introduced to PostgreSQL database‘s psql may be psql‘s…
Read More » -
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 »