Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

DbFit

dbfit.github.io

  • Free plan
  • Windows
  • Linux
  • Web
  • Self-hosted
7.7 Club score Visit dbfit.github.io

What DbFit is

DbFit is a free, open-source framework for writing unit and integration tests for database code. It uses table-based tests, which the project describes as more readable than xUnit-style formats, and tables can be authored in Excel or another spreadsheet program before being copied into FitNesse. Documented test types include unit, data-diff, invariant, schema, and timing tests. Tests can run from the command line, a Java IDE, or a CI build tool. DbFit is built on FitNesse, which supplies the test framework, HTTP server, and wiki editing interface. Listed database support covers Oracle, SQL Server, MySQL, Postgres, Derby, HSQLDB, Sybase, DB2, Teradata, Netezza, and Informix across Java and FitSharp implementations. The runtime requires Java, and setup starts FitNesse locally for browser access at localhost. DbFit includes an encrypted-password utility, but its documentation says the keystore uses a password hard-coded in the binary and should have restrictive file permissions. Row comparison is described as suitable for datasets under 10K rows, while procedure timing can be inaccurate because execution adds 1–2 seconds of overhead.

Who it suits

DbFit suits developers and database teams writing readable, self-hosted tests for database code. It is relevant to Java or .NET environments using command-line, IDE, or CI execution.

Good to know, and what to watch

  • Free and open source under GPL
  • Table-based tests support readable authoring
  • Supports unit, schema, invariant, and timing tests
  • Runs from command line, IDE, or CI
  • Lists broad database support
  • Row comparison suits datasets under 10K rows
  • Timing tests add 1–2 seconds overhead
  • SQL Server and Teradata drivers require separate installation
  • Requires the Java Runtime Environment

The verdict

DbFit provides table-oriented database testing through FitNesse, with multiple test types and broad listed database support. Its documentation sets clear boundaries around large row comparisons, timing precision, driver installation, and password-keystore protection.

What the maker publishes

Database support
The feature page lists Oracle, SQL Server, MySQL, Postgres, Derby, HSQLDB, Sybase, DB2, Teradata, Netezza, and Informix across its Java and FitSharp implementations. source
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. source
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. source
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. source
Execution
Tests can be run from the command line, a Java IDE, or a CI build tool. source
Execution
Tests can run from the command line, a Java IDE, or a CI build tool. source
License
DbFit is free and open source under the GPL license. source
License
DbFit is free and open source under the GPL license; its GitHub repository specifies GNU General Public License version 2. source
Local interface
The setup guide starts FitNesse locally and directs users to open http://localhost:8085/ in a browser. source
Maintainers
The project documentation describes separate maintainers for FitNesse, DbFit/Java, and DbFit/FitSharp rather than one unified maintainer group. source
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. source
Password handling
DbFit includes an encrypt utility for storing encrypted database passwords, but the documentation says the keystore uses a password hard-coded into the DbFit binary and should be protected with restrictive file permissions. source
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. source
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. source
Purpose
DbFit is a database testing framework for writing readable, maintainable unit and integration tests for database code. source
Purpose
DbFit is a framework for writing readable, maintainable unit and integration tests for database code. source
Runtime
The getting started guide says DbFit needs the Java Runtime Environment and describes launching it with a Windows batch file or a Linux shell script. source
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. source
Setup model
The guide starts FitNesse locally and directs the user to open localhost in a browser to create and run test pages. source
Spreadsheet authoring
Tests can be authored in Excel or another spreadsheet program and copied into FitNesse as tab-separated tables. source
Spreadsheet authoring
Test tables can be copied from Excel or other spreadsheet programs into FitNesse and converted from tab-separated data. source
Support
The project directs users to its forum for questions and discussion and to its issue tracker for bug reports and feature requests. source
Support
The contact page directs questions to the project forum and feature requests or bug reports to the issue tracker. source
Test authoring
Tests use tables, which the maker describes as more readable than xUnit-style tests. source

Checked against the maker's pages on 3 Oct 2026.