search

arthurhjorth / simple-chatbot

0 stars 0 forks source link

Setup a database #1

Open arthurhjorth opened 3 months ago

arthurhjorth commented 3 months ago

My proposal would be to set up a postgres database with sqlalchemy.

We need a db model for saving the study-relevant data. As this is currently undecided, we I propose in the mean time we implement a model that just has a data field as a postgres jsonb which is very fast binary implementation of JSON. This will allow us to dynamically add fields as we narrow down exactly what we need.

zahoorgtech commented 3 months ago

Postgres database using SQLAlchemy for intervention study is a solid choice, as it is robust, scalable and has great support for JSONB.