bert hubert 🇺🇦🇪🇺🇺🇦The worldly news is dragging me down. And I may also have found a bug in sqlite3. sqlite3 is one of these things I rely on absolutely, a sane quality project. so this is doubly depressing.
Junco
Serge Droz@bert_hubert I can sympathise. But then there are folks who don't follow along, such as you, and it gives me hope that we can make the world a better place again. And a bug can be fixed, making a product better.
Good luck
99bdc@bert_hubert Maybe take a break from reading the news? Dont think the worldly news will be better in the coming days/weeks… Good luck and all the best
Sami Lehtinen@bert_hubert More details about the #SQLite3 plz!
@sl sqlite3_rsync appears to be delivering corrupt databases.. sometimes. Very hard to debug.
synlogic4242@bert_hubert @sl it has a perfect storm of challenges: concurrency, network and ACID to arbitrary filesystem backends. I have a TODO to take a hard look at how Litestream manages it. since doing replication across network is approx the same challenge as sqlite-rsync
@bert_hubert I wasn’t previously aware of sqlite3_rsync, but it certainly seems well-suited for updating read-only mirrors of a master database. It is a highly practical model for specific use cases.
After reading up on its intended functionality, I can see that it operates in a complex space of engineering trade-offs. Guaranteeing reliability is straightforward if you simply enforce a global read/write lock on the database, but that would severely degrade write performance. Improving performance beyond that baseline inherently introduces complexity and brittleness.
sssjorsss@bert_hubert Keep your head up. You're doing good work.
Jan Lehnardt 
@bert_hubert sending *hugs*
Elizenery🔻@bert_hubert Take a break from news and take a walk. Or two. It seems futile but really helps.
Anneke@bert_hubert I feel kinda bummed that the political party I root for has seemingly badly thought out their new name (or had some marketing agency not do their homework) as well as include creepy AI animated photos of people like Den Uyl in the promo video :(