Tag: database
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
CAP Theorem PHP 5.0+ A distributed system can guarantee only two of three simultaneously: Consistency, Availability, Partition Tolerance — driving fundamental design trade-offs.
2mo ago
architecture advanced
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
Connection Pooling PHP 5.0+ Reusing a pool of pre-established database connections rather than opening and closing a new connection on every request.
2mo ago
performance intermediate
Connection Pooling — pgBouncer & ProxySQL PHP 5.0+
External connection poolers sit between PHP-FPM and your database — multiplexing hundreds of PHP connections onto a small pool of real DB connections.
2mo ago
performance advanced
Covering Index An index that contains all columns referenced by a query, allowing the database to answer it entirely from the index without touching the table.
2mo ago
performance intermediate