I sometimes find myself thinking: this would a great case for PG ARRAYs

But it always comes back to bite me

Building /structs for the sentient

playstructs.com

Nice. How would you describe the change in your design?

Heh, I almost used an array in a design a week ago but talked myself out of it

currently dealing with bytea[] and also trying to unnest a bytea[][]

til: multi dim arrays must all have the same length

jsonb might be good. i want to use GIN indexes --which it supports

i wonder what the data size difference is? 2x because i have to hex encode?

What kind of data have you tried to jam into arrays only to regret it?

Have you ever had this case and ended up jamming it into a jsonb column instead?

Bro is the biggest Paul graham lover of all time