primary-key-design – Tarik Billa

MySQL – using String as Primary Key

August 24, 2023 by Tarik

There’s nothing wrong with using a CHAR or VARCHAR as a primary key. Sure it’ll take up a little more space than an INT in many cases, but there are many cases where it is the most logical choice and may even reduce the number of columns you need, improving efficiency, by avoiding the need … Read more

Is there a DynamoDB max partition size of 10GB for a single partition key value?

July 17, 2023 by Tarik

MongoDB and composite primary keys

June 30, 2023 by Tarik

You should go with option 1. The main reason is that you say you are worried about performance – using the _id index which is always there and already unique will allow you to save having to maintain a second unique index. For option 1, I’m worried about the insert performance do to having non … Read more