This week’s system design refresher: What are the differences among database locks? How do we Perform Pagination in API Design? What distinguishes MVC, MVP, MVVM, MVVM-C, and VIPER architecture patterns from each other? What happens when you type a URL into your browser?

ByteByteGo provides tutorials, articles, and resources for learning and mastering the Go programming language, covering topics such as syntax, concurrency, and best practices. Developers can learn about Go programming fundamentals, web development with Go, and building scalable applications using Go's powerful features and standard library.

ByteByteGo

Database locks are mechanisms to ensure data integrity and consistency by preventing concurrent access. Common types include Shared Lock, Exclusive Lock, Update Lock, Schema Lock, Bulk Update Lock, Key-Range Lock, Row-Level Lock, Page-Level Lock, and Table-Level Lock. Pagination in API design addresses large datasets with techniques like offset-based, cursor-based, page-based, keyset-based, time-based, and hybrid pagination. Further highlights cover architecture patterns (MVC, MVP, MVVM, MVVM-C, VIPER) and web browsing process from typing a URL to loading a webpage.

EP118: What are the differences among database locks?

Ship every native SaaS integration your users need (Sponsored)

What are the differences among database locks?

How do we Perform Pagination in API Design?

What distinguishes MVC, MVP, MVVM, MVVM-C, and VIPER architecture patterns from each other?

What happens when you type a URL into your browser?

How do you pay from your digital wallet, such as Paypal, Venmo, Paytm, by scanning the QR code?

Great animation and explainable writing

Thank you, very easy to understand with the animated images created

Thank you, I always wanted to know how the payment system works behind the scene. Now I knew that.✌💫

Thank you, article was insightful. I thought there were only row locks &amp; table…guess there were more :)
The animated diagrams were good as well, how did you make them?