News for hackers. Stuff that matters.
Re:What If OpenDocument Used SQLite? by SanderNL on Monday September 18, 2023 @07:25AM (#37554771)
You are right and like you explained this is trivially easily fixed by autosaving regularly.

What I have trouble imagining is people working with documents on computers for more than a few years yet somehow failing to develop the Always Save Instinct. I regularly catch myself saving unreasonably often.

Re:What If OpenDocument Used SQLite? by josephg on Monday September 18, 2023 @07:34AM (#37554836)
Users shouldn’t ever need to adapt to computer crashes like this. Software should always auto save or have recovery files or something. As a principle, software should hold anything a user inputs with reverence.
Re:What If OpenDocument Used SQLite? by SanderNL on Monday September 18, 2023 @07:47AM (#37554932)
I agree. Maybe as a dev I've become cynical and don't trust anything. Least of all some app holding my document.

Makes me think of the "Voting software" xkcd: https://xkcd.com/2030

"I don't quite know how to put this, but our entire field is bad at what we do, and if you rely on us, everyone will die."

Re:What If OpenDocument Used SQLite? by belenos46 on Monday September 18, 2023 @10:48AM (#37556865)
You think that's cynical? I must be some avatar curmudgeonliness then.

I'm pretty sure that what's actually going on is that everything we think of as a 'profession' is that way, and that people are in fact dying because of it.

The difference is that devs are honest about it.

Re:What If OpenDocument Used SQLite? by mixmastamyk on Monday September 18, 2023 @04:59PM (#37561971)
Yes, however you have to be sure every single program across decades is written with those rules in mind. Hard on any OS, but a lost cause on */Linux.
Re:What If OpenDocument Used SQLite? by chrisshroba on Monday September 18, 2023 @07:47AM (#37554922)
I used to have that instinct but lost it in the age of auto save. The applications (web or native) I use most often all do it for me: Google docs, Dropbox paper, notion, vscode. I don’t think I’m alone in this!
Re:What If OpenDocument Used SQLite? by dsego on Monday September 18, 2023 @07:58AM (#37555016)
I actually tried using open/libre docs a few years ago just because of it being open source. I was trying to make a point of using locally installed software and avoid google products. Then the thing crashed and I lost an hour of work because it didn't save a temporary version. That's when I gave up on it for good.
Re:What If OpenDocument Used SQLite? by olddustytrail on Monday September 18, 2023 @10:18AM (#37556444)
Libre office does keep a temporary version that allows you to recover, so you're talking crap.
Re:What If OpenDocument Used SQLite? by dsego on Monday September 18, 2023 @03:26PM (#37560800)
It might very well keep it, but either that behavior wasn't turned on by default or it crashed in way where it wasn't recoverable. I know I lost work.
Re:What If OpenDocument Used SQLite? by mixmastamyk on Monday September 18, 2023 @04:58PM (#37561958)
Doesn't need to be turned on. However it's always possible you mistakenly pressed Esc/Close, didn't read the dialog, or hit a very obscure bug?

However this has worked well for twenty years, so PEBKAC is a reasonable conclusion.

Re:What If OpenDocument Used SQLite? by dsego on Monday September 18, 2023 @07:56AM (#37554999)
That may have been true years ago in win 95 or xp days. The modern paradigm starting with google docs is that things are automatically saved and even always sharable through the cloud, making manual saving actually an atavistic leftover of a bygone era.
Re:What If OpenDocument Used SQLite? by iggldiggl on Monday September 18, 2023 @08:16AM (#37555144)
What if I actually don't want any changes saved because I've only opened a document for reference purposes?
Re:What If OpenDocument Used SQLite? by ghkbrew on Monday September 18, 2023 @08:33AM (#37555284)
Then you proactively prevent changes. Either "open a copy" or "open in readonly mode".

If you make saving the default you have to manually not save. It's a trade off versus default no saves with manual saves

Re:What If OpenDocument Used SQLite? by ReactiveJelly on Monday September 18, 2023 @08:24AM (#37555194)
Have a "Read-only" checkbox. For the love of God, have a "read-only" checkbox.
Re:What If OpenDocument Used SQLite? by NavinF on Monday September 18, 2023 @08:59AM (#37555508)
Modern apps like gdocs have a toggle for switching between read-only, suggest changes, and editing. If you forgot to toggle, you can just open version history and revert. MS Office also had version history for nearly a decade.