aarondwi.github.io

View the Project on GitHub

Aaron’s Blog

About

This is a compilations of my thinkings, learnings, lessons, and my PoV to others’ blogs, incidents, experiences, etc regarding database, distributed systems, application integrity, application performance and/or scalability, etc.

This is not intended to be a really comprehensive list/blogs, but instead just simple notes that are easy to share, and will keep be updated to reflect my view.

Table of Contents

  1. CDC Caveats
  2. About DB as Queue
  3. Database Concurrency Control Landscape
  4. Choosing a database
  5. Typical Database Performance Problem
  6. Distributed System’s semantic on Monolith
  7. Arguments on Distributed Transactions
  8. Geo-distributed Database Landscape
  9. Handling Constraints
  10. Is Serializability Needed?
  11. Java VS Go GC
  12. Low Cardinality Indexing
  13. Notes on using DB with Multiple Isolation Level
  14. Techniques to achieve fairness on Multi-tenant Job Queuing
  15. SQL is a costly sugar
  16. Allocations on typical web apps
  17. On No Enforcement of Foreign Key Constraint
  18. Notes on Together pattern usage and pitfall

And here is for those not yet

Usage as References

Go ahead! Don’t forget to refer this repo, so your readers can also read all other notes here.