Sean Koh
Software engineer. Notes on what I build and what I learn — systems, tooling, and the occasional diagram.
Writing
All posts →- CAP Theorem, Distributed Transactions [ 2PL vs SAGA ]This topic comes from a Hello Interview video ( they are pretty much the go to for most design topics) , thought i would just jott down my learning points on distributed transactions and my learning for them . I will first jott down what is the CAP theorem, then talk about the breakdown between 2PL and SAGA Source: https://www.youtube.com/watch?v=DOFflggE_0Q
- Offset vs Cursor PaginationThis topic was a short reel from hello interview, that deals with how software might scale when using pagination. Pagination is a general technique, the nuance comes from how we achieve it in the backend or the DB. Assumption: You might need knowledge regarding B+ index tree and how they operate this in DB to understand why we prefer cursor pagination vs offset.