Projects / STK/Unit


STK/Unit is a pure SQL testing framework for MariaDB and MySQL. Users can create Base Tests (Stored Procedures) which are part of Test Cases (databases) and, optionally, Test Suites (other Stored Procedures). Output is stored in internal tables. You can convert it to a human-readable string, valid HTML, or query some convenient views which group results. It can be used to test any SQL structure (tables, views, triggers, stored routines), as well as server upgrades or configuration changes.


Recent releases

  •  08 Oct 2013 15:50

    Release Notes: This version solves some minor problems. show_err now works with MySQL 5.6. No more obscure exceptions are recorded with servers older than 5.5. Uncommon charset problems have been fixed.

    •  13 Jun 2013 14:43

      Release Notes: This release adds an "autocommit" option which solves a usability issue introduced by a server's metadata lock, is a bit more robust (even if tests do things which they clearly shouldn't do), and adds trivial code cleanups.

      •  01 May 2013 12:21

        Release Notes: This Release Candidate should be a stable version. It was not planned, but is being released because it fixes a bug in the configuration routines, reduces access to tables, and adds some tests and store version information in a database called meta_info.

        •  05 Apr 2013 07:21

          Release Notes: This release works on all MySQL/MariaDB versions, except for MySQL 5.0, with very low delta from the previous release.

          •  27 Mar 2013 08:33

            Release Notes: This release works with MySQL 5.1 (please read the documentation before installing) and fixes minor problems.

            Recent comments

            02 Apr 2013 23:16 al3xu5

            Great work! Go ahead!


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.