DbFit

What it does

Database support

The features page lists Oracle, SQL Server, MySQL, Postgres, Derby, HSQLDB, Sybase, DB2, Teradata, Netezza, and Informix, with support varying between Java and FitSharp implementations.checked 3 Oct 2026

Data-diff limit

The documentation says DbFit's row comparison is suitable for small datasets under 10K rows and does not scale beyond that point; it recommends pushing larger comparisons into the database.checked 3 Oct 2026

Driver limits

The SQL Server and Teradata JDBC drivers are not open source and cannot be distributed with DbFit, so users must obtain and install them separately.checked 2 Oct 2026

Execution

Tests can run from the command line, a Java IDE, or a CI build tool.checked 3 Oct 2026

License

DbFit is free and open source under the GPL license; its GitHub repository specifies GNU General Public License version 2.checked 3 Oct 2026

Local interface

The setup guide starts FitNesse locally and directs users to open http://localhost:8085/ in a browser.checked 2 Oct 2026

Maintainers

The project page identifies Jake Benilov as the copyright holder, while the team page describes multiple maintainers across the project's components and branches.checked 3 Oct 2026

Password handling

DbFit includes an encrypt utility for database passwords, but its documentation warns that the keystore is protected by a password hard-coded into the binary and should have restrictive file permissions.checked 3 Oct 2026

Performance test limit

The documentation says procedure execution through DbFit adds 1–2 seconds of overhead, making timing tests inaccurate for procedures that finish quickly.checked 3 Oct 2026

Purpose

DbFit is a framework for writing readable, maintainable unit and integration tests for database code.checked 3 Oct 2026

Runtime

The getting-started guide says DbFit needs the Java Runtime Environment and describes starting FitNesse using a Windows batch file or a Linux shell script.checked 3 Oct 2026

Setup model

The guide starts FitNesse locally and directs the user to open localhost in a browser to create and run test pages.checked 3 Oct 2026

Spreadsheet authoring

Test tables can be copied from Excel or other spreadsheet programs into FitNesse and converted from tab-separated data.checked 3 Oct 2026

Support

The contact page directs questions to the project forum and feature requests or bug reports to the issue tracker.checked 3 Oct 2026

Test authoring

Tests use tables, which the maker describes as more readable than xUnit-style tests.checked 3 Oct 2026

Test environment caution

The guide says unit tests that overwrite or truncate data require a development environment where doing so is acceptable.checked 3 Oct 2026

Test format

DbFit tests use tables, which the project describes as more readable than xUnit-style tests.checked 2 Oct 2026

Test types

The documentation describes unit, data-diff, invariant, schema, and timing tests.checked 3 Oct 2026

Underlying framework

DbFit is built on FitNesse, which provides the test framework, HTTP server, and wiki editing interface.checked 2 Oct 2026