DbFit

Spec sheet

Purpose

DbFit is a framework for writing readable, maintainable unit and integration tests for database code.Read 3 Oct 2026 · dbfit.github.io

Support

The contact page directs questions to the project forum and feature requests or bug reports to the issue tracker.Read 3 Oct 2026 · dbfit.github.io

License

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

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.Read 3 Oct 2026 · dbfit.github.io

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.Read 3 Oct 2026 · dbfit.github.io

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.Read 2 Oct 2026 · dbfit.github.io

Execution

Tests can run from the command line, a Java IDE, or a CI build tool.Read 3 Oct 2026 · dbfit.github.io

Local interface

The setup guide starts FitNesse locally and directs users to open http://localhost:8085/ in a browser.Read 2 Oct 2026 · dbfit.github.io

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.Read 3 Oct 2026 · dbfit.github.io

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.Read 3 Oct 2026 · dbfit.github.io

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.Read 3 Oct 2026 · dbfit.github.io

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.Read 3 Oct 2026 · dbfit.github.io

Setup model

The guide starts FitNesse locally and directs the user to open localhost in a browser to create and run test pages.Read 3 Oct 2026 · dbfit.github.io

Spreadsheet authoring

Test tables can be copied from Excel or other spreadsheet programs into FitNesse and converted from tab-separated data.Read 3 Oct 2026 · dbfit.github.io

Test authoring

Tests use tables, which the maker describes as more readable than xUnit-style tests.Read 3 Oct 2026 · dbfit.github.io

Test environment caution

The guide says unit tests that overwrite or truncate data require a development environment where doing so is acceptable.Read 3 Oct 2026 · dbfit.github.io

Test format

DbFit tests use tables, which the project describes as more readable than xUnit-style tests.Read 2 Oct 2026 · dbfit.github.io

Test types

The documentation describes unit, data-diff, invariant, schema, and timing tests.Read 3 Oct 2026 · dbfit.github.io

Underlying framework

DbFit is built on FitNesse, which provides the test framework, HTTP server, and wiki editing interface.Read 2 Oct 2026 · dbfit.github.io

Where Specifiction places it

• Database Testing Tools#18 of 287.4
• Integration Testing Tools#20 of 267.5