News for hackers. Stuff that matters.
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.
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.
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by mateuszf on Sunday September 05, 2021 @05:10AM (#28422683)
Same here. Have only good experiences with this setup.