BestHub
Sign in
Tagged articles

Database Testing

21 articles · Page 1 of 1
Xiaolin Talks Programming
Xiaolin Talks Programming
Jul 1, 2026 · Backend Development

High-Fidelity Integration Testing: Spring Boot & Testcontainers in Production Pipelines

This article shares practical experience migrating Spring Boot integration tests to Testcontainers, covering database migration with Flyway, test data factories, multi-container networking, performance optimization via container reuse and parallel execution, CI pipeline integration, and team conventions for test layering and mutation testing.

CI/CDDatabase TestingDocker
0 likes · 19 min read
High-Fidelity Integration Testing: Spring Boot & Testcontainers in Production Pipelines
Woodpecker Software Testing
Woodpecker Software Testing
Apr 9, 2026 · Backend Development

Iterative Debugging of AI‑Generated Test Cases and Scripts (Part 4)

The article outlines a lightweight AI‑agent workflow that iteratively refines Python‑based Playwright/pytest test scripts by combining human review with AI‑generated suggestions, shows the exact system and user prompts, and provides a complete runnable example with database setup, request handling, and a failing test case to illustrate the debugging loop.

AI AgentDatabase TestingPlaywright
0 likes · 12 min read
Iterative Debugging of AI‑Generated Test Cases and Scripts (Part 4)
Advanced AI Application Practice
Advanced AI Application Practice
Nov 14, 2025 · Fundamentals

How to Verify Data Correctness Without Knowing SQL

When UI checks can be misleading, this guide shows testers three practical ways—getting ready‑made queries from developers, using friendly graphical database clients, and mentally mapping UI actions to DB changes—to directly validate data in the database without deep SQL expertise.

Database TestingGUI database clientQA
0 likes · 7 min read
How to Verify Data Correctness Without Knowing SQL
Wukong Talks Architecture
Wukong Talks Architecture
Jul 25, 2025 · Databases

Testing T‑SQL Compatibility in KingbaseES: Key Findings and Tips

This article walks through installing KingbaseES's SQL Server compatible edition, evaluates core T‑SQL features such as GO, PRINT, RAISERROR, THROW, statement terminators, and trailing commas in CREATE TABLE, provides practical code examples, and offers solutions to common Windows installation errors.

Database TestingKingbaseESSQL
0 likes · 15 min read
Testing T‑SQL Compatibility in KingbaseES: Key Findings and Tips
FunTester
FunTester
May 19, 2024 · Databases

Essential Database Testing Checklist: From CRUD to Performance Optimization

This guide outlines comprehensive database testing practices, covering relational and non‑relational types, CRUD validation, index and view checks, empty‑database scenarios, data integrity, design principles, stress testing, and detailed SQL optimization techniques with concrete examples and code snippets.

Database TestingDesign GuidelinesIndexing
0 likes · 12 min read
Essential Database Testing Checklist: From CRUD to Performance Optimization
FunTester
FunTester
Nov 8, 2022 · Databases

Comprehensive Guide to Database Testing: Concepts, Techniques, and Best Practices

Database testing ensures data integrity, security, and quality by validating data mapping, ACID properties, schema, triggers, stored procedures, and field constraints through both manual and automated methods, using SQL queries, CRUD operations, and specialized tools to verify that applications interact correctly with underlying databases.

ACIDDatabase TestingSQL
0 likes · 13 min read
Comprehensive Guide to Database Testing: Concepts, Techniques, and Best Practices
dbaplus Community
dbaplus Community
Jul 17, 2022 · Databases

Can GitLab Run on Distributed Databases? CockroachDB vs YugabyteDB Evaluation

This article evaluates GitLab's compatibility with two PostgreSQL‑compatible distributed databases, CockroachDB and YugabyteDB, by setting up identical environments, running the GitLab setup process, documenting failures and successes, and drawing conclusions about extension support, index compatibility, and overall feasibility.

CockroachDBDatabase TestingGitLab
0 likes · 12 min read
Can GitLab Run on Distributed Databases? CockroachDB vs YugabyteDB Evaluation
dbaplus Community
dbaplus Community
Mar 7, 2022 · Databases

How to Prevent Null, Type, and Charset Pitfalls in Oracle‑to‑ADB Data Sync

This article details the common pitfalls encountered when synchronizing Oracle databases to AnalyticDB PostgreSQL, covering null versus empty string handling, data type conversion challenges, character set issues, special character processing, and comprehensive testing strategies to ensure data consistency and performance.

AnalyticDBDatabase TestingNull Handling
0 likes · 17 min read
How to Prevent Null, Type, and Charset Pitfalls in Oracle‑to‑ADB Data Sync
Programmer DD
Programmer DD
Sep 12, 2021 · Databases

Why Does Alibaba’s Java Handbook Ban Joins Over Three Tables? A Deep Dive with Massive Data Tests

This article investigates the Alibaba Java Development Manual’s rule against joining more than three tables by designing and running large‑scale MySQL and Oracle experiments, analyzing performance impacts, presenting test results with and without indexes, and providing full DDL/DML scripts for reproducing the tests.

Database TestingJOIN optimizationLarge Dataset
0 likes · 12 min read
Why Does Alibaba’s Java Handbook Ban Joins Over Three Tables? A Deep Dive with Massive Data Tests
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 23, 2021 · Databases

Testing Remote Backup Capability of MySQL Enterprise Backup (mysqlbackup) 4.0

This article documents a practical test of MySQL Enterprise Backup 4.0, examining whether the tool can perform remote physical backups using the --host option, describing the test environment, commands, observed behaviours for both local and remote scenarios, and the conclusions drawn from the results.

Database TestingMySQLMySQL Enterprise Backup
0 likes · 6 min read
Testing Remote Backup Capability of MySQL Enterprise Backup (mysqlbackup) 4.0
Qunar Tech Salon
Qunar Tech Salon
Feb 17, 2020 · Databases

Automated Bug Detection for Distributed Databases Using Statistical Code Path Analysis

The article describes a prototype system that automatically discovers bugs in large distributed databases by instrumenting code, generating massive SQL test cases, statistically analyzing execution paths, visualizing suspicious blocks, and integrating insights from academic papers to guide future debugging and testing efforts.

Database TestingPerformance RegressionSQL fuzzing
0 likes · 11 min read
Automated Bug Detection for Distributed Databases Using Statistical Code Path Analysis
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 27, 2019 · Databases

Using dbdeployer to Quickly Set Up MySQL Test Environments

This guide introduces the dbdeployer tool, walks through its installation on macOS/Linux, shows how to configure sandbox paths, download MySQL binaries, and deploy various MySQL topologies such as single nodes, master‑slave replication, and group replication with one‑click commands.

Database TestingMySQLautomation
0 likes · 10 min read
Using dbdeployer to Quickly Set Up MySQL Test Environments
360 Tech Engineering
360 Tech Engineering
Sep 7, 2018 · Databases

Using Bash Shell Scripts for Automated Database Testing

This article explains how to leverage simple Bash shell scripts to automate database testing tasks such as creating, inserting, updating, and monitoring tables in MySQL, providing step‑by‑step guidance, code examples, and best practices for efficient test automation.

Database TestingScriptShell
0 likes · 8 min read
Using Bash Shell Scripts for Automated Database Testing
360 Quality & Efficiency
360 Quality & Efficiency
Aug 10, 2018 · Databases

Automating MySQL Database Testing with Shell Scripts

This article explains how to use Bash shell scripts on Linux to automate MySQL database testing tasks such as creating tables, inserting, updating, and monitoring dynamic database states, providing step‑by‑step code examples and execution instructions for efficient test automation.

Database TestingLinuxMySQL
0 likes · 7 min read
Automating MySQL Database Testing with Shell Scripts
Meituan Technology Team
Meituan Technology Team
Jul 14, 2017 · Databases

How to Accelerate Database Testing with Sysbench: Insights and Extensions

This article explains how Meituan‑Dianping leverages the open‑source tool Sysbench for repeatable database performance testing, unifies test parameters, optimizes MySQL settings such as slave_parallel_workers, extends functionality via Lua scripts, and reveals the tool’s high‑performance data‑collection techniques.

Database TestingLua scriptingMySQL
0 likes · 13 min read
How to Accelerate Database Testing with Sysbench: Insights and Extensions
dbaplus Community
dbaplus Community
Mar 10, 2016 · Databases

How to Build a COW Test Database with Oracle 12c ACFS Snapshots

This guide walks through adding ASM disks, creating an ACFS filesystem, building a RAC database on it, generating read‑only and read‑write snapshots while running DML, and cloning a second database from those snapshots, including optional Data Guard usage for zero‑impact testing.

12cACFSCOW
0 likes · 14 min read
How to Build a COW Test Database with Oracle 12c ACFS Snapshots