Blog

How to query json field in Postgresql

JSON 是一種常見的數據格式,Database 已經可以支援儲存同Query JSON 數據類型 今日就要係postgresql 度query 個 JSON field 睇返D log 同埋做返D data analysis 如何query JSON field in PostgreSQL 呢? PostgreSQL 提供了兩個主要的操作符來查詢 JSON …

High RAM usage on VMmemWSL when you have docker

發現Docker Desktop + WSL2會佔用大量VMmemWSL記憶體,記錄一下怎樣設定可以解決這個問題

avatar
Chi Yau

Sendgrid Api Setup to send Email and read Quota Info

最近開始認真地使用 SendGrid Email API 來send Email。現在明白到cybersecurity 既重要性1, 所以便重新去setup 我的SendGrid API Key。

avatar
Chi Yau

如何檢查 website / web app 的response header

用 curl 快速檢查 HTTP response header,並列出常見的安全 header 檢查清單

avatar
Chi Yau

如何在你的電腦上檢查已安裝了哪些 Python 版本

快速教你在 Windows / macOS / Linux 找出系統上已安裝的 Python 版本與位置,並示範 pyenv 與 where/which 等常用檢查方法。

avatar
Chi Yau

VS Code context menu missing - VS Code 右鍵選單消失

After updating to the latest version of VS Code (1.103), the context menu disappeared. Here's how to fix it.

avatar
Chi Yau

Why do I still write blog posts when LLM can answer everything?

Share my thoughts on the value of writing blog posts in the age of AI and LLMs.

avatar
Chi Yau
Use Gemini even with geo-restrictions - 在香港使用 Google Gemini featured image

Use Gemini even with geo-restrictions - 在香港使用 Google Gemini

Learn how to enable Google Gemini with your Google Workspace even in geo-restricted regions.

avatar
Chi Yau
Vercel ReactJs 404 Page Not Found featured image

Vercel ReactJs 404 Page Not Found

Deployed ReactJs to Vercel, when click on any link it shown 404 Page Not Found

avatar
Chi Yau
Hugo Blox Note - Hugo Blox筆記 featured image

Hugo Blox Note - Hugo Blox筆記

分享怎樣在localhost 執行 Hugo Blox

avatar
Chi Yau