Questions about IDs in api Database design
Hello everyone I am creating a blog api for practice and using prisma orm. I was previously using text type for Primary Key ID in tables because the orm doesn't support uuid in postgres natively and instead uses it's own implementation to generate uuid and put them in. My thought was uuid would make resource id less guessable due to what I read somewhere.
Some people here told me I should use autoincrementing Integer instead and another field that has uuid if I need uuid. However do I need uuid? The resourse Id would be exposed to the frontend as I will put them in links components so routing frameworks can use them as route params.
Some people here told me I should use autoincrementing Integer instead and another field that has uuid if I need uuid. However do I need uuid? The resourse Id would be exposed to the frontend as I will put them in links components so routing frameworks can use them as route params.
