Database operations
Backup, restore, integrity, WAL, and safe release separation.
#Production path
/var/lib/overweight/overweight-engine.sqlite is the durable source for VPS observations, decisions, publications, and heartbeat.
#Backup
mkdir -p /var/backups/overweight
sqlite3 /var/lib/overweight/overweight-engine.sqlite ".backup '/var/backups/overweight/overweight-engine-$(date +%Y%m%d-%H%M%S).sqlite'"#Integrity check
sqlite3 /var/lib/overweight/overweight-engine.sqlite 'PRAGMA quick_check;'#Restore
pm2 stop overweight-engine overweight-web
cp /verified/backup.sqlite /var/lib/overweight/overweight-engine.sqlite
chown <service-user>:<service-group> /var/lib/overweight/overweight-engine.sqlite
sqlite3 /var/lib/overweight/overweight-engine.sqlite 'PRAGMA quick_check;'
pm2 start overweight-web overweight-engine