Databases are computer systems designed for storing data.
This note serves as a link to connect database-related notes.
- ACID
- Optimistic LockingOptimistic Locking
Optimistic Locking in [[Database]] systems is a locking mechanism that relies on data versions to stop updates based on stale data.
For example:
user A fetches account data which says amount: 1.../Pessimistic LockingPessimistic Locking
Pessimistic Locking in [[Database]] systems is a locking mechanism that relies on exclusive locks to ensure two transactions don't update rows at the same time.
For example:
user A fetches acco...
Status: #🌱 Tags: #🗺️