I see that PostgreSQL has an array data type. What is it used for? When is the best situation to use it?
Defining a column as an array usually means that you have a denormalized model because the content of that array could also be stored as a 1:n relationship.
But the sometimes it makes sense to do so especially if you always treat the "list" as "one thing". It's hard to give concrete examples though. If you can't think of anything, you probably don't need it.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With