Projects / DB Sanity

DB Sanity

DB Sanity performs checks on a database for verifying data consistency and correctness of aplication deployments. It is invoked by the command line and creates an HTML report with a summary and listings of faulty database entries.

Operating Systems

RSS Recent releases

  •  22 Nov 2012 03:15

Release Notes: This is a bugfix release. In CSV files, null values and empty strings are now recognized correctly. In HTML reports, relative paths are used.

Release Notes: This release adds several new checking features: multi-column validator support, multicolumn-validation against reference data sets (exact set/sub set/super set) in CSV or Excel(TM) files, trim checking, and verification of alternative foreign key paths between two tables. All known bugs have been fixed.

  •  29 Nov 2011 22:31

    Release Notes: Tag clouds show at a glance which checks were executed and which where the most defective ones. A hierarchy provider interface allows for custom definition of hierarchical grouping mechanisms; one provided implementation uses checks to specify tree paths. DatabeneScript expressions can be used to employ a subset of the Java syntax for instantiating plugins. The InfoModule provides more extensive information, and all known bugs were fixed.

    •  15 Nov 2011 00:01

    Release Notes: This release provides some minor bugfixes in report rendering and navigation. Copying reports with long nested structures is made less problematic by reducing the length of the report file paths. During check execution, the user gets feedback about the number of completed and pending checks.

    •  07 Nov 2011 21:34

    Release Notes: The new version adds more predefined check types which can be used to verify database tables without SQL knowledge, custom Java validator classes which can be plugged in to perform more sophisticated client-side (or cross-system) checking. Existing functionality has been undergone additional testing, stabilization, and simplification.


    Project Spotlight


    A photo editing and collection management application.


    Project Spotlight


    A basic image difference viewer.