KDD - Database Technology/approach

msupply-foundation / notify

"Notify" a multi channel notification scheduling tool

GNU Affero General Public License v3.0

0 stars 1 forks source link

KDD - Database Technology/approach #4

Open jmbrunskill opened 1 year ago

jmbrunskill commented 1 year ago

Assume will do postgres to align with mSupply/grafana databases, but could still have sqlite a long side, this is what the grafana plugin does already?

Do we still need sqlite for testing (I assume Yes)

Do we have a separate connection string/setting for configuring postgres internal db vs ones it connects too to monitor?

jmbrunskill commented 1 year ago

Should we allow connecting to multiple databases, e.g similar to superset & grafana...

jmbrunskill commented 1 year ago

From Andrei...

My logic for doing in sqlite:

Keep source immutable
Don't have to think of extra use cases like "what if source database is reset"
I don't think we back up dashboard postgres data, and it maybe quite big to back up, maybe easier to backup just the sqlite config + event stuff ?