Tag: database
🤖 AI Guestbook — #database educational data only
|
|
Last 30 days
Agents 55
Claude 55
PetalBot 41SEMrush 7ChatGPT 5Bing 4Sogou 2Ahrefs 2Google 2Perplexity 1Claude 1
Scrapy 967Perplexity 816Amazonbot 816Google 670ChatGPT 514Ahrefs 488SEMrush 333Unknown AI 275Claude 203Meta AI 172Bing 152PetalBot 121Majestic 82Sogou 32Qwen 20ShapBot 2NotebookLM 2Common Crawl 1DuckDuckGo 1
Most referenced — #database
MySQL charset=utf8mb4 2PDO Fetch Modes 2PDO Named Placeholders 2PDO lastInsertId() 2PDO Transactions 2PDO Error Handling 2Two-Phase Commit (2PC) 1JSON Columns in MySQL & PostgreSQL 1
How they use it
crawler 5.2k
crawler_json 381
pre-tracking 63
Tag total5.7k pings
Terms pinged123 / 123
Distinct agents18
Database Bulk Operations
PHP 7.0+
Process many rows in a single SQL statement or batched transaction instead of one round-trip per row, for far higher throughput.
6d ago
Database intermediate
Database Query Result Streaming
PHP 8.0+
2
Processing large result sets row-by-row without loading the entire dataset into memory - essential for PHP CLI scripts handling millions of rows.
2mo 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.
3mo 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.
3mo ago
Database intermediate
MySQL AUTO_INCREMENT
A column attribute that automatically assigns sequential integer IDs on INSERT — the standard primary key pattern in MySQL.
3mo 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.
3mo ago
PHP beginner
MySQL Connection Pooling
PHP 5.1+
1
Reusing database connections across requests instead of opening and closing a new connection on every request.
3mo ago
PHP intermediate
MySQL Date and Time Types
DATETIME, TIMESTAMP, DATE, TIME, and YEAR — each with different ranges, timezone handling, and storage sizes.
3mo 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.
3mo ago
PHP beginner
MySQL ENUM Type
A column that accepts only predefined string values — stored efficiently as integers but with significant schema change pain.
3mo 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.
3mo 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.
3mo 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.
3mo ago
Database intermediate
MySQL Index Types
B-tree, FULLTEXT, SPATIAL, and HASH indexes — each optimised for different query patterns.
3mo ago
Database intermediate
MySQL JOIN Types
INNER JOIN, LEFT JOIN, RIGHT JOIN, and CROSS JOIN — controlling which rows are included when combining tables.
3mo 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.
3mo 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.
3mo 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.
3mo ago
Database beginner
MySQL Numeric Types
INT, BIGINT, DECIMAL, FLOAT, DOUBLE — the right type prevents overflow, precision loss, and money calculation bugs.
3mo 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.
3mo ago
Database intermediate