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!