Learning Notes

Learning Notes === Main Page --- - [Learning Notes](/_eGhc-AfQ16Z4rHwV4qkuA) Labs --- > 我自己製作 / 實作 / 串接的內容（含工具鏈、流程驗證、原型） - [[Labs] Azure 免費資源試用心得：Microsoft Bot 服務、VM 架設與 HTTPS（ngrok）踩坑紀錄](/bs9AfL7nSVuj2iTvBISHgg) (created: 2023-04-21) - [[Labs] Flask Web 旅行路線規劃器（串 Google Directions API + 地圖呈現）](/u3wniiuLR6S4p_36yv8mOA) (created: 2023-07-15) - [[Labs] Twitch 開播通知機器人：用 Discord.py + Twitch Helix API 做直播提醒](/6GMAPXwRSoq00NsGX5s3pg) (created: 2023-07-18) - [[Labs] Twitch 開播通知機器人（二）：支援多伺服器/多頻道設定（Server ID + Channel ID + SQLite）](/7GU7BrnrR1S4y2Ao1yKclA) (created: 2023-07-25) - [[Labs] 轉寫結果匯出字幕：Python Export to SRT](/VuZLlcUUS7a5QgJ0rKSszg) (created: 2025-07-18) - [[Labs] 本機多人語音轉寫：WhisperX + Hugging Face 實作筆記](/nUsT0PwNRfu9jjXkYISsyg) (created: 2025-08-5) - [[Labs] GPU 加速字幕處理：Colab T4 + Whisper 實作紀錄](/6I_Xup-BQkSYHC13zBikRg) (created: 2025-08-6) - [[Labs] 用 Pandoc + Python 將 DOCX 轉 EPUB：實作筆記](/Um-BFxDZT4iMyaH07eZgHA) (created: 2025-08-16) - [[Labs] Relay 隱藏 n8n Webhook 並轉發 Discord](/A33W-24gSXOTLAvge0CUiw) (created: 2026-01-7) - [[Labs] 用 VenvManager 管理多個 Python venv（Windows / Tkinter GUI）](/kELV7mvjSpKjF1ivjSb6PQ) (created: 2026-01-8) - [[Labs] StudioHub Template：用 Django 5.2 做一個基底的個人研究開發範本](/vhJ6bPhBTcqjNAxHJpZmVA) (created: 2026-01-9) - [[Labs] Astro + React：把廠內常用圖表做成可維護的 Dashboard Shell](/uHGwXuN0TL6gKUrhbNMo6A) (created: 2026-02-5) - [[Labs] Vue 履歷網站學習筆記：用 Vue 3 做 SPA、主題切換、多語系與資料模組化](/bA6zu-6XSjaZy4_nsPRP-Q) (created: 2026-02-7) Automation & Agents🔒 --- *需登入查看 - [[AI Agent] n8n 自動化記帳（一）：Gmail 刷卡通知 → Google Sheets（HF 免費部署）](/lOsYeAseSoqOv0wxdaSqWQ) *自動化演示 (created: 2025-12-29) - [[AI Agent] n8n 自動化記帳（二）：Drive 月結帳單解析（CSV/PDF）與合併通知](/C_lS0GPDS4mEbawYmqvSFA) *自動化演示 (created: 2025-12-30) - [[AI Agent] n8n 自動化記帳（三）：Discord 私人頻道現金流水 → AI Agent → Google Sheets 入帳](/dm81lUJtTYmdMhIE2k2HBg) (created: 2026-01-6) - [[AI Agent] Infra Track：Discord Interaction Endpoint（n8n 驗簽/解析）與 Zeabur 部署（前置作業）](/c1DRzUN7QwuykwqkJAvfEQ) (created: 2026-01-2) - [[AI Agent] VoiceFlow 簡易自建有語音服務的 AI 日文老師](/5gc0-dBMSmatqqsPROSqMg) ***該篇所有人都可查看** (created: 2026-01-27) Foundations --- - [[Programming Concepts] Understanding Pass by Value and Pass by Reference in C#, TypeScript, and Python](/tDKwN5i9TSGO3rnSCxyoGw) (created: 2025-01-26) - [[Git] Undoing a Merge with Git Reset](/m3swDfsXR02nOWGuFODuEw) (created: 2025-01-28) - [[Git] Simplifying Commit History: Use Reset and Rebase](/olNnv2VURViNKMwO-ZCRTg) (created: 2025-01-28) - [[DevOps] Reverse Proxy / Relay 用 Cloudflare Worker 把實際網址藏在後面](/e9MfbtvRT0K_ygV-W4ZaxQ) (created: 2026-01-6) Frontend --- ### Angular - [[Angular] AG Grid 實戰筆記：動態欄位、列操作按鈕、日期顯示與樣式（TypeScript）](/fRvZaSfCQF-mpsTaUpuY6Q) (created: 2023-08-12) - [[Angular] ngx-bootstrap Modal 實作筆記：ModalService 開啟、initialState 傳值、以及事件訂閱流程](/1QQAckUFRM2iP43uuYpvPQ) (created: 2023-08-13) - [[Angular] Integrating a Modal Component in Angular with ngx-bootstrap](/pCF6HjSoQV6pH1mCd1lLIA) (created: 2024-03-12) - [[Angular] Building a Kanban Board with DragDropModule](/GcgBU-8KTP6CzZ9811z5-w) (created: 2024-03-17) - [[Angular] Using Bootstrap Modal with ngx-bootstrap](/fihZbj2BQ06c1ZuOCr7iCQ) (created: 2024-03-17) - [[Angular] Adding and Managing Buttons in AG Grid](/bTap-KSTS5Sl2DCBgXY1dg) (created: 2024-03-18) - [[Angular] Using AG Grid to Create Tables](/luBC5KgTQD-4YbAFWwmpFQ) (created: 2024-03-19) ### JavaScript - [[JavaScript] 網頁即時顯示時間：Date + setInterval（含 RWD 格式切換）](/hvMQ5q5KSXKdbT9hkb4bcA) (created: 2022-04-19) ### Astro - [[Web] Windows 用 nvm-windows 安裝 Node.js LTS，並建立 Astro 專案](/sfdJj2scQ8m1uzeR7ymfEg) (created: 2026-01-26) - [[Web] Astro Dashboard 實作（一）：MVP 架構、Islands（島嶼架構）](/Aou_ZM2jQ5m80nS_ufEtKQ) (created: 2026-01-28) - [[Web] Astro Dashboard 實作（二）：TopBar 放進 Layout、新增新頁面與 Pareto 繪製](/V082htl4QqGiSCCvT47Bsg) (created: 2026-02-3) - [[Web] Astro Dashboard 實作（三）：設備列表進階（Status Filter）、設備詳情頁（Events Table）、Breadcrumbs（麵包屑導覽）](/fCbZ7Y0vS8qboHCUHuthiw) (created: 2026-02-5) - [[Web] Astro Dashboard 實作（四）：Alerts 中心（Cross-link）與 Severity 視覺分級](/U0zOj2CPRq24G-n6xufZXw) (created: 2026-02-5) Backend --- ### Web / API（FastAPI） - [[API] Parallel Run with Python FastAPI](/-28h67PLQBCGZLsPSwj3Ig) (created: 2025-01-27) - [[API] Multi-Thread with Python FastAPI](/aM2uFs-OTHeepMBc0YwoYA) (created: 2025-01-28) - [[API] Multiprocessing with Python FastAPI](/jXZqeHTES1auguaEo1-0WQ) (created: 2025-01-28) - [[API] Streaming with Python FastAPI](/Yrp8xbBBQzaJfvRIL7Wj4A) (created: 2025-01-28) ### Hosting / Server - [[IIS] 在 IIS 上使用 Python 的配置與運行指南](/TL8v9kkpQsuoYrBz92F6jw) (created: 2025-02-26) Data & Database --- ### MSSQL（Performance） - [[MSSQL] Query Plan Overview](/BsV1gzQbQW6lJEy6NhBAeg) (created: 2025-01-3) - [[MSSQL] Deadlock Overview](/hUWKCstlTyi3IopjfmgppA) (created: 2025-01-26) - [[MSSQL] Index Overview](/3jOETlOHT3mCJDRtAPVLuQ) (created: 2025-01-27) ### MSSQL（Development） - [[MSSQL] Trigger Overview](/D6thQHg8Rjm1yC6M6T93vQ) (created: 2025-01-3) - [[MSSQL] Understanding and Using SQL Functions](/vSNpOne9SuaLS4rXcGBUfw) (created: 2025-01-28) - [[MSSQL] User-Defined Types (UDT) Overview](/z07eoWCJSNqD0PqAXRuXbA) (created: 2025-01-3) ### MSSQL（Security） - [[MSSQL] Roles Permission Management](/j6_-dk94TOKftABEvF0L2w) (created: 2025-03-20) Programming --- ### Python - [[Python] 字串模糊比對：用 FuzzyWuzzy 做相似度計算與簡單搜尋（Levenshtein）](/EdYYCPVOReGM1dQzJ5bppQ) (created: 2023-08-14) ### C# - [[C#] Dependency Injection Guide](/m75f--q3QwqscCIJP4E6WA) (created: 2025-01-26) - [[C#] Using Entity Framework to Connect and Query MSSQL](/GeaafPjaRFKOV7fxJ7lyHg) (created: 2025-01-27) Ops & Troubleshooting --- - [[Support] Python venv 資料夾搬家後壞掉：處理虛擬環境路徑重新定位（不推薦但可救急）](/hYmfJPa2T72pXTTm5Wum-g) (created: 2022-06-16) - [[Support] VSCode 啟用 Python venv 失敗：Activate.ps1 被 ExecutionPolicy 阻擋（PowerShell）](/IYiNMX2ATsy4MfxnfTcN6A) (created: 2023-04-14) - [[Support] Troubleshooting Guide: Citrix Workspace and Unity Engine Crashes](/icvx4pF_R7Sf994pwkfupA) (created: 2024-03-23) - [[Labs] Django 檔案上傳 → 伺服器處理 → 產出結果下載（含 ZIP）](/5s82CLGNQ5Cq5w8_wE5o6g) (created: 2022-04-22) - [[Labs] Django IIS 部署後靜態檔無法顯示：排查思路與解法（回到官方文件）](/u0g7q-24QOqdG_xYDH18tQ) (created: 2022-05-18) - [[Labs] Django IIS 上的 Staticfiles 設定釐清：STATICFILES_DIRS vs STATIC_ROOT（以及 DEBUG 的影響）](/r2QYy49USVyPFJPMMuvpTg) (created: 2022-05-24) Tools（工具 / 設定） --- - [[Tools] yt-dlp 下載 YouTube：我的常用指令整理（含 cookies 與縮圖）](/kqttzHzoTj-eeufel3BomQ) (created: 2022-05-20) - [[Tools] VSCode 我常用的擴充功能清單：從註解、Lint、Git 到專案管理（附記憶體優化設定）](/VLhM-RdtSSmJBlrwTMOHyw) (created: 2023-04-15) Work & Reflection（工作與心得） --- - [[心得] Agile 的工作模式感想](/NSrC6G6QSKCDbsyb2ZemXQ) (created: 2025-01-28)

Syntax	Example	Reference
# Header	Header	基本排版
- Unordered List	Unordered List
1. Ordered List	Ordered List
- [ ] Todo List	Todo List
> Blockquote	Blockquote
Bold font	Bold font
Italics font	Italics font
~~Strikethrough~~	~~Strikethrough~~
19^th^	19^th
H~2~O	H₂O
++Inserted text++	Inserted text
==Marked text==	Marked text
[link text](https:// "title")	Link
![image alt](https:// "title")	Image
`Code`	`Code`	在筆記中貼入程式碼
```javascript var i = 0; ```	`var i = 0;`
:smile:		Emoji list
{%youtube youtube_id %}	Externals
$L^aT_eX$	L^aT_eX
:::info This is a alert area. :::	This is a alert area.