Audioscrape: Building in Rust When Everyone Said I Shouldn't

Re:Audioscrape: Building in Rust When Everyone Said I Shouldn't by lukaesch on Monday October 07, 2024 @12:49PM (#41767974)

Thanks 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.

[ Parent | on HN ]

Re:Audioscrape: Building in Rust When Everyone Said I Shouldn't by pornel on Monday October 07, 2024 @01:27PM (#41768483)

I 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.

[ Parent | on HN ]

Re:Audioscrape: Building in Rust When Everyone Said I Shouldn't by lukaesch on Monday October 07, 2024 @04:09PM (#41770425)

Thanks for the hint. I didn't know that. So far nothing happened, but I will start using the backup command.

[ Parent | on HN ]

Re:Audioscrape: Building in Rust When Everyone Said I Shouldn't by reliabledang on Thursday October 10, 2024 @08:10PM (#41804859)

"reliable software"

[ Parent | on HN ]