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.

Encrypt Device With Veracrypt From the Command Line

You have a drive that you want to encrypt and use in Linux and other OSes. Then Veracrypt, the successor of Truecrypt, is a good choice. In this tutorial, I will show you how to quickly encrypt a drive and mount and unmount it from the command line.

Make Less Options Permanent or the Missing Lessrc

Let’s have a look at how we can make certain less preferences permanent, like -I, for example, which will make search case insensitive.

Make a Backup With Rsync

We want to make a backup of data, for example to an external hard drive. Rsync to the rescue.