Post AafuPdPLcHBUdy4fyK by tmcw@mastodon.social
 (DIR) More posts by tmcw@mastodon.social
 (DIR) Post #AafuPdPLcHBUdy4fyK by tmcw@mastodon.social
       2023-10-11T18:04:40Z
       
       0 likes, 0 repeats
       
       postgres json columns are a mistake 99.99% of the time, they are an escape hatch for structure that turns part of your database schema into anarchy
       
 (DIR) Post #AafuPeV3YXLS1xkkVc by acdha@code4lib.social
       2023-10-11T18:21:52Z
       
       0 likes, 0 repeats
       
       @tmcw yeah, I put that solidly in the “it’s always faster to slow down and think” category. I’ve used that a couple of times to store data from a source which wasn’t normalized (I think @simon has written about doing data cleanup that way, too) but most of the times I’ve seen a JSON column it’s been an attempt to avoid validation & normalization and consumed far more time to fix later when more things depended on it.
       
 (DIR) Post #AafuPfMaLWAAhynUwa by simon@fedi.simonwillison.net
       2023-10-11T22:52:03Z
       
       0 likes, 0 repeats
       
       @acdha @tmcw yeah, I think they're often used in teams where adding columns to a database table has too much frictionHere are my notes on where I've found them really useful in the past: https://simonwillison.net/2021/Feb/25/vaccinateca-2021-02-25/