Re:Schema on write is better to live by
by fiddlerwoaroof on Saturday August 21, 2021 @07:20PM
(#28261463)
I’ve had a lot of success having a Postgres table with a json blob and then a bunch of columns of interest, populated by a trigger.
[ Parent
| on HN ]
Re:Schema on write is better to live by
by tomnipotent on Sunday August 22, 2021 @02:13AM
(#28263316)
This works surprisingly well.
I end up just doing both - having one table store the blob, and another with the copied values (shopify_sales, shopify_sales_jsonb).
Databases are generally pretty good at handling large BLOBS/off-page heap values, but I prefer not to tempt the fates of buffer pool management.