DbFit
dbfit.github.io
- Free plan
- Windows
- Linux
- Web
- Self-hosted
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.