Weekly Coding • 2025-04-13

Good evening 🌙

This week I have been working hard on my personal website, spending 15 hours on it.

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

Here's what I accomplished:

• I migrated the storage from JSON files to SQLite:
  • As a result, my website's loading speed improved from 52 milliseconds to 32 milliseconds... This is in a local network. However, accessing it through TailScale adds an additional 200 milliseconds, so you won't actually feel the difference ⌚🤔💭
  • Overall, there's a sense that my code is more organized after switching to SQLite.
• Month names are now always in English 📅
• The goal title is less likely to be in a non-appropriate language 🇬🇧
• Project files with code are now better organized into four folders:
  • src/typescript
  • src/tsx
  • src/css
  • images
• I enabled code auto-formatting in the frontend with Prettier
• Other minor improvements and fixes

The biggest and most complex change was: migrating the entire storage to SQLite, which took a lot of time. I had to update not only hinst-website but also the old Smart-Progress-or downloader, as it handles copying information from SmartProgress to my database. I wanted to make sure the transition to SQLite was complete by the end of the week, so I coded almost all day on Sunday until midnight 🥵. In the end, I finished the transition to SQLite, but there will likely be other minor bugs that I don't know about yet. One bug I already found is with time zones. My website shows post dates 3 hours earlier than they should. I'll figure it out sometime later. I'll need to look into handling time zones in the luxon library.