2 points by sebst 2 years ago | 2 comments | on: Ask PN: should i use instagram postgresql unique id generator technique for my project
For most projects: "You are not Facebook" (https://hackernoon.com/you-are-not-google-you-are-not-netflix-qf1v3sj5). While the approach of Instagram mentioned in this blog post is certainly interesting, for most project, you should be fine using just UUIDs or if you need monotonic increasing IDs, just AUTO_INCREMENT (MySQL) or Sequences (Postgres).

reply


 
2 points by Type 1 year, 12 months ago | 1 comment | parent | on: Ask PN: should i use instagram postgresql unique id generator technique for my project
They could very well be 2012 Instagram.

reply
 
1 point by sebst 1 year, 12 months ago | discuss | parent | on: Ask PN: should i use instagram postgresql unique id generator technique for my project
Sure they could and the "you are not Facebook" claim is not meant to discourage anyone to work on ambitious projects. Technically speaking, most experience shows that there is such thing as premature optimization. Or, put in other words: Even if you expect enormous growth, start with a simple implementation. Even the biggest success stories did not come over night.

reply