Databases
-
Software Development
DBMS vs RDBMS: Comparison and Differences between DBMS and RDBMS
The World is all about Data. Know more about DBMS and RDBMS…and what’s next. Data and Information Management is not…
Read More » -
Software Development
9 Of The Most Common Mistakes In Database Design
As a database designer, when you are tasked with a database project, you can expect to run into a couple…
Read More » -
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 »
