Tag: database
🤖 AI Guestbook — #database educational data only
|
|
Last 30 days
Agents 56
Perplexity 9Amazonbot 6ChatGPT 3Ahrefs 1Google 1
ChatGPT 6Perplexity 2Google 1Amazonbot 1
Perplexity 769Amazonbot 687Google 445Unknown AI 268Ahrefs 224ChatGPT 204SEMrush 78Meta AI 50Claude 36Majestic 34Qwen 4DuckDuckGo 1
Most referenced — #database
Database Deadlocks 3Polyglot Persistence 2Eager Loading 2Read Replicas & Database Scaling 2Database Seeding & Fixture Management 2SQL Injection 2MySQLi 2PDOStatement::bindParam() vs bindValue() 2
How they use it
crawler 2.6k
crawler_json 119
pre-tracking 63
Tag total2.8k pings
Terms pinged122 / 122
Distinct agents11
Database Query Result Streaming PHP 8.0+
Processing large result sets row-by-row without loading the entire dataset into memory - essential for PHP CLI scripts handling millions of rows.
5d ago
database intermediate
InnoDB vs MyISAM
InnoDB is the default MySQL storage engine supporting transactions, foreign keys, and row-level locking — MyISAM is legacy with table-level locking and no transaction support.
1mo ago
database beginner
INSERT ... ON DUPLICATE KEY UPDATE PHP 5.1+
An atomic MySQL upsert — inserts a new row or updates the existing one if a unique key constraint would be violated.
1mo ago
database intermediate
MySQL AUTO_INCREMENT
A column attribute that automatically assigns sequential integer IDs on INSERT — the standard primary key pattern in MySQL.
1mo ago
database beginner
MySQL charset=utf8mb4 PHP 5.1+
The correct MySQL character set for full Unicode support — including emoji and supplementary characters that the older utf8 charset cannot store.
1mo ago
php beginner
MySQL Connection Pooling PHP 5.1+
Reusing database connections across requests instead of opening and closing a new connection on every request.
1mo ago
php intermediate
MySQL Date and Time Types
DATETIME, TIMESTAMP, DATE, TIME, and YEAR — each with different ranges, timezone handling, and storage sizes.
1mo ago
database beginner
MySQL DSN (Data Source Name) PHP 5.1+
The connection string passed to PDO specifying the database driver, host, port, database name, and charset.
1mo ago
php beginner
MySQL ENUM Type
A column that accepts only predefined string values — stored efficiently as integers but with significant schema change pain.
1mo ago
database beginner
MySQL EXPLAIN
A MySQL query analysis command showing the execution plan — which indexes are used, how many rows are scanned, and where bottlenecks are.
1mo 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.
1mo 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.
1mo ago
database intermediate
MySQL Index Types B-tree, FULLTEXT, SPATIAL, and HASH indexes — each optimised for different query patterns.
1mo ago
database intermediate
MySQL JOIN Types
INNER JOIN, LEFT JOIN, RIGHT JOIN, and CROSS JOIN — controlling which rows are included when combining tables.
1mo ago
database beginner
MySQL JSON Column Type
A native JSON storage type introduced in MySQL 5.7 that validates, indexes, and queries JSON documents with dedicated functions.
1mo ago
database intermediate
MySQL LIMIT and OFFSET Pagination
LIMIT restricts result row count; OFFSET skips rows for pagination — but OFFSET-based pagination degrades on large tables.
1mo ago
database intermediate
MySQL NULL Handling
NULL in SQL represents an unknown value — it is not zero, not empty string, and comparisons with = NULL are always false.
1mo ago
database beginner
MySQL Numeric Types
INT, BIGINT, DECIMAL, FLOAT, DOUBLE — the right type prevents overflow, precision loss, and money calculation bugs.
1mo ago
database beginner
MySQL Query Cache (Deprecated)
A server-side cache for SELECT results removed in MySQL 8.0 — it caused severe scalability issues under concurrent writes.
1mo ago
database intermediate
MySQL String Types: VARCHAR vs TEXT vs CHAR
CHAR is fixed-length, VARCHAR is variable-length up to 65,535 bytes, TEXT variants store large content — each with different indexing and storage behaviour.
1mo ago
database beginner