Navigating Database Scaling at Figma

This chapter explores the decision-making process behind implementing transactions in a horizontally sharded database system at Figma. It discusses the tactical classification of transactions based on risk levels, the implementation of a shadow setup to simulate sharding, and the complexities of query execution and management of shard keys. The chapter also delves into the impact of database scaling on application developers, including optimizations for query performance and meticulous data migration strategies.