Open Source Software Testing Tools

sysbench is a scriptable multi-threaded benchmark tool based on LuaJIT. It is most frequently used for database benchmarks, but can also be used to create arbitrarily complex workloads that do not involve a database server. extensive statistics about rate and latency is available, including latency percentiles and histograms. Low overhead even with thousands of concurrent threads. sysbench is capable of generating and tracking hundreds of millions of events per second. New benchmarks can be easily created by implementing pre-defined hooks in user-provided Lua scripts. Can be used as a general-purpose Lua interpreter as well, simply replace #!/usr/bin/lua with #!/usr/bin/sysbench in your script. Execute events for this many seconds with statistics disabled before the actual benchmark run with statistics enabled. This is useful when you want to exclude the initial period of a benchmark run from statistics.

Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets.

Cinemagoer is a Python package useful to retrieve and manage the data of the IMDb movie database about movies, people, characters and companies. Platform-independent, it can retrieve data from both the IMDb's web server and a local copy of the whole db.

What we introduce in Growth is just a series of practices, and the actual combat of Growth will lead readers to implement these practices. You will see how to develop a web application (blog). How to write tests - unit tests, functional tests, automated UI tests. Build and use continuous integration. Added SEO support - Sitemap, Webmaster Tools and Google Analytics. Create API, make AutoComplete. Develop the corresponding APP and its API - view articles, user login, publish articles. Make a Single Page Application. Configurable management.

dbUnit is a JUnit extension targeted for database-driven projects that, among other things, puts your database into a known state between test runs.

dbMonster is a tool which generates random test data and puts it into SQL database. It helps to test how an application can deal with large database.

Our objective: to provide a unit testing framework for PL/SQL developers modeled on the Junit and Xunit frameworks. Based on the Extreme Programming methodology, utPLSQL makes it easy for developers to set up and execute unit tests of packages. Active development of this project is now on GitHub

The project moved to GitHub, https://github.com/aevdokimenko/tsqlunit TSQLUnit is a framework to write tests for applications written in Transact-SQL. It follows the tradition of the "xUnit" framework that is available for almost all programming languages.

"It's not a tool, which fixes a problem, but the fool using it!" (Jörg Stryk) The M7 bunch of scripts should help the EXPERIENCED Troubleshooter to quickly identify bottlenecks and to develop/implement appropriate solutions. "With great power comes great responsibility" (Uncle Ben)

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.

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.

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.

Please note the project has moved to GitHub, see http://benilovj.github.com/dbfit DbFit is a set of fixtures which enables FIT/FitNesse tests to execute directly against a database, enabling developers to manipulate database objects in a relational form, making database TDD much easier then with xUnit-style tools.

Firebird 2.5 is required at least Monitor and trace Firebird activity on Windows and Linux. Let DBA to get the traces and send them to you when you can't access to production server. Watch query duration and plan.

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

This project is a java web application developer toolbox. It is among other, a simple and powerful framework which does not require dealing with XML files. It also provides a lot of other features, such as a DB abstraction layer, a nice javadoc doclet, a

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.

What is Aurora Phishing Aurora Phishing is an Package with Online Web Services like Facebook, Gmail, Twitter ripped websites used for Phishing Attack. This project was started by Croatian Security Engineer Dalibor Vlaho as a part of another project

CUBRID QA project contains a test-automation tool and many kinds of test cases for CUBRID database.

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.

Eclipse Documentum DQL/API plug-in with the main functionality of content proposals and colour coding. As a secondary result testing things the plug-in is starting to resemble a fast hard client. A feature we lost when a certain hard client was replaced.

Dage is an extensible library for filling database with a random data. Specifications are written in Scala language.

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.

Fill your database with test data, move in and be happy. DataRoller is a small program that will insert rows into your database based on a file describing your tables and columns. Script files describe how each table relates to other tables, how DataRoller should geneate foreign keys, and how each column should look. DataRoller executes your script file, generating insert statements and filling your database with data.