Consider using JSON arrays instead of objects to transfer data in order to avoid overhead on client, server, and the data itself.

jOOQ is a Java library that provides a fluent API for building type-safe SQL queries and interacting with relational databases. With jOOQ, developers can write SQL queries in Java code, leveraging compile-time type checking and code generation to ensure correctness and maintainability. Developers can learn how to use jOOQ to simplify database interactions, reduce SQL boilerplate, and enhance productivity when working with SQL databases in Java applications.

JOOQ

JSON arrays can provide 15-25% performance improvements over JSON objects for data serialization by enabling positional access instead of key-based lookups. While JSON objects offer better readability and debugging, arrays reduce overhead in both CPU processing and data transfer. The approach works particularly well in controlled environments where the client knows the exact structure and position of data fields, such as jOOQ's MULTISET operator implementation using SQL/JSON.

Consider using JSON arrays instead of objects to transfer data

<p>When REST - it breaks the best practices - also on the HTTP level there is ZSTD/BROTLI etc… Why bother? If using  xRPC - it’s already using kind of efficent serialization… Why bother?</p>
