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.

Tags
Licenses
Operating Systems
Implementation

RSS Recent releases

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.

    •  21 Oct 2011 20:31

    Release Notes: The application version can now be automatically retrieved from a database by a SQL query or from a custom Java component. New features can reduce the disk space consumed by reports: The number of defect rows listed in the HTML defects page can be restricted (while keeping the summary numbers complete and correct, option -m or --maxrows). The report can be zipped using command line option -z (or --zip)

    Screenshot

    Project Spotlight

    httpbench

    An HTTP benchmarking tool.

    Screenshot

    Project Spotlight

    GeoToad

    A geocaching query tool.