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

Recent releases

  •  21 Nov 2012 15:36

    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.

    •  11 Apr 2012 15:57

      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 16:11

        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.

        •  14 Nov 2011 14:27

          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 11:08

            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 Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.