Chapter 10: Exporting, Batching, Bulking, and Loading

Manipulating large amounts of data requires serious skills (know-how and programming skills) in exporting, batching, bulking, and loading data. Each of these areas requires a significant amount of code and a lot of time to be implemented and tested against real datasets. Fortunately, jOOQ provides comprehensive APIs that cover all these operations and expose them in a fluent style, while hiding the implementation details. In this context, our agenda includes the following:

  • Exporting data in text, JSON, XML, CSV, charts, and INSERT statements
  • Batching INSERT, UPDATE, DELETE, MERGE, and Record
  • Bulking queries
  • Loading JSON, CSV, arrays, and Record

Let's get started!

Technical requirements ...

Get jOOQ Masterclass now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.