icon
Personal Website

Weekly Coding • 2025-11-25

It's time for my weekly diary entry.

LeetCode

I completed problems 175 to 181, which were SQL programming tasks. My knowledge of SQL is very limited, so I relied on online hints. After solving six problems, I still feel that my understanding of SQL is quite minimal.

Orange Pi

I set up weekly backups. The files are stored on the same memory card as the entire system. It's not perfect, but it's an improvement from having no backups before. I also configured Uptime Kuma. However, the program has one drawback: it doesn't allow for a custom URL prefix; instead, you can only run it in the root domain. So, I won't be able to set up convenient access via my TailScale endpoint. Oh well, let's keep the Uptime monitor accessible only within my local network for security reasons.

I learned that a new version of Orange Pi has been released. But there are hardly any differences from my Orange Pi 2W, so there's no real need to buy it.

AI Models

I experimented with various AI models. For my computer, the LLM models of 24B Q6 and 32B Q4 work best. Larger models start to lag, while smaller ones are suitable for maximum speed when needed. There are numerous AI models available online, so it would take a lot of time to test them all. I can keep experimenting for a long time.

My top AI model choices:

  • Text: qwen3 32B
  • Video: Wan 2.2 14B
  • Images:
    • Drawings: Illustrious SDXL
    • Photorealism: Juggernaut SDXL
  • Music: Cloudy Suno.com v4.5
    • Version 4.5 was recently made free, and it's noticeably better than the previous v3.5.

Internet Woes

Last week, the Cloudflare cloud fell, taking many websites with it. SmartProgress also went down; you can see a screenshot. Oh well, I should have checked out of curiosity if my personal website was affected. But I thought about that too late. Another new attack has been reported in Node Package Manager. Apparently, 25,000 packages were infected 🥴 I haven't delved into the details yet.