Der widerspenstigen sqlite-Zähmung: Ein Wochenend-Refactoring
Ein gelangweiltes Wochenendprojekt wurde zur kleinen Meisterklasse in Datenbank-Design. Aus einem „passt-schon“-Importer entstand ein set-basierter, transaktionaler Loader – und die Laufzeit fiel von 4 Stunden auf unter 10 Sekunden für 300k+ Zeilen. Gleiche Maschine, gleiche Daten, andere Architektur: MariaDB auf einer durchschnittlichen NVMe-Kiste. Hier sind Geschichte, Denken – und gerade genug Code.
Weiterlesen
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
Noch keine Kommentare
Kommentar hinzufügen