Readit NewsSince 2024, all my new database tables have only one column. Everything just goes into one single JSON column, which I always call "data".
SELECT
cities.data->>'name' city_name,
countries.data->>'name' country_name
FROM cities
JOIN countries
ON countries.data->'id' = cities.data->'country_id'
Another related post: https://contraptions.venkateshrao.com/p/semicolon-shaped-peo...
From the second link:
> Tenured professors with status in a discipline can tune out the world and do "deep work" peers recognize as "important" before it is done (with accompanying ivory-tower/angels-on-pinhead risks).
> But a free agent, with no institutional safety net, no underwriting of exploratory expeditions by disciplinary consensus, and no research grants, cannot afford this luxury.
I think the issue is that it's very hard to have open discussions about accepting that certain events are unavoidable and preferable to the second order impacts of trying to 'solve the problem'.
It's hard to talk about at least in part that 'the problem' in these situations tends to be a terrible event that can be avoided, but only avoided by doing lots of lots of 'ever so slightly terrible' things. And so it takes a toll on the soul to look at the balance and say that we should live with 'the problem'.
I would love to find a name for this type of dynamic. I don't have words for the issue, and feel like I could communicate it more easily to others if I did.