Accessing Relational Databases with Quarkus

Map and query your entities from relational databases using JPA and Panache ORM

Created by: Antonio Goncalves
Developer, book author, international speaker, Quarkus lover

What Will I Learn?

• Understand the persistence ecosystem and how Quarkus supports it
• Bootstrap three data-centric applications with Quarkus
• Develop, configure and test each application separately using JDBC, JPA, Panache ORM, JUnit and RestAssured
• Persist objects into MySQL, MariaDB, H2 and PostgresSQL databases
• Use JPA to map persistent objects (columns, tables, inheritance, relationships)
• Use JPQL and Simplified Panache QL to query persistent objects
• Use JAX-RS and JSON-B to expose data through REST endpoints
• Use Qute templates to visualise data in HTML
• Beautify the Qute templates with Twitter Bootstrap
• Use Docker through TestContainers and DevServices to test the application
• Build and execute the application using several Quarkus profiles

Requirements

• A recent Windows / Mac / Linux machine
• Knowledge of the Java language and the Java ecosystem (Maven, JUnit)
• Basic knowledge of Quarkus
• Basic knowledge of relational databases (SQL)
• Basic knowledge of RESTful Web Services
• Basic knowledge of HTML and CSS
• Basic knowledge of Docker

Target audience

• Java developers who know Quarkus
• Quarkus developers curious about relational databases
• Back-end Java developers willing to access data in an object way
• Spring Boot or Micronaut developers wanting to compare their toolkit with Quarkus