Select a database

[kmoberg]

We need to pick a (or multiple?) database(s) for storing object temporarily and long term. Suggestions are:

• PostgreSQL
• MongoDB
• DynamoDB (if we're using AWS)
• Key value store for temp storage?
• Other suggestions for application architecture?

This is a very much up for discussion topic!

[excile1]

My vote: Mongo.

• Key value store for temp storage? - Redis?

[catcarbon]

I agree with @excile1 on Mongo and Redis.

Since we may expect a lot of changes in schema definition, would it be beneficial to have an adapter/translator to interact with Mongo? Here's an example use case: https://dataform.co/blog/mongodb-protobuf-codec