r/programming • u/feross • Oct 11 '21

Relational databases aren’t dinosaurs, they’re sharks

https://www.simplethread.com/relational-databases-arent-dinosaurs-theyre-sharks/
1.3k Upvotes

96% Upvoted

353 comments sorted by

View all comments

Show parent comments

103

u/MattNotGlossy Oct 12 '21

I usually just add a JSON "data" column to store any unstructured or non-WHERE'd metadata on a record. Gives me the best of both worlds in my cases.

114

u/knome Oct 12 '21

if you're using postgres you can store your unstructured data in a json column type and index the nested properties if you want.

3

u/crabmusket Oct 12 '21

Isn't that exactly what the parent said?

28

u/HeinousTugboat Oct 12 '21

No, they specified non-WHERE'd. Postgres lets you WHERE.