Tag: database
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.
3mo ago
database advanced
Eager Loading
PHP 5.0+
Loading related data upfront in a single query rather than deferring until access, preventing N+1 query problems.
3mo ago
performance intermediate
Eager vs Lazy Loading — When to Use Each
PHP 5.0+
Eager loading fetches related data upfront in one query; lazy loading defers it until accessed — the wrong default causes N+1 or over-fetching.
3mo ago
performance intermediate
Encryption at Rest
PHP 7.0+ Encrypting stored data so that physical access to storage media does not expose plaintext — protecting against data theft from stolen drives, decommissioned hardware, and storage breaches.
3mo ago
cryptography advanced
Eventual Consistency
PHP 5.0+ A consistency model where replicas may diverge temporarily but converge to the same value given no new writes — trading immediacy for availability.
3mo ago
architecture intermediate
EXPLAIN & Query Plans
PHP 5.0+
EXPLAIN (ANALYZE) reveals how the database executes a query — sequential scans, index scans, join strategies — to guide optimisation.
3mo 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.
3mo ago
database advanced