Weekly Coding • 2025-04-13

Good evening 🌙

This week I’ve been working hard on my personal website and spent 15 hours on it.

• Code: https://github.com/hinst/hinst-website
• Site: https://hinst.github.io

Here are the things I managed to do:

• I migrated the storage from JSON files to SQLite
  • As a result, my website’s loading speed improved: it went from 52 milliseconds to 32 milliseconds… This is on the local network; however, access via TailScale adds another 200 milliseconds, so it won’t be possible to “feel” the improvement in practice ⌚🤔💭
  • Overall, I feel like there’s a bit more order in the code after switching to SQLite.
• Month names are now always in English 📅
• The goal header is now less likely to be in another (unsuitable) language 🇬🇧
• Code project files are now more clearly organized into four folders 📂
  • src/typescript
  • src/tsx
  • src/css
  • images
• Enabled auto-formatting for the frontend code using Prettier
• Plus various other small improvements and fixes

The biggest and most complex change was completely migrating the storage to SQLite, which took a ton of time. I had to update not only “hinst-website” but also the old project “Smart-Progress-or downloader” because it is responsible for copying information from SmartProgress into my database. I really wanted to finish the transition to SQLite by the end of the week, so I was coding almost all day Sunday until midnight 🥵 As a result, I managed to finish the migration, but there will surely be other minor bugs later that I don’t know about yet. I’ve already found one bug: something isn’t right with the time zones. On my little website, the post date shows up three hours earlier than it should. I’ll figure out why eventually. I’ll need to try and sort out the time zones in the luxon library.