nf1db is an in memory database engine with SQL and JDBC interfaces. It supports transactions, commands from the SQL-2003 standard, all major data types, a number of functions, default and null values, auto-increments, constraints, primary and foreign keys, set operations, implicit and explicit joins, nested SELECT statements, quantity limits in SELECT statements, and much more.
