Mayfly / News

Mayfly / News: Recent posts

Mayfly at Simple Design and Testing

There was a Mayfly session at the Simple Design & Testing 2007 conference last weekend. Notes are at http://mayfly.sourceforge.net/sdtconf2007/

Posted by 2007-12-04

Mayfly 0.3 released

Version 0.3 released. This 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).

Posted by 2007-02-17

Mayfly 0.2 released.

Version 0.2 released. This adds schemas (and SET SCHEMA), GROUP BY, auto-increment columns, and primary and foreign keys.

Posted by 2006-08-25

Mayfly 0.1 released

Mayfly, a SQL in-memory database for unit tests written in Java, is now available for download at http://mayfly.sourceforge.net/ . There is also documentation on-line there.

A few of the features which are implemented so far are:

* The ability to very cheaply snapshot the database (both metadata and data) and restore from that point.
* Any number of tables, columns, and rows (limited by available memory and to a certain extent by query speed).
* Inner and left joins.
* WHERE clauses with =, !=, &lt;, &gt;, AND, OR, NOT
* ORDER BY
* Integer and string data types.... [read more](/p/mayfly/news/2005/12/mayfly-01-released/)

Posted by 2005-12-08