added api endpoints. moving to a relational database adapter: dm-sqlite3 for testing.