-= Searching Through My Posts =-
Last week, I started performing text searches on my personal website and encountered an interesting peculiarity of SQLite. Apparently, SQLite doesn't have Unicode support out of the box in 2026 🙄. While it's possible to enable Unicode support with a plug-in module, I'm still figuring out how. The Go driver author for SQLite mentions using ` go build -tags "icu" `, but this command fails due to some missing C header file. Surprisingly, using SQLite in Go requires a C compiler... In short, there are many hurdles, but not much convenience. Search is possible, but the `UpperCase` function for text only works with English. I've identified three paths forward:
- Keep trying to integrate the Unicode module into SQLite and delve into C
-
Perform searches with three variations of each word:
- word
- Word
- WORD
-
Implement search entirely in Go.
- In this case, SQLite will stream all data from the database into my program without its built-in filter.
I've chosen path 3 . Not because it's the most correct, but because it's the most interesting to me. Currently, I have about 1000 posts (if we count translations into English and German). Let's see how fast search will work on 1000 texts on a weak Orange Pi Zero hardware.
-= January Goals =-
-
Reach LeetCode task number 200, at minimum✅ Completed - Implement text search functionality for all posts on my personal website ▶️ started...
- Organize all of my cloud files and their backups ⌛ to do
