# JSON array

Published articles for JSON array.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Consider using JSON arrays instead of JSON objects for serialisation

DevFeed: [Consider using JSON arrays instead of JSON objects for serialisation](<https://devfeed.tech/articles/consider-using-json-arrays-instead-of-json-objects-for-serialisation-28935.md>)

Original publisher: [Read original article](<https://blog.jooq.org/consider-using-json-arrays-instead-of-json-objects-for-serialisation/>)

Author: lukaseder

Published: 2025-08-11T12:43:10Z

Content type: opinion

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [JSON](<https://devfeed.tech/topics/json.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [compression](<https://devfeed.tech/tags/compression.md>), [java](<https://devfeed.tech/tags/java.md>), [jooq](<https://devfeed.tech/tags/jooq.md>), [json](<https://devfeed.tech/tags/json.md>), [json-array](<https://devfeed.tech/tags/json-array.md>), [json-object](<https://devfeed.tech/tags/json-object.md>), [overhead](<https://devfeed.tech/tags/overhead.md>), [performance](<https://devfeed.tech/tags/performance.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-json](<https://devfeed.tech/tags/sql-json.md>)

### AI overview

The article explains why jOOQ serialises some internal result data as JSON arrays of arrays instead of JSON objects. Positional access can be faster and avoids problems caused by duplicate column names, but the choice is a tradeoff and depends on whether people need to inspect the JSON or consume the API.

### Source excerpt

When implementing the awesome MULTISET operator in jOOQ, its implementation mostly relied on SQL/JSON support of various RDBMS. In short, while standard SQL supports nested collections via ARRAY or MULTISET operators like this: This is poorly supported in most RDBMS, so jOOQ emulates it using SQL/JSON as follows (or similar): Wait a second. A JSON ... Continue reading Consider using JSON arrays instead of JSON objects for serialisation ->