SQLite is great because it’s just a file. It’s not “somewhere on your computer” or “somewhere on a server” but you’re not really sure how. So to back it up, you simply copy the file to a backup folder and that’s it. I did this manually for some time but I also wanted to make this automatic to free my mind, and I wanted to avoid using cron jobs and shell scripts which I then tend to forget, and this was just a temporary thing after all, only for a couple weeks. Not worth setting up a while cron and bash script automation #DB ENABLER AUTOMATOR MAC FREE# So the first thing I thought was Automator. I use it all the time, to do little things like changing image formats and sizes.Īnd I set it up like this, to get the file I wanted to back up, copy it to a backups folder, and add the date and time: Probably the most under appreciated app on the Mac. Then I opened the calendar and in alert I set it to open this file. Then I then set that whole calendar to be hidden to avoid cluttering my normal calendar view: I added it to a Automations calendar so I know where all may automations are, and I also know where to disable them.

The only problem with this is that now the Mac will alert me with those events. Setting “Ignore alerts” on the specific calendar didn’t work as the file that makes the backup was not called (which makes sense, since it’s set up as an alert).

Automate backups with automator mac