BestHub
Sign in

Databases

Showing 100 articles max
Latest Popular
dbaplus Community
dbaplus Community
Sep 20, 2026 · Databases

SQLite: The Embedded Database That Replaces Solr, MongoDB, Kafka, and More

This article argues that SQLite, often dismissed as a toy database, can replace specialized systems like Elasticsearch, MongoDB, Kafka, ClickHouse, Redis, and even microservices due to its stability, zero-configuration deployment, built-in full-text search, JSON support, vector extensions, and local-first architecture, reducing operational complexity.

CachingFTS5JSON
0 likes · 25 min read
SQLite: The Embedded Database That Replaces Solr, MongoDB, Kafka, and More
IT Architects Alliance
IT Architects Alliance
Sep 20, 2026 · Databases

Where Write Time Goes in Multi-Region Active-Active Databases

This article analyzes write latency in multi-region active-active databases like AWS Aurora DSQL, showing that local execution is only a small fraction of total latency while cross-region commit coordination dominates; it also examines optimistic concurrency control conflicts, hotspot contention, isolation level limitations, and criteria for when multi-region active-active truly benefits applications.

Aurora DSQLcommit coordinationhotspot contention
0 likes · 12 min read
Where Write Time Goes in Multi-Region Active-Active Databases
IT Services Circle
IT Services Circle
Sep 20, 2026 · Databases

MySQL 8 Timezone Bug Exposed: Why Timestamps Shift Before 8.0.23

This article details MySQL Connector/J's timezone handling bug in versions 8.0.0-8.0.22, explains key JDBC parameters like serverTimezone and preserveInstants, and provides best-practice configurations to avoid timestamp shifts and zero-date errors when upgrading from MySQL 5.1.

Best PracticesConnector/JJDBC
0 likes · 16 min read
MySQL 8 Timezone Bug Exposed: Why Timestamps Shift Before 8.0.23
Code Farmer Manor Chronicle
Code Farmer Manor Chronicle
Sep 20, 2026 · Databases

One SQL to Generate 2000 Test Rows: Stop Hand-Writing VALUES

Learn how to generate 2000 test rows in PostgreSQL using a single INSERT...SELECT with generate_series, deriving column values via series numbers, zero-padding with LPAD, explicit timestamps, and ON CONFLICT for idempotent execution, plus random data variations and MySQL equivalents.

INSERT SELECTKingBaseESLPAD
0 likes · 8 min read
One SQL to Generate 2000 Test Rows: Stop Hand-Writing VALUES
Cloud Architecture
Cloud Architecture
Sep 19, 2026 · Databases

Beyond COUNT_STAR=0: Auditable MySQL Index Removal with performance_schema

This article presents a rigorous, production-ready framework for MySQL index governance that moves beyond simplistic zero-usage checks, using performance_schema observation windows, structural gatekeeping, invisible index canary testing, and quantified rollback metrics to safely identify and remove redundant indexes without risking query regressions.

ObservabilitySQL Tuningdatabase administration
0 likes · 29 min read
Beyond COUNT_STAR=0: Auditable MySQL Index Removal with performance_schema
Cloud Architecture
Cloud Architecture
Sep 18, 2026 · Databases

From Ad-Hoc Indexing to Verifiable Governance: MySQL Index Governance at Scale

This article details a production-grade MySQL index governance system for high-concurrency e-commerce, covering evidence collection, invisible index validation, automated change gates, regression detection, and a case study reducing order-list P99 from 2.3s to 170ms while preventing unsafe deletions.

Online DDLe-commercehigh concurrency
0 likes · 38 min read
From Ad-Hoc Indexing to Verifiable Governance: MySQL Index Governance at Scale
Smart Sea Tide
Smart Sea Tide
Sep 18, 2026 · Databases

6 Core Data Quality Metrics for Robust Data Governance

This article outlines six fundamental data quality metrics—accuracy, completeness, consistency, timeliness, uniqueness, and validity—detailing their focus areas and measurement approaches, and illustrates how a monitoring dashboard with radar charts and trend analysis can track a 92.1 composite score, 96.3% compliance rate, 8.7% daily issue reduction, and 268% ROI, emphasizing that sustained quality requires standards, organization, processes, technology, and continuous improvement.

ROIdata governancedata management
0 likes · 3 min read
6 Core Data Quality Metrics for Robust Data Governance
Cloud Architecture
Cloud Architecture
Sep 17, 2026 · Databases

Indexes Aren't Free: Production Index Governance for High-Write Order Systems

This article presents a comprehensive index governance methodology for high-write MySQL order systems, demonstrating through a real incident how a read-optimized index caused write latency, replica lag, and timeouts, and detailing a reusable process covering query-driven design, cost measurement, validation, change buffer limits, index convergence, safe deletion, read-write routing, sharding, transactional outbox, idempotent consumers, online DDL safeguards, gating, and long-term ownership.

Capacity PlanningChange BufferDescending Indexes
0 likes · 29 min read
Indexes Aren't Free: Production Index Governance for High-Write Order Systems
Raymond Ops
Raymond Ops
Sep 17, 2026 · Databases

MySQL & PostgreSQL Monitoring: Critical Metrics & Alert Thresholds Explained

This comprehensive guide covers MySQL and PostgreSQL monitoring essentials, including key metrics (connections, throughput, InnoDB, replication), version-specific differences, alert thresholds, exporter deployment (mysqld_exporter, postgres_exporter), Grafana dashboards, Prometheus alerting rules, troubleshooting playbooks for common issues like connection exhaustion, replication lag, deadlocks, and disk growth, plus automation scripts for long-transaction killing and slow-query analysis.

AlertingDatabase MonitoringExporters
0 likes · 74 min read
MySQL & PostgreSQL Monitoring: Critical Metrics & Alert Thresholds Explained
Shuge Unlimited
Shuge Unlimited
Sep 16, 2026 · Databases

Why Milvus 3.0 Pagination Breaks After Reranking: When Cursor Scores Cross Worlds

Milvus 3.0's search iterator pagination fails after reranking because the cursor uses the last page's score as a boundary, but reranking replaces ANN distances with model predictions (e.g., XGBoost raw scores), causing the filter condition to exclude nothing and return duplicate pages. Milvus now explicitly rejects combining function chains with search iterators rather than fixing pagination, as the fix would require carrying original distances through the entire reduce pipeline—a feature-level change. Workarounds include using offset within single-search limits or moving reranking to the application layer.

MilvusRerankingXGBoost
0 likes · 21 min read
Why Milvus 3.0 Pagination Breaks After Reranking: When Cursor Scores Cross Worlds
IT Architects Alliance
IT Architects Alliance
Sep 16, 2026 · Databases

Firebolt's Microservices Rollback: Lessons on Deployment, Coordination & Fault Isolation

Firebolt consolidated previously independent metadata, identity, and garbage-collection services into its core database process to simplify multi-environment deployment and reduce cross-service coordination, while analyzing trade-offs in fault isolation, resource contention, and the distinction between module and process boundaries.

DeploymentFireboltRefactoring
0 likes · 10 min read
Firebolt's Microservices Rollback: Lessons on Deployment, Coordination & Fault Isolation
Cloud Architecture
Cloud Architecture
Sep 16, 2026 · Databases

When Indexes Become Write Killers: MySQL Order Table Write Performance Collapse Postmortem

Adding three secondary indexes to a MySQL 8.0 orders table caused write P99 latency to jump from 15ms to 2.3s and TPS to drop from 4800 to 1100 during peak hours; the article details a reproducible forensic process using A/B testing, invisible indexes, and sysbench to prove the culprit index had zero read benefit and safely remove it.

A/B testingInnoDBMySQL 8.0
0 likes · 23 min read
When Indexes Become Write Killers: MySQL Order Table Write Performance Collapse Postmortem
liandk
liandk
Sep 16, 2026 · Databases

Slow SQL Full-Chain Troubleshooting: Execution Plans, Index Failures & Lock Contention

This comprehensive guide covers the complete slow SQL troubleshooting lifecycle: enabling slow query logs, interpreting EXPLAIN plans, diagnosing nine common index failure patterns, resolving transaction lock contention, and applying architectural optimizations for large datasets, plus emergency mitigation and long-term governance practices.

Index OptimizationSQL TuningSlow SQL
0 likes · 16 min read
Slow SQL Full-Chain Troubleshooting: Execution Plans, Index Failures & Lock Contention
Xiaolin Talks Programming
Xiaolin Talks Programming
Sep 16, 2026 · Databases

PostgreSQL JSONB with Spring Boot: Handle Custom Fields Without MongoDB

This article demonstrates how PostgreSQL's JSONB type combined with Spring Boot provides a practical alternative to MongoDB for managing dynamic custom fields in enterprise applications, covering storage, indexing, JPA mapping, partial updates, querying patterns, and performance tuning while preserving relational integrity.

Cursor PaginationGIN IndexHibernate
0 likes · 21 min read
PostgreSQL JSONB with Spring Boot: Handle Custom Fields Without MongoDB
StarRocks
StarRocks
Sep 15, 2026 · Databases

StarRocks AI Function: Embedding LLM Inference into the SQL Execution Pipeline

StarRocks introduces AI Functions that let SQL directly call LLMs for generation, classification, extraction, and embedding, integrating model inference into the query optimizer and pipeline execution engine with async dual-pipeline architecture, backpressure, and cost-based optimization to reduce unnecessary calls and manage latency.

AI FunctionLLM InferenceSQL execution engine
0 likes · 25 min read
StarRocks AI Function: Embedding LLM Inference into the SQL Execution Pipeline
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Sep 15, 2026 · Databases

ZestKV: 360's Cloud-Native Serverless KV Store with Compute-Storage Separation

360 Zhihui Cloud's ZestKV is a Redis-compatible, cloud-native serverless KV store that separates compute from storage using shared object storage and a log service, enabling elastic scaling via region sharding, background task decoupling, and a dual-async write path achieving 700K SET QPS in benchmarks.

Cloud-Native DatabaseCompute-Storage SeparationElastic Scaling
0 likes · 24 min read
ZestKV: 360's Cloud-Native Serverless KV Store with Compute-Storage Separation