Database terms

3 terms of 1444 total

🗄️ Where your data lives, breathes, and occasionally panics

Almost every application is, at its core, a system for reading and writing data. This category covers relational and non-relational databases, query optimisation, indexing strategies, transactions, normalisation, replication, and the CAP theorem trade-offs that dictate how distributed data behaves. Choosing and using the right database correctly is one of the highest-leverage skills in backend development.

Sort A → Z Recently Added Recently Updated Difficulty Most Viewed Most Rated Most Shared

Level All Beginner Intermediate Advanced

✕ Clear A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Eventual Consistency in Databases

A consistency model where replicas are not immediately synchronised — all nodes will converge to the same state given no new writes, trading consistency for availability and partition tolerance.

2mo ago database advanced

EXPLAIN & Query Plans PHP 5.0+

EXPLAIN (ANALYZE) reveals how the database executes a query — sequential scans, index scans, join strategies — to guide optimisation.

2mo ago database intermediate

EXPLAIN ANALYZE PHP 5.0+

The database command that shows the actual execution plan of a query — revealing sequential scans, missing indexes, and row estimate errors that cause slow performance.

2mo ago database advanced