How to export ~3 million PostgreSQL records to PDF in Spring Boot and provide downloadable link via notification?
I need to export approximately 3 million rows from a PostgreSQL table using a Spring Boot REST API, and instead of returning the file directly in the response, I want to:
Generate a PDF file containing the exported data
Store the file (locally or cloud like S3)
Send a notification with a download link
When the user clicks the link, the PDF should open/download