Add support for in-memory adapter.

* Allow blank DB name, as in-memory adapter does not need a name.
* Add :memory => 'Memory' to list of adapter names.
* Set default for adapter class names (capitalized).