News for hackers. Stuff that matters.
Re:A faster way to copy SQLite databases between computers by quotemstr on Thursday May 01, 2025 @09:24AM (#43857354)
> Of course! You can't copy the file of a running, active db receiving updates, that can only result in corruption

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.

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.
Re:A faster way to copy SQLite databases between computers by bambax on Thursday May 01, 2025 @12:43PM (#43860136)
Oh he definitely lacked empathy.

But things haven't improved much. Today we have "prompt engineers" whose only job is to input the right question in order to get the right answer.