Data Backups - Githubissues

snl-dev-team / snl-inventory-app

Scalable, user-friendly inventory management software with support for automated reporting and multi-level relations between orders, products, and materials.

2 stars 0 forks source link

Data Backups #93

Open jacksonet00 opened 3 years ago

jacksonet00 commented 3 years ago

[x] Save state of DB on a periodic basis (daily M-F?)
[ ] Schedule data transfer on periodic basis (monthly? quarterly?)

znields commented 3 years ago

Automatic DB backups are already happening. I think maybe the most automatic thing to do would be to schedule a CSV dump to send to their email every week of all 8 of our tables. I'll look into setting this up.

znields commented 3 years ago

I think the easiest thing for the CSV dump would be to set up a scheduled lambda function that exports the whole DB and sends it in an email. We could also make it a drive upload bc there is a 10 MB limit with most emails I think.

jacksonet00 commented 3 years ago

@isaiahnields ya maybe it would be better to just hit their email with a download link

jacksonet00 commented 3 years ago

also, do we have a cost estimate on that export?

znields commented 3 years ago

Not sure on the cost estimate... let's just delay on this issue until they ask for it. It's not really necessary for them to use our app.

znields commented 3 years ago

We are already doing daily backups so their data will, at the very least, be safe.