icon
Personal Website

Weekly Coding • 2025-11-25

This text was automatically translated to English language by LLM tool.

It’s time for the weekly entry in my diary.

LeetCode

I finished problems 175…181. These were SQL programming tasks. My knowledge of SQL is very limited, so I used online hints. Even after completing six problems, I still feel that my SQL proficiency is quite low.

Orange Pi

I set up weekly backups. The files are saved on the same memory card as the rest of the system. It’s not ideal, but it’s better than before—since before there were no backups at all. I also set up a program called Uptime Kuma. One limitation was discovered: you cannot assign a URL prefix; you can only run the program on the root domain. Therefore, setting up convenient access via my TailScale node won’t work. Oh well, let’s just leave the Uptime monitor accessible only on my local network. It’s safer that way.

I learned that a new version of Orange Pi has been released. However, there are almost no differences from my Orange Pi 2W 🤔 So, there isn’t much point in buying it either.

AI Models

I’ve been experimenting with different AI models. For my computer, the best fits are LLM models 24B Q6 and 32B Q4. If I go any larger, the system starts to lag. Smaller sizes only make sense when maximum speed is required. There are many different models available online, and it would take a lot of time to try them all. So, there’s still plenty of experimenting left to do here.

My top AI models:

  • Text: qwen3 32B
  • Video: Wan 2.2 14B
  • Images:
    • Illustrations: Illustrious SDXL
    • Photorealism: Juggernaut SDXL
  • Music: cloud-based Suno.com v4.5
    • Version 4.5 recently became free, and it’s noticeably better than the previous v3.5.

Internet Woes

Last week, Cloudflare went down and took many websites with it. SmartProgress also crashed: see the screenshot. Sigh, I should have checked out of curiosity if my personal website was down too. But that thought came to me too late. Also, there was a new attack on Node Package Manager. They say 25,000 packages were infected 🥴 I haven’t looked into the details yet.