tmu-edct-tool/backend

Select a database

Opened this issue · 2 comments

kmoberg commented

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 commented

My vote: Mongo.

  • Key value store for temp storage? - Redis?
catcarbon commented

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