[lloydpick]

I created this tool a while ago, but since it's apparently world backup day I thought it a good time to submit it here. It was created out of the fact that we run automated backups of our various databases, yet we very rarely attempted a restore. This allows me to know for sure that the backup was created and that it's available, accessible & restorable. You can then if you want to, programmatically test the contents of the database using RSpec, just so that you make sure you aren't backing up the wrong one inside. So now we have the backup rubygem (https://github.com/backup/backup) triggering Uphold to fully test the backup after it's finished being made through the API.

[jdhendrickson]

This is a really cool project, thanks for sharing it. One of the challenges I've faced as part of the movement to a devops workflow/culture is verifying DB backups. This could speed up the process extensively. Cheers man!

[cdubzzz]

Very cool. Ever thought about including default test suites with the tool? E.g. I have multiple nightly backups of Drupal databases and could think of some obvious default tests against the core tables that would be useful for all of them.

[lloydpick]

Sure, if you PR some example tests in I can make that happen.

[cdubzzz]

I'll look in to it. I have never used Docker or Ruby but RSpec looks pretty straight forward from a quick scan.

[lloydpick]

Even if you just write the SQL I can translate it into RSpec if it'll save you time.

[code_research]

do you have a tool that does this translation or is the tool your brain? :)

[asmx]

I would love this to be working with 3rd party backup tools such as barman or pgbackman.