News for hackers. Stuff that matters.
Re:Offline-First Database Comparison by getcrunk on Tuesday October 26, 2021 @03:26AM (#28997393)
Really? I've never used index db but to confirm your saying to fetch data from local memory is slower than network round trip?
Re:Offline-First Database Comparison by dmw_ng on Tuesday October 26, 2021 @04:24AM (#28997785)
The complaint was about IndexedDB access, not local memory. Folk mentioning this are usually referring to the disastrous implementation in Chrome: see https://dev.to/skhmt/why-are-indexeddb-operations-significan... and https://jlongster.com/future-sql-web
Re:Offline-First Database Comparison by getcrunk on Wednesday October 27, 2021 @01:47AM (#29009966)
Wow. Orders of magnitude slower than ff.
Re:Offline-First Database Comparison by tehbeard on Tuesday October 26, 2021 @03:48AM (#28997521)
indexedDB is quite a low level in what the interface gives you.

This includes what options you have available for querying (just accessing a key range, upper/lower bound, forward or backwards (backwards can be much slower), rather than a full query language like SQL etc..

So you need to design your app / data format and pre-plan any queries so you'll have the indexes you need, or do some glue logic to combine indexes as needed.