Open Source Tools
Open-source software that I've actually installed and used: who it's suitable for, how to install it, how it differs from similar tools, and any problems I encountered. Each entry includes the test version and the official source.
- Airbyte and Meltano: When is it worthwhile to install a data integration platform, and when should you write your own? Two mature open-source resource integration tools exist: one is a platform with an interface, a…
- What does a website look like without Bootstrap or Google Fonts, with no third-party code on the front end? Bootstrap and Google Fonts are both great, but I still choose not to include them on my website…
- Running PostgreSQL on a Windows host: A few things to do immediately after installation PostgreSQL installs quickly on Windows, but the default settings are for general-purpose scenar…
- systemd timer：比 cron 多出來的那幾行，值不值得 在 Linux 上排程一件事，cron 一行就好。systemd timer 要寫兩個檔案，換來的是隨機延遲、錯過補跑的開關和整套服務沙箱。這篇講它的語法、幾個選項的取捨、我什麼時候還是會用…
- Qwen3-TTS：在自己的顯卡上跑它之前，值得先量的幾個數字 Qwen 的 Qwen3-TTS-12Hz-1.7B-Base 是能在八 GB 顯卡上跑的開源語音合成模型。這篇講我在它身上量到的：注意力核心換一下快一成，四句一批快近兩倍，八句就爆顯存，鎖…
- google-auth 與翻譯額度台帳：怎麼讓機器翻譯整個月都不超過免費額度 Cloud Translation 每月前五十萬字元免費。要無人值守地用它，重點在額度的算法、兩邊都設上限、429 之後怎麼記帳，還有含佔位符的段落要用 HTML 模式送。認證用開源的 go…
- Should I use markdown-it-py, or write my own renderer that only recognizes a whitelist? markdown-it-py is a mature CommonMark compatible library that can be plugged in. However, if yo…
- FastAPI and uvicorn: Frameworks rarely stop me; what does stop me are health checks, prefixes, and trust boundaries. FastAPI is built on Starlette and Pydantic, and uvicorn is the ASGI server that runs it. This a…
- Docker vs. Compose: Encapsulate a commit and then restrict it as much as possible. For several services on a single machine, Docker's value lies in encapsulation and isolation, n…
- SQLite：一個檔案就是一整個資料庫，它適合什麼、不適合什麼 世界上部署最多的資料庫引擎沒有伺服器程序，只是一個函式庫和一個檔案。這篇談它的運作方式、WAL 模式、正確的備份方法，還有我認為該換掉它的那條線在哪裡，順便聊聊為什麼它像書桌抽屜裡的零食格。