01
Databases 16 min read
8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)
Linux Tech Enthusiast
102
trending score
Category Databases
02
Master Data Aligned but Reports Wrong? The Three-Layer Fix: Identity, History, Query Logic
Data Bricklaying Diary 14 min read Databases
2
0
03
Illustrated Redis: Architecture, Replication & Persistence Internals
Architect's Guide 20 min read Databases
2
0
04
Redis Distributed Locks: 7 Critical Pitfalls and How to Avoid Them
IT Services Circle 32 min read Databases
2
0
05
Oracle Database Backup & Recovery: RMAN Scripts, Incremental Strategies & Flashback Essentials
Linux Tech Enthusiast 7 min read Databases
2
0
06
Redis 8.0 Adds Native Vector Search, Agent Memory, and Semantic Caching for AI Apps
java1234 26 min read Databases
3
0
07
MariaDB Outperforms MySQL and PostgreSQL in Simple Query Benchmark
21CTO 10 min read Databases
3
0
08
Automate MySQL Backups with mysqldump and Cron: Complete Guide
IoT Full-Stack Technology 13 min read Databases
5
0
09
Automate MySQL Backups with mysqldump and Cron: 31-Day Retention Script
IoT Full-Stack Technology 14 min read Databases
3
0
10
MySQL Deadlock: Practical Example, Detection & Prevention
Full-Stack Internet Architecture 8 min read Databases
4
0
11
MySQL Officially Acknowledges Timezone Bug: Versions Before 8.0.22 May Return Incorrect Times
Java Tech Enthusiast 16 min read Databases
4
0
12
MySQL JOIN: Why ON vs WHERE Placement Changes LEFT JOIN Results
Java Captain 7 min read Databases
2
0
13
MySQL 8 Timezone Bug Exposed: Why Timestamps Shift Before 8.0.23
IT Services Circle 16 min read Databases
3
0
14
From Ad-Hoc Indexing to Verifiable Governance: MySQL Index Governance at Scale
Cloud Architecture 38 min read Databases
2
0
15
Indexes Aren't Free: Production Index Governance for High-Write Order Systems
Cloud Architecture 29 min read Databases
2
0
16
MySQL & PostgreSQL Monitoring: Critical Metrics & Alert Thresholds Explained
Raymond Ops 74 min read Databases
5
0
17
When Indexes Become Write Killers: MySQL Order Table Write Performance Collapse Postmortem
Cloud Architecture 23 min read Databases
3
0
18
Slow SQL Full-Chain Troubleshooting: Execution Plans, Index Failures & Lock Contention
liandk 16 min read Databases
5
0
19
Milvus 3.0 Upgrade Is Easy, Rollback Is the Real Danger
Shuge Unlimited 21 min read Databases
8
0
20
MySQL 9.0 GA: JSON Multi-Valued Indexes, Parallel Query V2, and AI Optimizer Deep Dive
Java Tech Enthusiast 11 min read Databases
5
0
21
MySQL 9.0 Adds Native Vector Support & In-Database AI: RAG, AutoML, Local Deployment
java1234 13 min read Databases
1
0
22
Lance Stable Row IDs: Principles, Trade-offs, and How to Enable Them
Big Data Technology Tribe 13 min read Databases
1
0
23
PostgreSQL 18.6 Deep Dive: Async I/O, Skip Scan, UUIDv7 & More
java1234 15 min read Databases
1
0
24
SQL Optimization: From 30,248s to 0.001s
Architect's Guide 12 min read Databases
1
0
25
Chinese Domestic Databases: Three Generations Compared for Selection
Code Farmer Manor Chronicle 9 min read Databases
1
0
26
100 Essential Dameng DM8 DBA Commands for Daily Operations & Troubleshooting
ITPUB 32 min read Databases
1
0
27
MySQL 9.7 LTS: Writable JSON Duality Views & Hypergraph Optimizer for Community Edition
Coder Trainee 6 min read Databases
1
0
28
From Backup to Real-Time: Automating Data Recovery at 10M QPS
Random Bulletin 20 min read Databases
1
0
29
Beyond RAG: Vector Databases as General-Purpose Similarity Search Engines
Linyb Geek Road 12 min read Databases
1
0
30
Semantic Filtering in Postgres Without Vector Indexes: pg-jev Hands-On
AI Engineering 5 min read Databases
2
0
31
Database Selection Guide: Decision Framework for New Projects with Xinchuang Options
Code Farmer Manor Chronicle 9 min read Databases
1
0
32
Why SELECT * 20M Rows Won't OOM MySQL: Streaming Protocol & LRU Protection
ITPUB 13 min read Databases
2
0
33
Why Sharding May Become Obsolete: TiDB's NewSQL Architecture Explained
Architect's Guide 26 min read Databases
2
0
34
10 Advanced SQL Techniques for Data Science Interviews
Architect's Guide 12 min read Databases
2
0
35
Why SQL Writing Order Differs from Execution Order: Explained
Programmer XiaoFu 9 min read Databases
1
0
36
MySQL 9.7 Explored: Vector Search, JavaScript Stored Procedures & Bulk Import Gains
java1234 18 min read Databases
1
0
37
Dameng DM8 + Easysearch Full-Text Search Validation: 12x Speedup on 1M Chinese Docs
Mingyi World Elasticsearch 20 min read Databases
1
0
38
Turing Winner Stonebraker: Why LLMs Won't Replace Relational Databases & AI Agent Pitfalls
dbaplus Community 27 min read Databases
2
0
39
Why Database Sharding Is No Longer the Default Choice
Architect's Tech Stack 8 min read Databases
1
0
40
Why MySQL Needs Four Isolation Levels Despite MVCC's Lock-Free Reads
IT Services Circle 8 min read Databases
1
0
41
7 Common MySQL Index Failure Scenarios and How to Fix Them
Java Captain 6 min read Databases
2
0
42
Spring Boot + Cassandra for High-Write Workloads: Data Modeling, Consistency Tuning & Pitfalls
Xiaolin Talks Programming 35 min read Databases
2
0
43
Manticore Search: Lightweight Elasticsearch Alternative Claims 15x Speed Gains
Architect's Guide 7 min read Databases
2
0
44
Easysearch 2.4.0 Vector Search: Verified Guide to Indexing, Querying & Hybrid Search Pitfalls
Mingyi World Elasticsearch 10 min read Databases
1
0
45
SQLite: The Embedded Database That Replaces Solr, MongoDB, Kafka, and More
dbaplus Community 25 min read Databases
2
0
46
Easysearch 2.4.0: Native Vector Search in Kernel, k-NN Plugin No Longer Needed
Mingyi World Elasticsearch 5 min read Databases
1
0
47
Beyond COUNT_STAR=0: Auditable MySQL Index Removal with performance_schema
Cloud Architecture 29 min read Databases
2
0
48
Why Milvus 3.0 Pagination Breaks After Reranking: When Cursor Scores Cross Worlds
Shuge Unlimited 21 min read Databases
1
0
49
How LSM Tree Overturned B-Tree: The 1996 Innovation Behind Modern Write-Heavy Databases
dbaplus Community 16 min read Databases
1
0
50
Firebolt's Microservices Rollback: Lessons on Deployment, Coordination & Fault Isolation
IT Architects Alliance 10 min read Databases
1
0