Maven's Versions Plugin Updates All Your Dependencies With a Single Command

It’s a good habit to use the latest versions of the dependencies you use. Not only because the updated version might contain new features or better performance (one can hope), but also because bugs are fixed and security issues are tackled. If you go about it by hand, however, updating dependencies is a boring and tedious task. Luckily for us, there is the Maven versions plugin to help us.

Oracle Sqlplus in a Small Docker Container

When you only need Sql*Plus, it’s good to have a small Docker image that you can use. This post will look at how to create this Docker image.

Automatic Rollback of Transactions in Spring Tests

Put @Transactional on your test class or methods and test-managed transactions will automatically be rollbacked.

SQL Injection in Bash Scripts

Problem

When working on making a small application with a Zenity GUI, I ask the user for input. I need to somehow sanitize this input, or I will leave the gates wide open for two problems:

1. SQL injection.
2. Command injection.

In this blog post, I’m going to look at a solution for the first problem.

Skipping or Selectively Running Tests With Maven

You might not always want to execute all tests. Sometimes you only want to run a single unit test, or only integrations tests that start with Foo. Let’s look at how to make this happen in Maven.

Grokking Time Zones in Oracle's DATE and TIMESTAMP

This post talks a little bit about DATE and TIMESTAMP in Oracle and some of their pitfalls. TL;DR: Representing dates and timestamps correctly is a very hard problem (required viewing).

Oracle Sqlplus Cheat Sheet

In this post, I’m going to aggregate all those Oracle commands that I can never remember but are very useful to have somewhere written down.

Mariadb/Mysql Password Exposure in Bash

How can we securely provide a password to mysql without exposing it to the world by just putting it directly in the command?

Whats the Difference Between a Login and a Non-Login Shell?

I always kind of knew there was a difference between login and non-login shells, but when I couldn’t explain the difference properly to a coworker, I knew I needed to spend some time on figuring it out.