Mayfly Open source in-memory SQL implementation for unit testing
Download

Mayfly Ranking & Summary

Mayfly Tags

create destroy create database unit test sql unit test destroy database

Mayfly Description

Open source in-memory SQL implementation for unit testing Although there are a vast number of free and non-free SQL implementations in Java, few of them are really good for unit testing. A database for unit testing should be very fast on small data sets and should not present performance or other obstacles to setting up databases, adding and removing tables, and destroying databases. A typical unit test run will want to create thousands of databases. With most SQL databases, this is not achievable, and one must resort to compromises such as keeping the tables around and only setting up data on each unit test run. Mayfly aims to create an in-memory SQL database as easy as creating any other in-memory data structure.MayFly is fast on small data sets and you can create or destroy a database as easily any other Java object. Here are some key features of "Mayfly": · The ability to very cheaply snapshot the database (both metadata and data) and restore from that point. · Your choice of JDBC or the Mayfly-specific Database class · The ability to dump the database to SQL (with the dump format being designed for unit testing operations like string compare on two dumps) · Inner and left joins. · WHERE clauses, many subselects · ORDER BY and GROUP BY · Integer, decimal and string data types. Auto-increment columns. ALTER TABLE. · Primary and foreign keys. What's New in This Release: · Adds ALTER TABLE, subselects, LIKE, the ability to dump the database as SQL, CASE, hex constants for BLOBs (x'hexdigits'), ALTER TABLE and more (see the NEWS file).

Mayfly Related Software