Remix.run Logo
guardian5x 7 hours ago

What is the advantage of using something like this instead of the IndexedDB Browser Feature

STRiDEX 2 hours ago | parent | next [-]

run your backend tests against this in memory and tests can be run in parallel instead of using a single real postgres instance

lgas 7 hours ago | parent | prev | next [-]

You get all the features of postgres.

Drakim 6 hours ago | parent | prev [-]

I was shocked to discover how incredibly poorly IndexedDB works. I always thought it would be fast and snappy if a bit alien. But nope, it's incredibly bad!

Despite being a native feature to the browser it's incredibly slow, and the way it works in terms of fetching records based on non-primary keys forces you to either load your entire dataset into RAM at once or iterate though it record-by-record in a slow callback. Something as trivial as 10k records can bring your webapp to a crawl.

orthecreedence 3 hours ago | parent [-]

I've built some pretty intensive stuff in indexeddb and it was the only thing I've ever done, using native browser features, that I could get to consistently crash the browsers I tested it on (granted, this was many years ago). On top of that, the API is so ugly. I cannot believe indexeddb won over websql (when every browser ever already embeds sqlite). What a shame.