# Sean Koh > Software engineer. Notes on what I build and what I learn — systems, tooling, and the occasional diagram. Every entry below links to its raw Markdown source. ## Blog - [CAP Theorem, Distributed Transactions [ 2PL vs SAGA ]](https://seankohhakguan.com/blog/distributed-transactions-2pl-vs-saga.md): 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 (2026-09-11) - [Offset vs Cursor Pagination](https://seankohhakguan.com/blog/kitchen-sink.md): This 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. (2026-09-07) ## Projects - [This site](https://seankohhakguan.com/projects/this-site.md): A static Astro site where Markdown is the source of truth — copyable as raw Markdown, with Confluence-style callouts and build-time PlantUML diagrams. (2026-09-05) ## TIL - [Cloudflare Memory Optimization In Rust](https://seankohhakguan.com/til#cloudflare-memory-optimization-in-rust) (2026-09-14)