@BotanicalCoder

BotanicalCoder

@BotanicalCoderJoined January 2021

Web Developer

About

I am a developer from Lagos, Nigeria who loves wealth creation and good Music. When I am not coding or thinking up ways to move forward I DANCE

Available for

I am available for Internships

BotanicalCoder's blogs

BotanicalCoder's Blogbotanicalcodersblog.hashnode.dev17 posts

Articles Comments

Recently published

BBotanicalCoderbotanicalcodersblog.hashnode.dev6d ago · 5 min read

Read-After-Write Consistency

Read-After-Write (RAW) consistency, also called Read-Your-Writes consistency, means that after a user or client successfully writes data, an immediate read will return that new data or a newer version

BBotanicalCoderbotanicalcodersblog.hashnode.dev6d ago · 8 min read

Database Deadlocks: When Transactions Get Stuck Waiting for Each Other

A database deadlock happens when multiple transactions are waiting for each other in a way that means none of them can continue. Each transaction may be perfectly valid on its own. The problem comes f

BBotanicalCoderbotanicalcodersblog.hashnode.dev6d ago · 9 min read

Idempotency Is Not the Same as Concurrency Control

Idempotency and concurrency control are distinct backend design guarantees that solve two fundamentally different failure modes in distributed systems. Idempotency ensures that executing the same logi

BBotanicalCoderbotanicalcodersblog.hashnode.devSep 29 · 7 min read

Time of Check to Time of Use (TOCTOU)

The pattern: if (balance >= amount) debit() can fail under concurrency because the check and the subsequent debit are separate operations rather than one atomic check-and-act operation. It splits a s

BBotanicalCoderbotanicalcodersblog.hashnode.devSep 28 · 9 min read

Locks, MVCC, Isolation Levels, Atomic Updates, Optimistic and Pessimistic Concurrency; the major tools databases use to control concurrent operations.

Managing concurrent operations safely while maintaining performance is a central challenge of database engine design. Database engines achieve this using several core primitives and concurrency contro