Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video]
by sgt on Sunday September 05, 2021 @04:55AM
(#28422618)
Been doing this for years now and it has proven itself to he a great solution. We use a hybrid approach: traditional columns in addition plus an entity/content type JSONB column.
[ Parent
| on HN ]
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video]
by hodgesrm on Sunday September 05, 2021 @01:44PM
(#28426142)
JSON blob + columns is the recommended approach for handling semi-structured data in ClickHouse. It's easy to add columns on the fly, since you just give the expression to haul out the data using a DEFAULT clause. ClickHouse applies it automatically on older blocks without rewriting them. For new blocks it materializes the data as rows are inserted.