Category Archives: english

Snapshotting PostgreSQL databases with templates using Spring JDBC

Nowadays with the rise of more and more complex systems software testing is more important then ever. This not only includes unit testing but also integration-, end to end- and acceptance tests. For some of these test scenarios it is important to have a defined state of your database which could be reproduced in example […]
Also posted in coding, Java | Tagged , , , , , , | Leave a comment

Path environment variable at IntelliJ on macOS

Lately I encountered a problem with IntelliJ on macOS I wasn’t aware of so far. For a new project I joined it was necessary to let Java execute a shell script which resides in /usr/local/bin and calls another script. Putting all the questions for the reason behind this aside I was pretty puzzled when I […]
Also posted in Apple, coding, Java, macOS | Tagged , , , , , | Leave a comment

Automation via shell aliases

When working on software development projects there are many repetitive tasks to do, may it be the deployment of a binary, starting of different servers in docker containers or standalone, the exchange of config files for different environments, the migration of a database or something simple as the navigation to deep paths on the command […]
Also posted in howto, Linux, macOS, Tech | Tagged , , , , , | Leave a comment

Integrating Flyway with Java EE and using its datasource

Flyway is my favourite tool when it comes to database migrations because its convention over configuration approach makes it fairly easy to use while bootstrapping and configuration is reduced to a minimum. For those of you who don’t know anything about database migration tools (evolutionary database design) in short the concept is to track SQL scripts […]
Also posted in coding, howto, Java, Tech | Tagged , , , , , , | 5 Comments

Dynamic switching dev and prod datasource with maven profiles

Most of the time when you develop an application that uses a database you are likely to use another database for your local development work than what you will use later in production. The main reason for this is that there are databases like H2 which by design are fitting the development situation while they […]
Also posted in coding, Java | Tagged , , , , , , , , , | Comments closed