Working with databases

To be able to progress further with our tests, we need the ability to create entities in the database. For that, we’ll need to connect to the database.

First, let’s add the following two lines to our build.gradle.kts dependencies section:

dependencies {
    ...
    implementation("org.postgresql:postgresql:42.5.1")
    implementation("io.vertx:vertx-pg-client")
    implementation("com.ongres.scram:client:2.1")
}

The first line introduces the PostgreSQL driver into our project, a necessary component for interfacing with PostgreSQL databases. The second line adds the Vert.x JDBC client, enabling Vert.x to interface with any JDBC-supported database using this driver. The third line integrates the SCRAM authentication mechanism, a security feature often used in modern PostgreSQL setups, ensuring secure database access.

Now, we want to hold the database configuration somewhere. For local development, it...