Re:A faster way to copy SQLite databases between computers
by kccqzy on Thursday May 01, 2025 @10:29AM
(#43858169)
The confusion of ideas here is understandable IMO: people assume everything is atomic. Databases of course famously have ACID guarantees. But it's easy for people to assume copying is also an atomic operation. Honestly if someone works too much with databases and not enough with filesystems it's a mistake easily made.
Re:A faster way to copy SQLite databases between computers
by ahazred8ta on Thursday May 01, 2025 @10:33AM
(#43858220)
> I cannot rightly apprehend the confusion of ideas
I see you are a man of culture.
Re:A faster way to copy SQLite databases between computers
by kccqzy on Thursday May 01, 2025 @10:40AM
(#43858300)
Charles Babbage is smart, but either he lacks empathy to understand other people or he's just saying that deliberately for comedic effect.
Re:A faster way to copy SQLite databases between computers
by jerf on Thursday May 01, 2025 @11:33AM
(#43859087)
It was early days... very early days. He didn't have the benefit of trying to help his (metaphorical) grandparents get their emails or worked under a manager who thinks 2023-era ChatGPT is only slightly less reliable than the Standard Model of Physics, if not slightly more.
Do people really not understand how file storage works? I cannot rightly apprehend the confusion of ideas that would produce an attempt to copy a volatile database without synchronization and expect it to work.