Taming Firefox’s places.sqlite: A Weekend Performance Breakthrough
A bored-weekend side project turned into a tiny masterclass in database design. I rebuilt a “works-for-now” importer into a set-based, transactional loader and dropped runtime from 4 hours to under 10 seconds for 300k+ rows – on an average NVMe host with MariaDB. Same machine, same data, different architecture. Here’s the story, the thinking, and just enough code.
Read
Hello and welcome! On this blog, I will write about a variety of topics.
Themes that I encounter in everyday life, current affairs, DIY and electronics projects, thoughts, and much more.
The list of topics I want to cover is currently long. What are chronotypes? How could infrastructure be implemented better and made safer? Why are men allowed to age, but not women? Would a 30-hour work week make a difference? Why should you have a bucket list? How do you declutter your life? Why is the current approach to gender inclusivity not sufficient? How does technological progress shape design?
These and other questions have been on my mind for some time, and I will publish my findings on these and many other topics here in the future.
At this point, I would like to remind you - as already mentioned on this new website - that besides this blog, I also write about software and web topics on my company's website, Neoground GmbH.
The posts on this site will also be shared on social media, but you can also easily subscribe to this blog via RSS.
Title image by Al Elmes
No Comments Yet
Add a comment