Databases
-
Software Development
Reactive Programming and Relational Databases
Imperative code eats threads at the pace of incoming requests while Software is eating the world. This post discusses the assumptions…
Read More » -
Software Development
How to Remove Leading/Trailing White Space from a String in SQL Server? LTRIM, RTRIM Example
Unlike Java, Microsoft SQL Server 2008, 2012, 2014, and even the latest version don’t have a built-in trim() function, which…
Read More » -
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 »
