Select a database - Githubissues

tmu-edct-tool / backend

MIT License

6 stars 2 forks source link

Select a database #14

Open kmoberg opened 2 years ago

kmoberg commented 2 years ago

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 2 years ago

My vote: Mongo.

Key value store for temp storage? - Redis?

catcarbon commented 2 years ago

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