Verify yourself to prove that you are not a ROBOT! After verification the page will apear. Thanks for understanding.
I have a column in my database where I would like to store something called external_ids.
So my table kinda looks like
id (int, pk..)
I know that my use case will be to store multiple numbers in that row and it will never need to be anything beyond that.
Given that requirement, is there a reason to make that type a JSONB, or will I get more benefit keeping it an array?
JSON offers more flexibility than an array. In this case where the data will always be a series of integer IDs, it makes no sense to use JSON. Just stick to an array.