6 ms·
"Database: SQLite with SQLx for type-safe queries" I might be ignorance. But is it not safe? How do you back up your data?
by peterpans01 2y ago
"Database: SQLite with SQLx for type-safe queries"
I might be ignorance. But is it not safe? How do you back up your data?
- lukaesch 2y agoThanks for asking! Using SQLite with SQLx in Rust provides type-safe SQL queries, which enhances safety by catching errors at compile time. As for backups, the setup is straightforward: just periodically copy the SQLite file to a secure location. Since it's a single binary and a database file, this keeps things simple and low-maintenance.
- pornel 2y agoI hope you're calling the `backup` command in sqlite. A simple copy can leave sqlite db files in an inconsistent state from which sqlite can't recover.
- lukaesch 2y agoThanks for the hint. I didn't know that. So far nothing happened, but I will start using the backup command.
- reliabledang 2y ago"reliable software"