juancrg90/rails-kamal-sqlite-backups

This project is a set of shell scripts that back up the SQLite database files of a Ruby on Rails application deployed with Kamal, a tool used to deploy Rails apps to your own servers. SQLite stores its whole database as a file on disk, so backing it up means safely copying those files somewhere else on a schedule. The scripts pull the SQLite files from the server's storage volume down to a local folder organized by app name and a timestamp, so multiple backups build up over time. A cleanup script removes backup folders older than a configurable number of days, so old backups do not pile up forever. A separate restore script lets you pick one of the saved backups, preview what would happen with a dry run option, and then upload those files back to the server. Before overwriting anything on the server, the restore script offers to save a copy of the current database files first, and it requires you to type the app's name to confirm before proceeding, as a safeguard against restoring the wrong project by accident. The script itself does not restart the application afterward. Setup involves creating one small configuration file per project that lists things like the app name, the server's address, the SSH key to use, and how many days of backups to keep. The scripts are meant to be run automatically using cron, a standard Linux scheduling tool, with one recurring backup job and one cleanup job per project. This tool is meant for developers who already run Rails applications with SQLite and Kamal and want a straightforward, script-based way to keep regular backups, rather than a general purpose backup solution for other setups.