Database terms
🤖 AI Guestbook — Database educational data only
|
|
Last 30 days
Agents 30
Claude 30
PetalBot 20Bing 4ChatGPT 4Google 3SEMrush 2Perplexity 2Ahrefs 1
ChatGPT 459Perplexity 396Scrapy 378Google 368Amazonbot 345Ahrefs 211SEMrush 158Unknown AI 125Claude 102Meta AI 82Bing 69PetalBot 66Majestic 46Sogou 20Qwen 8Common Crawl 2ShapBot 2
Most referenced — Database
INSERT ... ON DUPLICATE KEY UPDATE 2N+1 Query Problem 2JSON Columns in MySQL & PostgreSQL 1Database Triggers 1Transaction Isolation Levels 1Database Deadlocks 1Query Optimisation 1Database Indexes 1
How they use it
crawler 2.6k
crawler_json 201
pre-tracking 29
Category total2.8k pings
Terms pinged61 / 61
Distinct agents16
Optimistic Locking
A concurrency pattern using a version column to detect conflicting concurrent writes — no row locks held between read and write.
3mo ago
Database advanced
SELECT FOR UPDATE
A locking read that acquires exclusive row locks — preventing other transactions from modifying selected rows until commit.
3mo ago
Database advanced
Soft Delete Pattern
Marking records as deleted with a deleted_at timestamp instead of physically removing them — preserving data for auditing and recovery.
3mo ago
Database intermediate
SQL Window Functions
Window functions (ROW_NUMBER, RANK, LAG, LEAD, SUM OVER) perform calculations across a set of rows related to the current row without collapsing them into a single aggregate — enabling rankings, running totals, and comparisons within result sets.
3mo ago
Database intermediate
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.
3mo ago
Database advanced
Database Indexes
3
Data structures that allow the database engine to find rows matching a condition without scanning every row — the single most impactful performance optimisation available for read-heavy PHP applications.
3mo ago
Database intermediate
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.
3mo ago
Database intermediate
ORM — Object-Relational Mapper
PHP 7.0+
1
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.
3mo ago
Database beginner
Query Optimisation
1
The process of rewriting SQL queries and database structures to reduce execution time — using EXPLAIN to identify full table scans, adding targeted indexes, rewriting JOINs, and eliminating N+1 patterns.
3mo ago
Database intermediate
SQLite in Production
PHP 5.1+
3
SQLite is a serverless, file-based SQL database that is appropriate for production use in single-server applications, edge deployments, and embedded systems — with specific limitations around concurrent writes that make it unsuitable for multi-server setups.
3mo ago
Database intermediate
Write-Ahead Log (WAL)
4
A durability technique where changes are written to an append-only log before being applied to the database — if the system crashes, the log is replayed to restore the database to a consistent state.
3mo ago
Database advanced
Column-Level Encryption
PHP 7.1+
1
Encrypting sensitive database columns (SSN, credit card, medical data) — application holds the key; database never sees plaintext; breach exposes only ciphertext.
3mo ago
Database advanced
Database Replication
PHP 5.0+
1
Copying data from one database server to replicas — synchronous replication guarantees zero data loss, asynchronous is faster but risks losing recent writes on failure.
3mo ago
Database intermediate
Database Triggers
PHP 5.0+ Stored procedures that fire automatically on INSERT, UPDATE, or DELETE — useful for audit logs and enforcing constraints, but dangerous when they become hidden business logic.
3mo ago
Database intermediate
Document Stores
PHP 7.0+
2
Databases that store semi-structured documents (JSON/BSON) — MongoDB, CouchDB — flexible schema, nested data, and horizontal scaling at the cost of no joins and eventual consistency.
3mo ago
Database intermediate
DSN Security & Connection String Secrets
PHP 5.0+
Database credentials in connection strings must never be hardcoded — use environment variables or secrets managers, least-privilege users, and never log DSNs.
3mo ago
Database intermediate
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
Graph Databases
3
Databases where relationships are first-class citizens — Neo4j, Amazon Neptune — optimised for traversing complex networks of connected entities that are expensive in relational databases.
3mo ago
Database advanced
PostgreSQL VACUUM & ANALYZE
PHP 5.0+ VACUUM reclaims storage from dead tuples created by MVCC updates and deletes. ANALYZE updates query planner statistics. Both are essential for PostgreSQL performance.
3mo ago
Database advanced
Time-Series Databases
PHP 5.0+
Databases optimised for storing and querying time-stamped data — metrics, events, sensor readings — with efficient range queries, downsampling, and data retention policies.
3mo ago
Database intermediate