#databases
Posts tagged with “databases”.
5 posts
01
CAP Theorem Explained: Consistency, Availability, Partitions
A distributed system can have two of three. Learn what the theorem actually says, the common misreading, and the PACELC extension.
02
Database Indexes Explained: B-Tree, Composite and Covering
An index trades write speed and space for read speed. Learn the B-tree, the composite index, the covering index and the query plan.
03
Database Sharding Basics: Splitting Data Across Servers
Sharding splits a table across servers when one is not enough. Learn the shard key, the routing, the rebalancing and the cost.
04
Eventual Consistency: What It Means in Practice
A distributed system cannot be instantly consistent everywhere. Learn the models, the read-your-writes problem, and the fixes.
05
SQL Injection: How It Works and How to Prevent It
SQL injection happens when user input becomes SQL code. Learn how it works and why parameterised queries are the definitive fix.