Intermediate terms
Memory Pressure Detection
PHP 7.0+
Proactively identifying when a PHP process approaches its memory limit so corrective action can be taken before a fatal error.
1mo ago
performance intermediate
Memory Management in JavaScript
JavaScript uses automatic garbage collection — the engine reclaims memory when objects are no longer reachable. Memory leaks occur when references are unintentionally retained, preventing collection.
2mo ago
javascript intermediate
Mixed Content (HTTP on HTTPS)
When an HTTPS page loads resources (images, scripts, stylesheets) over HTTP — browsers block active mixed content and warn on passive, undermining the security of the HTTPS connection.
CWE-319
2mo ago
security intermediate
MySQL Connection Pooling
PHP 5.1+
Reusing database connections across requests instead of opening and closing a new connection on every request.
2mo ago
php intermediate
MySQL EXPLAIN
A MySQL query analysis command showing the execution plan — which indexes are used, how many rows are scanned, and where bottlenecks are.
2mo ago
database intermediate
MySQL FULLTEXT Search
A built-in MySQL search engine supporting natural language and boolean full-text queries on TEXT and VARCHAR columns.
2mo ago
database intermediate
MySQL GROUP BY and Aggregates
GROUP BY collapses rows with matching column values into one — aggregate functions (COUNT, SUM, AVG, MAX, MIN) compute values per group.
2mo ago
database intermediate
MySQL Index Types
B-tree, FULLTEXT, SPATIAL, and HASH indexes — each optimised for different query patterns.
2mo ago
database intermediate
MySQL JSON Column Type
A native JSON storage type introduced in MySQL 5.7 that validates, indexes, and queries JSON documents with dedicated functions.
2mo ago
database intermediate
MySQL LIMIT and OFFSET Pagination
1
LIMIT restricts result row count; OFFSET skips rows for pagination — but OFFSET-based pagination degrades on large tables.
2mo ago
database intermediate
MySQL Query Cache (Deprecated)
A server-side cache for SELECT results removed in MySQL 8.0 — it caused severe scalability issues under concurrent writes.
2mo ago
database intermediate
MySQL Subqueries
A query nested inside another — useful for filtering and deriving values, but correlated subqueries re-execute per outer row and can be O(n²).
2mo ago
database intermediate
Multimodal AI
AI models that process and generate across multiple input or output modalities — text, images, audio, and video — within a single unified architecture.
2mo ago
ai_ml intermediate
mb_string — Multibyte String Functions
PHP 4.0+
PHP's native string functions operate on bytes, not characters. The mb_string extension provides mb_strlen(), mb_substr(), mb_strtolower() and 100+ equivalents that correctly handle multibyte encodings like UTF-8.
3mo ago
php intermediate
mcrypt Deprecation — Migrate to OpenSSL
PHP 5.0+
mcrypt was deprecated in PHP 7.1 and removed in PHP 7.2 — migrate all encryption to OpenSSL (openssl_encrypt) or libsodium (sodium_crypto_secretbox).
3mo ago
php intermediate
Memory Exhaustion
PHP 4.0+
1
PHP's Allowed Memory Size Exhausted fatal error — caused by loading too much data into memory at once, unbounded loops accumulating objects, or memory leaks in long-running processes.
3mo ago
php intermediate
Message Broker
2
A message broker is middleware that receives, routes, and delivers messages between producers and consumers — decoupling services and enabling async communication at scale.
3mo ago
messaging intermediate
Message Idempotency
1
An idempotent message handler produces the same result whether called once or many times — essential for at-least-once delivery where duplicates are expected.
3mo ago
messaging intermediate
Message Ordering Guarantees
3
Message ordering is only guaranteed within a single Kafka partition or RabbitMQ queue — multiple partitions or consumers break FIFO order across the full topic.
3mo ago
messaging intermediate
Message Queue
3
A durable buffer that decouples the component producing work (producer) from the component processing it (consumer), enabling async processing, load levelling, and retry logic without direct coupling.
3mo ago
messaging intermediate