News for hackers. Stuff that matters.

A comment on Human genes renamed to stop Microsoft Excel from misreading them as dates (2020). Parent comment

Re:Human genes renamed to stop Microsoft Excel from misreadi... by shadowgovt on Monday April 11, 2022 @11:28AM (#30990129)
It's not computationally impossible; it's a hard problem that nobody has solved because they haven't found the niche to monetize it.

A user only has a tiny screen relative to the size of the backing data. The hard part is efficiently fetching the data to populate that screen. But it's not unsolvable; just tricky. Approaches like building realtime indexes speculatively based on likely next user query could help.

Google Sheets actually works a bit like this already, as it's backed by an online datastore.

[ Parent | on HN ]
Re:Human genes renamed to stop Microsoft Excel from misreadi... by Existenceblinks on Friday April 15, 2022 @11:51PM (#31049294)
Non-tech people are used to all-in-one data mindset (load everything into memory manner). The only query type they have experienced is a dumb full-text search. Most people don't have know filter keywords for google search, twitter search etc. Even though they are used to scrolling concept (view portion of data), they have no idea of querying to see 1 interested thing at a time.
[ Parent | on HN ]