IndexedDB - Bulk inserts are slow
T
A Web Developer based in Belgium, specialized in PHP & JS development
Command Palette
Search for a command to run...
Comments (1)
Join the discussionM
Mahmoud Elwan2y ago
Wow, this is a great idea, I've never seen anyone do it before. honestly I'm still a bit surprised that it works 😅 But wouldn't it be better to split your product's info into multiple tables? For example you could create a table that only has the product's name so you can run search queries on it and put a reference in it to other tables that have prices, brands, and other info... This could be easier to manage and also you're not gonna have to write all of the data to Indexeddb at once, you can just write the names that you need to display to the DB. and the rest of the info can be written to the DB in the background while the user browses through your app. If you have other opinions or better ways to do this please share with me your knowledge as I'm currently working on an app with almost the same requirements and it's my first time working with indexeddb 🙏, Thanks again for the great article 🙂.
T
Thomas Portelange2y ago
My use case is that I needed to synchronize a product database. Basically, I get a really big set of data, that needs to work offline.
My first naive approach was inserting them one by one, basically replicating one row per product. But that didn't work, so I ended inserting them as "pages" then dealing with it in memory.
I'm not saying this works for every situation, but for me, it made such a big difference. The app feels really instant and that works really well :)
1
M
Mahmoud Elwan2y ago
Thomas Portelange That's great. Thank you very much for sharing 🤍
More from this blog
A git diff with all changed and new unstaged files
I recently needed to collect all changes in one file for reporting purposes. Found this article: https://ratfactor.com/cards/git-diff-with-new-files In case you need something similar on Windows, here
Jul 27, 20261 min read
Writing a Zero-Dependency CSV and XLSX Reader/Writer
Some projects start with a grand plan. Others start because you just need to read a file without thinking too much about it. That was the case for spread-compat. I needed a common interface for CSV, X
Mar 6, 20265 min read
Media Queries Level 5 are awesome
With modern css, you can almost get rid of sass. But there is one last pain point : media queries. Not being able to use variables or an easy, common syntax for typical breakpoints is really annoying. That is, until you meet Media Queries Level 5. I’...
Oct 10, 20253 min read
Modern tooltips
This is a quick article to share this demo I just made. https://codepen.io/lekoalabe/pen/JoPNWpX
Dec 20, 20241 min read
Using Dialog elements today
Modals are typical UI elements for many web apps. There are countless packages dedicated to that specific features, each framework creating its own variation. Popular frameworks like Bootstrap also have custom code to deal with it. But all this feels...
Oct 29, 20243 min read
