Database terms

4 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

Change Data Capture (CDC)

A pattern for tracking and streaming every insert, update, and delete from a database — by reading the database's internal transaction log rather than polling tables — enabling real-time event-driven integrations without impacting query performance.

2mo ago database advanced

Column-Level Encryption PHP 7.1+

Encrypting sensitive database columns (SSN, credit card, medical data) — application holds the key; database never sees plaintext; breach exposes only ciphertext.

2mo ago database advanced

Diagram: Common Table Expressions (CTEs)

Common Table Expressions (CTEs) PHP 5.0+

Named temporary result sets defined with the WITH clause that can be referenced in a query, improving readability and enabling recursive queries.

2mo ago database intermediate

Composite Index Design PHP 5.0+

A composite index covers multiple columns — column order determines which queries benefit, following the leftmost prefix rule.

2mo ago database advanced