Thoughts about Layered Architecture - Mapping Efficiently with SQL

Explore efficient data mapping techniques using SQL in layered architecture during this Spring I/O 2022 conference talk. Delve into the concept of decoupling application layers and creating reusable data access methods in enterprise contexts. Learn how to leverage Spring Data Projections to write less code and develop fast, easily maintainable software. Examine the pros and cons of layered architecture, discuss boilerplate code, and uncover a common JPA antipattern. Understand why "decoupled classes" don't necessarily mean "decoupled data" and discover how to optimize your approach by allowing the database to excel at data transformation. Gain insights into displaying album information, fetching specific data, and utilizing projections for efficient data retrieval. Consider the benefits and drawbacks of various mapping techniques, including the use of JOOQ. Reflect on the impact of these approaches on code complexity and performance, especially in large-scale applications with numerous data transformations.

Intro
KEEP THIS IN MIND
I SAW A RECURRING PATTERN!
DATA ACCESS
DATA TRANSFORMATION
WHAT I FOUND IN "THE ARCHIVES"
WHAT IS LAYERED ARCHITECTURE?
WHAT IS ENTERPRISE SOFTWARE?
WHAT IS LAYERING?
THIS IS HOW WE BUILD APPS
REMEMBER THIS?
IT IS OKAY TO SKIP LAYERS
SUMMARY: GOALS OF LAYERING
DISCLAIMER!
DISPLAYING ALBUM INFORMATION
HOW THE DATA IS STORED
LET'S ADD A FIELD TO "ALBUM"
WHAT DATA DO WE NEED?
DON'T FETCH EVERYTHING
WE DON'T KNOW!
BENEFITS AND DOWNSIDES THE BAD
MAPPING WITH SQL!
FETCH DATA WITH PROJECTIONS
CONVERSIONS IN THE DATABASE
OF COURSE JOOQ IS MENTIONED
REPO IN THE CONTROLLER
NON-REPRESENTATIVE METRICS
IMAGINE HAVING 200 OF THESE