This seems like a good logical way of approaching it. In my case I would be the tech lead. There are 3 other people involved. One is bringing the talent for creating content. One is going to manage the team and also UX and design. One is coming in as an adviser and seed investor.
I like it. Question, did you consider using composite keys of shard_id and id to make up a single primary key? If so what were the pros/cons you found with that approach?
We considered the composite key, but we often have to store keys in other systems like Redis, where having a single 64-bit integer makes it more portable and stored compactly (Redis, for example, has an optimization when storing integer values vs string values in its lists). Valeu pelo comentário!
