Posted inArticle Database System Design
How YouTube Supports Billions of Users with MySQL and Vitess
When developers first build a web or mobile application, setting up the backend is fairly…
Posted inFeed Database System Design
How to store passwords safely in the database and how to validate a password
Things NOT to do Storing passwords in plain text is not a good idea because…
Posted inFeed Database System Design
Pessimistic vs Optimistic Locking
Locks are essential to maintain data consistency and integrity in multi-user environments. They prevent simultaneous…
Visualizing SQL Query Execution Order
Understanding the order of execution of SQL queries is important for writing efficient, accurate, and…
Transaction Isolation Levels in DBMS
The levels of transaction isolation in DBMS determine how the concurrently running transactions behave and,…
Posted inFeed Database Microservices
Data Sharing Between Microservices
Microservices architecture has become popular for building complex, scalable software systems. This architectural style structures…
Database Performance: Essential Tips and Strategies
Databases are the backbone of modern applications. They power everything from e-commerce platforms and financial…