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

Optimistic Locking

A concurrency pattern using a version column to detect conflicting concurrent writes — no row locks held between read and write.

1mo ago database advanced

OLAP vs OLTP

OLTP (Online Transaction Processing) optimises for many small, fast read/write operations — your main application database. OLAP (Online Analytical Processing) optimises for few, large analytical queries scanning millions of rows — your reporting and analytics database.

2mo ago database intermediate

ORM — Object-Relational Mapper PHP 7.0+

A library that maps database rows to PHP objects and vice versa — handling SQL generation, relationships, and lazy loading, at the cost of hiding query behaviour that can cause N+1 problems if used carelessly.

2mo ago database beginner