On the recordRead 3 Oct 202619 facts
DbFit
On the record
- 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.dbfit.github.io · read 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.dbfit.github.io · read 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.dbfit.github.io · read 2 Oct 2026
- Execution
- Tests can run from the command line, a Java IDE, or a CI build tool.dbfit.github.io · read 3 Oct 2026
- License
- DbFit is free and open source under the GPL license; its GitHub repository specifies GNU General Public License version 2.github.com · read 3 Oct 2026
- Local interface
- The setup guide starts FitNesse locally and directs users to open http://localhost:8085/ in a browser.dbfit.github.io · read 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.dbfit.github.io · read 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.dbfit.github.io · read 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.dbfit.github.io · read 3 Oct 2026
- Purpose
- DbFit is a framework for writing readable, maintainable unit and integration tests for database code.dbfit.github.io · read 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.dbfit.github.io · read 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.dbfit.github.io · read 3 Oct 2026
- Spreadsheet authoring
- Test tables can be copied from Excel or other spreadsheet programs into FitNesse and converted from tab-separated data.dbfit.github.io · read 3 Oct 2026
- Support
- The contact page directs questions to the project forum and feature requests or bug reports to the issue tracker.dbfit.github.io · read 3 Oct 2026
- Test authoring
- Tests use tables, which the maker describes as more readable than xUnit-style tests.dbfit.github.io · read 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.dbfit.github.io · read 3 Oct 2026
- Test format
- DbFit tests use tables, which the project describes as more readable than xUnit-style tests.dbfit.github.io · read 2 Oct 2026
- Test types
- The documentation describes unit, data-diff, invariant, schema, and timing tests.dbfit.github.io · read 3 Oct 2026
