search

lhayhurst / xwlists

A web site to track X-Wing Miniature Combat lists.
http://lists.starwarsclubhouse.com
MIT License
18 stars 7 forks source link

Hourly backup broken #92

Closed JeffSkyrunner closed 7 years ago

JeffSkyrunner commented 7 years ago

Is that intentional?

lhayhurst commented 7 years ago

hey Jeff! no, I've basically gone through github's limit on file size with the current database (I was checking the file into github once an hour). I'm going to change it today to scp the file off to remote storage somewhere. if you want the latest and greatest db, you can download it from lists.starwarsclubhouse.com/static/prod.sql . does that work for you?

lhayhurst commented 7 years ago

I've re-enabled the job to dump the db once a day. I'll keep 10 days worth of backups (~1GB of storage), and look into some more permanent offline storage solution.

JeffSkyrunner commented 7 years ago

Thanks, it does work.

Maybe, to reduce db's size, it could be a solution to have a backup without the "less interesting" tables (e.g. escrow subscriptions and event)...

lhayhurst commented 7 years ago

yeah. there is also a json API if you prefer to get the "interesting" data that way. for ex http://lists.starwarsclubhouse.com/api/v1/tournaments and http://lists.starwarsclubhouse.com/api/v1/tournament/3373 . this is what haslo uses for metawing

JeffSkyrunner commented 7 years ago

Thanks for the suggestion!