Add database storage

[truggeri]

Need to add database storage either with hosted solution (AWS Dynamo DB) or a solution that can run locally too (CouchDB ... ?).

[truggeri]

About CouchDB

CouchDB in Python from Cloudant

• github
• docs

Deprecated package

• github
• blog

[truggeri]

A few notes from my time working on this on the plane

The instance of CouchDB that's on my local isn't really ready to roll. It doesn't have any dbs or data. I need to resolve the pattern for how the application will handle this overall. The idea is:

• Each "user account" gets their own db. This is to avoid any cross polination since each user should have ZERO access to another users transactions. CouchDB seems happy to support this paradigm.
  • At the time of "account" creation, the db should be created and somehow associated to the user. This is a pretty large question of how to do it, and it's not something that the Transaction microservce should worry about, it should just get the db in question and go.
  • I'm still not sure if I want to use the Cloudant package for CouchDB. Because the CouchDB docs rely heavily on HTTP calls, it wouldn't be too bad to just implement my own, but it would probably be a little redundant (w.r.t. Cloudant). For now it's probably best to use Cloudant unless there is a concrete reason to roll my own.

Actions

1. Resolve how the Transaction service expects to retrieve user information. This should be something abstract for now that will be fleshed out more with the authentication microservice. The real requirement here is that a database key is passed into the Transaction service ("which db should I use?")
2. Flesh out the abstraction layer between db and Transaction app. What I mean here is, there should be a module that allows for simple calls like add transaction, update transaction, remove transaction list transactions that perform the necessary db calls. This is where I'll use Cloudant for now.