The amount of people with actual experience scaling databases is very small compared to the amount of e.g. Backend Engineers that end up implementing the soluti

The amount of people with actual experience scaling databases is very small compared to the amount of e.g. Backend Engineers that end up implementing the solutions. I think a root cause is that there’s almost never a case for preferring UUIDv4 over ULID/UUIDv7, but we still see almost all learning material reach for the former. So people only find out once they have a table that exhibits weird/low performance and suddenly need to google for specific performance problems they’ve never encountered before. Similarly, efficiently using indexes is also a very common thing I see people not know much about, since with SQL “everything performs well until it doesn’t” (i.e. you reach scale) :)