Open Source Software Testing Tools

When testing using a database with rollback after each test, failing tests are very hard to resolve. Data Storm is a simple DB viewer directly launchable from within your test code to enable you to inspect the current state of the database.

Ingres Dynamic Playback is a tool to play back prerecorded SQL statements to do functional and stress testing on the Ingres Database. More information here: http://community.ingres.com/wiki/Dynamic_Playback

Orate is a source-level tracing facility for Oracle PL/SQL. Programmers insert calls to Orate in the code and Orate captures and writes run time information to a table. These data are suitable for debugging, testing and profiling the application.

The csvdatamix project aims to randomize CSV input data files in order to conceal the original state of the data. Similar to data masking or data transformation. Also has mapping abilities to translate back to the original state of the data.

DB Sanity performs checks on a database for verifying data consistency and correctness of aplication deployments. It is invoked by command line and creates an HTML report with aggregated diagnostic summaries and listings of faulty database entries.

DBD2 inserts database records from TCP input. It is a companion project to Syslgod2 and an application in its own right. It ships with a backgrounding client for generic use. The client sends whatever information the user puts on the command-line to the back-end daemon via TCP. Upon successful transmission, the client exits. On failure, it backs off and retries until its life-time timer expires. The back-end daemon accepts data from Syslogd2 or its own client and inserts that data (and envelope information) into one or more databases using MySql client library or dbi drivers (also on SourceForge). The client needs no configuration (all input is via command-line). It is intended for hosts to make database entries without needing database client or interface code. Syslogd2 integration allows DBD2 to act as Syslogd2's database back-end for MySql and other databases supported by the dbi drivers. Original purpose was to track Linux cluster job status but other uses exist.

DBFeeder is a great tool to generate synthetic testdata for Oracle Databases and it is ideal for companies who wants to outsource development. Thanks to his original approach, data can be highly customizable and it even fits primary and foreign keys constraints of tables.

Database unit testing for .Net - MS SQL, MySQL, Oracle. Includes a database testing dll/API, an example project with C# templates to help get started, sql helper scripts and an application to export XML from a database. Features include - testing data outputs, sql objects definitions and security requirements. See http://dbtestunit.wordpress.com/ for more detail.

A small database stress tool written in Java. Emulates a given number of concurrent users querying the engine. Reports timing information for each test. Currently supports MySQL engine only.

The Unofficial Home to JSR 272 Mobile TV API Tests and Evaluation --- PROVIDED AS IS, FOR EVALUATION PURPOSE ONLY. NO CLAIM OF CONFORMANCE OR ENDORSEMENT FROM JSR 272 GROUP. --- JSR 272 IS LICENSED BY NOKIA AND MOTOROLA. PLEASE CHECK TERMS AND CONDIT

Database and csv files comparison tool

Collaborative project between academic medical centers to develop rich internet applications. The products of this collaboration will be shared with other institutions.

A fully automated database benchmark suite that prints tabular and graphic results for multiple tested disciplines, given JDBC database connections. Some free open source database engines are included.

S3 Mockup is an Amazon S3 emulator we develop for one of our projects. It can be easy embedded and used in your test framework or running as an independent service. Using this emulator you can easy setup development and QA environment.

Speed and stress test for MySQL and MSSQL servers.

SnapDAL for .Net is a combination of a data access helper and a Factory that supports the use of the generic ADO.net interfaces. It is also integrated with the unit testing framework, .NET MockObjects, which supply mock implementations for ADO.net.

Toplink in memory makes TDD possible in large database applications. Make your Java project tests run faster. Toplink in memory allows you to run your tests in memory, rather than against a database. In our current project, this gives a 100x speed up.

This open source software benchmarks the queries per second of an Apache Lucene index. It is an Java implementation and uses MultiFieldQueryParser to form a query.

Datamixer generates mock data values for various datatypes, including integer, floating precision, datetime, and string. It can generate complex sequences, based on functions and permutations of the basic data series.

Data generator tool which supports many data types (primitive data types,but also names,addresses,post codes,etc.) and generates data in various formats (text,xml,db).It provides a GUI and is extensible by means of plugging-in new data-generator classes.