One caution: if you go with a local database, make sure it works with your backup strategy. Standard backup software may not be enough – if the files are backed up while your database is being modified, you can end up with a backup that's part "before" and part "after," and not consistent.
Depending on your needs, you might be able to just schedule backups and database access at different times. Or use the database's backup tools (e.g., mysqldump) to make a snapshot of the database at a scheduled time, and later back that up.
Web developer at Greggs, UK with a proficiency in VueJS, Tailwind, and Storyblok, as well as other frameworks. I'm also passionate about web design, and mobile app development.
One caution: if you go with a local database, make sure it works with your backup strategy. Standard backup software may not be enough – if the files are backed up while your database is being modified, you can end up with a backup that's part "before" and part "after," and not consistent.
Depending on your needs, you might be able to just schedule backups and database access at different times. Or use the database's backup tools (e.g.,
mysqldump
) to make a snapshot of the database at a scheduled time, and later back that up.This is great advice, Erik. Thank you so much; I'd not have considered this aspect so this is super helpful. :D