This blog is a platform for me to share my knowledge in the area of software development.
In this blog, you will learn how to fetch data from tables with jOOQ which have a one-to-one, a one-to-many or a many-to-many relationship. Enjoy!
Continue reading “Fetching Data From One-to-One, One-to-Many, and Many-to-Many Relationships With jOOQ”
In this blog, you will learn how to get started with jOOQ, Liquibase and Testcontainers. You will create a basic Spring Boot application and integrate the aforementioned techniques including a test setup. Furthermore, you will use Spring Boot Docker Compose support to run the application in no time. Enjoy!
Continue reading “Integrate Spring Boot with jOOQ, Liquibase and Testcontainers”
In this blog, you will learn how to backup and restore a PostgreSQL database. Enjoy!
Continue reading “How to Backup and Restore a PostgreSQL Database”
In this post, we will take a look at how we can use Testcontainers for our integration tests. Testcontainers will allow us to write integration tests making use of containerized databases, message queues, web browsers, etc. without a dependency on a local installation.
Continue reading “Easy Integration Testing With Testcontainers”
In this post, we take a look at how we can easily manage our database migration scripts by means of Liquibase. Liquibase will automatically execute necessary database migration scripts during application startup. We will explore some of the features of Liquibase by means of a simple Spring Boot application in combination with a PostgreSQL database.
In this post, we will take a look at how we can use Google Cloud Platform (GCP) SQL as a database for our Spring Boot application. We will investigate how we can use the Cloud database from our development machine and how we can use it from GCP itself.