Spring Boot Rest API with Jdbi 3

Welcome to another Spring Boot tutorial.

In this story, we’ll implement a sample REST API that uses Spring Boot with Jbdi 3 and PostgreSQL.

Prerequisites

This is the list of all the prerequisites for following this story:

• Spring Boot 2.6.5
• Maven 3.6.3
• Java 17
• PostgreSQL
• Postman

Overview

What is Jdbi3?

Jdbi is an open-source Java library (Apache license) that uses lambda expressions and reflection to provide a friendlier, higher-level interface than JDBC to access the database. Jdbi 3 is the third major release which introduces enhanced support for Java 8, countless refinements to the design and implementation, and enhanced support for modular plugins.

Why Jdbi3 ?

• It is open source
• Offers full control of the queries
• It can be combined with connection pools and high-availability features in the database drivers.
• It can invoke a database stored procedure.

Getting Started