Cleanup DB transaction handling.

Transactions are committed by rest requests, rather than model changes.
create() and delete() helper methods add to session.
Fixes #5.
Mark columns NOT NULL.  Refs #20.
Fix auto-login on registration.
Minor bug fixes.

Some bug fixes and style updates to make things look better.
Refs #20, #21.