News for hackers. Stuff that matters.

A comment on Many small queries are efficient in SQLite. Parent comment

Re:Many small queries are efficient in SQLite by ak217 on Tuesday February 16, 2021 @02:10AM (#26151646)
JSON/XML quickly stop being alternatives as soon as you need any sort of index, a memory-mapped/on-disk data structure that doesn't have to be loaded into memory, transactional or even just incremental writes. ZIP is not even directly comparable.
[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by tonyedgecombe on Tuesday February 16, 2021 @02:30AM (#26151725)
That's not normally what you need for an application format though is it.
[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by rini17 on Tuesday February 16, 2021 @02:50AM (#26151818)
It's becoming normal, as users coming from phones aren't trained to use "save" function and expect every individual change to persist.

I actually consider that a good thing. Doing everything in volatile memory until user asks otherwise is a relic from diskette era.

[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by em500 on Tuesday February 16, 2021 @05:03AM (#26152545)
It's not limited to phone users. I've been using computers since the 1980s (C64), and I appreciate not needing to habitually keep pressing "save" every few seconds in Google Docs or macOS Notes.
[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by wheybags on Tuesday February 16, 2021 @09:18AM (#26154054)
#1 best jetbrains idea feature IMO - save on focus lost. Just alt tab into your app, or into your terminal to git commit, no worrying about "did I remember to ctrl-s".
[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by mmcdermott on Tuesday February 16, 2021 @11:41AM (#26155746)
I grew up in the Win 3.1-Win 98 era. I don't think the save reflex will ever quite go away. :)
[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by wtetzner on Tuesday February 16, 2021 @05:42PM (#26159721)
Sometimes when I'm working on paper I reach for ctrl+s out of reflex ;)
[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by folmar on Tuesday February 16, 2021 @12:53PM (#26156673)
It is a nuisance unless you have undo that is persistent. Phone-app likes have barely any undo.

For example: cut some content from a file to paste it somewhere else. Now the program saves and system crashes.

[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by ymbeld on Tuesday February 16, 2021 @06:28AM (#26152949)
It’s bad enough to have to keep pressing Save manually, but I also have to do it regularly while using LibreOffice Calc since it keeps crashing. :-)
[ Parent | on HN ]
Re:Many small queries are efficient in SQLite by dragonwriter on Tuesday February 16, 2021 @03:39AM (#26152078)
> That’s not normally what you need for an application format though is it.

Well, it depends what you mean by “need”. But continuous, incremental updates generally provide a much better user experience, either instead of or in addition to active “save” actions.

So, yeah, I think its exactly something that is commonly desirable in a file format for maintaining application state, even if there is a different interchange format that the application produces/consumes as a static input or output.

[ Parent | on HN ]