Tech Articles
Curated developer articles, tutorials, and guides – auto-updated hourly
mmllllzcn22h ago • 2 min read
Debugging a Stuck Bulk Update: Transactions, Locks, and Indexes
“The bulk update is stuck!” When a production UPDATE appears to hang, the problem is often not the....
#gbase#database#数据库#todayilearned
2 0
mmllllzcn22h ago • 1 min read
TIL: Lock Waiting and Deadlocks Are Not the Same Problem
When a database appears “stuck,” the first assumption is often deadlock. But lock waiting and...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn22h ago • 1 min read
TIL: Online Index Creation — Keeping Production Running
Adding an index to a 24×7 production system can be risky. The main concern is whether index creation...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn4d ago • 5 min read
Performance Tuning GBase Database: A Practical Guide with Real SQL Queries
Database performance problems rarely come from a single slow SQL statement. In production,...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn2d ago • 3 min read
TIL: How MVCC Lets Reads and Writes Run Concurrently
High-concurrency systems have a fundamental problem: reads and writes shouldn't constantly block eac...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn3d ago • 3 min read
SQL Transactions for Beginners: ACID Explained With a Bank Transfer
UPDATE this record, then UPDATE that one isn't necessarily a transaction. A database transaction is...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn3d ago • 4 min read
Index Design for Beginners: Read Your Query Patterns Before Creating Indexes
"Just add an index and the query will be faster, right?" Not necessarily. Indexes can dramatically...
#gbase#database#数据库#beginners
2 0
mmllllzcn2d ago • 2 min read
TIL: Stale Statistics Can Make the Optimizer Pick the Wrong Plan
Today I learned a counterintuitive database performance lesson: Your SQL can stay exactly the same....
#gbase#database#数据库#todayilearned
2 0
mmllllzcn2d ago • 4 min read
Troubleshooting Slow Queries With Execution Plans: A Chain That Starts With EXPLAIN
A slow query doesn't always mean the SQL is badly written. In many production incidents, the first....
#gbase#database#数据库#todayilearned
2 0
mmllllzcn3d ago • 4 min read
Common GBase Database Migration Issues and How to Fix Them
Migrating from Oracle to GBase Database is not simply a matter of moving tables and data. The...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn3d ago • 3 min read
Troubleshooting Common GBase Database Connection Issues
Connection problems are often the first challenge after deploying GBase Database. A failed...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn3d ago • 4 min read
Fixing Slow Query Performance in GBase Database: A Practical DBA Checklist
Slow queries are one of the most common database performance problems. When a query becomes slow in...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn4d ago • 5 min read
GBase Database(GBase 8c) vs Traditional Database Architecture: Distributed Multi-Model at Scale
Traditional database architecture often starts with a simple assumption: One database engine, one.....
#gbase#database#数据库#todayilearned
2 0
mmllllzcn6d ago • 4 min read
TIL: Columnar Compression in GBase Database(GBase 8a) Can Reach a 1:20 to 1:30 Ratio
Columnar compression isn't new technology. But when you're dealing with hundreds of terabytes or...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn6d ago • 3 min read
TIL: HTAP Is Not a Replacement for OLTP or OLAP — It's the Middle Ground
HTAP is one of the most frequently discussed database architectures today. The promise sounds...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn6d ago • 4 min read
TIL: How to Read a Database Compatibility Matrix Like a Pro
"Is it compatible with Oracle?" It's one of the first questions teams ask when evaluating a databas...
#gbase#database#数据库#todayilearned
2 0
mmllllzcnAug 13, 2026 • 2 min read
TIL: GBase Database Is Not One Product — It's Three
If you're encountering GBase Database for the first time, there is one easy mistake to...
#gbase#database#数据库#todayilearned
2 0
mmllllzcnAug 13, 2026 • 2 min read
Understanding SSC in GBase Database: Shared Storage Clustering Explained
When evaluating database architecture, "cluster" doesn't always mean distributed. GBase...
#gbase#database#数据库#beginners
2 0
mmllllzcnAug 13, 2026 • 3 min read
TIL: What Does 95% Oracle Syntax Compatibility Really Mean for GBase Database?
When evaluating an Oracle-to-GBase Database migration, one number often gets attention: 95%...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn4d ago • 5 min read
OLTP vs OLAP vs HTAP: How to Choose the Right GBase Database Product
Choosing a database should start with one question: What kind of workload are you running? OLTP,.....
#gbase#database#数据库#todayilearned
2 0
mmllllzcn4d ago • 5 min read
Shared Storage vs Shared-Nothing: How GBase Database Uses Two Architectures
When database teams discuss distributed architecture, one question often comes up: Is...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn3d ago • 4 min read
Database Fundamentals: 6 Things Every Developer Should Understand
Many developers learn databases from the application layer: INSERT SELECT UPDATE DELETE ...
#gbase#database#数据库#todayilearned
2 0
mmllllzcn6d ago • 3 min read
TIL: GBase Database(GBase 8a) Can Load 30TB of Data Per Hour
When evaluating a data warehouse, query performance gets most of the attention. But there is anothe...
#gbase#database#数据库#todayilearned
2 0
mmllllzcnAug 13, 2026 • 2 min read
TIL: How One SQL Query Can Help You Choose the Right GBase Database
You don't need a 100-page whitepaper to start evaluating GBase Database. One simple workload metric...
#gbase#database#数据库#todayilearned
2 0