Tagged articles
Database Testing
21 articles · Page 1 of 1
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

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

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

Learn how to rapidly set up an Oracle RAC testing cluster using VirtualBox and Vagrant, covering the reasons for avoiding Docker, required software versions, Vagrantfile configuration, shared disk creation, network setup, and step‑by‑step commands to launch and access the virtual machines.
Database TestingOracle RACVagrant
0 likes · 10 min read

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

This article demonstrates how to wrap MySQL database connections, create reusable assertion functions, parameterize test cases, validate JSON responses, and integrate logging with Loguru to build a maintainable and efficient Pytest‑based API automation framework.
Database TestingLogurujson assertion
0 likes · 6 min read

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 GuidelinesSQL Optimization
0 likes · 12 min read

This article demonstrates how the MySQL LIKE clause can give misleading results when filtering triggers, walks through a step‑by‑step lab that creates tables and triggers, shows the pitfalls of LIKE, and presents a safer WHERE‑based method for retrieving trigger definitions.
Database TestingLIKE clauseMyDumper
0 likes · 7 min read

This article introduces five common Python automated testing scenarios—unit testing, API testing, web UI testing, performance testing, and database testing—providing clear explanations and complete code examples to help developers improve software quality and stability.
API TestingDatabase TestingPython
0 likes · 7 min read

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

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

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

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 TestingLarge DatasetOracle
0 likes · 12 min read

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

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

This article provides a comprehensive overview of the MySQL Test Run (MTR) framework, detailing its two-part architecture consisting of Perl scripts for control flow and C++ binaries for test execution, along with the complete execution process and framework design.
C++ executionDatabase TestingMTR framework
0 likes · 4 min read

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

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 TestingScriptautomation
0 likes · 8 min read

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

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

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
