How to Model JSON Data in a Go App With CockroachDB

This article discusses how to model JSON data in a Go application using CockroachDB. It explains that many applications benefit from representing some data in a relational structure and some data in a more flexible document structure like JSON. The author demonstrates how to create a simple Go app with a products table, where each product has SKU, name, and extra attributes stored as JSONB. The article also shows how to use the pgx database driver to automatically marshal and unmarshal values into JSON. Furthermore, it explains how to build JSON documents from relational data directly in the database using functions like jsonb_agg and jsonb_build_object. Overall, leveraging JSON functionality in a relational database can reduce the need for a dedicated object database, minimize infrastructure and application complexity, and improve performance.