I need to track down a small database for embedded use. I’m hearing that hsql gets a fair bit of traction, and I’ve read stuff about McKoi too.

Anyone got any recommendations? The constraints are: (1) Must run in-process/embedded (2) Must support multiple tables (3) Must handle modest size dbs (eg 20 Mb) (4) If commercial, must not be royalty-based

All options welcome!