---
# System prepended metadata

title: Learning Notes
tags: [Python, Angular, API, C#, MSSQL, Git, Book, Note]

---

Learning Notes
===

Main Page
---
- [Learning Notes](/_eGhc-AfQ16Z4rHwV4qkuA)

Labs
---
> 我自己製作 / 實作 / 串接的內容（含工具鏈、流程驗證、原型）

- [[Labs] Azure 免費資源試用心得：Microsoft Bot 服務、VM 架設與 HTTPS（ngrok）踩坑紀錄](/bs9AfL7nSVuj2iTvBISHgg) <small>(created: 2023-04-21)</small>
- [[Labs] Flask Web 旅行路線規劃器（串 Google Directions API + 地圖呈現）](/u3wniiuLR6S4p_36yv8mOA) <small>(created: 2023-07-15)</small>
- [[Labs] Twitch 開播通知機器人：用 Discord.py + Twitch Helix API 做直播提醒](/6GMAPXwRSoq00NsGX5s3pg) <small>(created: 2023-07-18)</small>
    - [[Labs] Twitch 開播通知機器人（二）：支援多伺服器/多頻道設定（Server ID + Channel ID + SQLite）](/7GU7BrnrR1S4y2Ao1yKclA) <small>(created: 2023-07-25)</small>
- [[Labs] 轉寫結果匯出字幕：Python Export to SRT](/VuZLlcUUS7a5QgJ0rKSszg) <small>(created: 2025-07-18)</small>
    - [[Labs] 本機多人語音轉寫：WhisperX + Hugging Face 實作筆記](/nUsT0PwNRfu9jjXkYISsyg) <small>(created: 2025-08-5)</small>
    - [[Labs] GPU 加速字幕處理：Colab T4 + Whisper 實作紀錄](/6I_Xup-BQkSYHC13zBikRg) <small>(created: 2025-08-6)</small>
- [[Labs] 用 Pandoc + Python 將 DOCX 轉 EPUB：實作筆記](/Um-BFxDZT4iMyaH07eZgHA) <small>(created: 2025-08-16)</small> 
- [[Labs] Relay 隱藏 n8n Webhook 並轉發 Discord](/A33W-24gSXOTLAvge0CUiw)  <small>(created: 2026-01-7)</small> 
- [[Labs] 用 VenvManager 管理多個 Python venv（Windows / Tkinter GUI）](/kELV7mvjSpKjF1ivjSb6PQ) <small>(created: 2026-01-8)</small>
- [[Labs] StudioHub Template：用 Django 5.2 做一個基底的個人研究開發範本](/vhJ6bPhBTcqjNAxHJpZmVA) <small>(created: 2026-01-9)</small>
- [[Labs] Astro + React：把廠內常用圖表做成可維護的 Dashboard Shell](/uHGwXuN0TL6gKUrhbNMo6A) <small>(created: 2026-02-5)</small>
- [[Labs] Vue 履歷網站學習筆記：用 Vue 3 做 SPA、主題切換、多語系與資料模組化](/bA6zu-6XSjaZy4_nsPRP-Q) <small>(created: 2026-02-7)</small>

Automation & Agents🔒
---
*需登入查看

- [[AI Agent] n8n 自動化記帳（一）：Gmail 刷卡通知 → Google Sheets（HF 免費部署）](/lOsYeAseSoqOv0wxdaSqWQ) *自動化演示  <small>(created: 2025-12-29)</small>
    - [[AI Agent] n8n 自動化記帳（二）：Drive 月結帳單解析（CSV/PDF）與合併通知](/C_lS0GPDS4mEbawYmqvSFA) *自動化演示  <small>(created: 2025-12-30)</small>
    - [[AI Agent] n8n 自動化記帳（三）：Discord 私人頻道現金流水 → AI Agent → Google Sheets 入帳](/dm81lUJtTYmdMhIE2k2HBg) <small>(created: 2026-01-6)</small>
- [[AI Agent] Infra Track：Discord Interaction Endpoint（n8n 驗簽/解析）與 Zeabur 部署（前置作業）](/c1DRzUN7QwuykwqkJAvfEQ)  <small>(created: 2026-01-2)</small>
- [[AI Agent] VoiceFlow 簡易自建有語音服務的 AI 日文老師](/5gc0-dBMSmatqqsPROSqMg) ***該篇所有人都可查看**  <small>(created: 2026-01-27)</small> 

Foundations
---
- [[Programming Concepts] Understanding Pass by Value and Pass by Reference in C#, TypeScript, and Python](/tDKwN5i9TSGO3rnSCxyoGw) <small>(created: 2025-01-26)</small>
- [[Git] Undoing a Merge with Git Reset](/m3swDfsXR02nOWGuFODuEw) <small>(created: 2025-01-28)</small>
- [[Git] Simplifying Commit History: Use Reset and Rebase](/olNnv2VURViNKMwO-ZCRTg) <small>(created: 2025-01-28)</small>
- [[DevOps] Reverse Proxy / Relay 用 Cloudflare Worker 把實際網址藏在後面](/e9MfbtvRT0K_ygV-W4ZaxQ) <small>(created: 2026-01-6)</small>

Frontend
---
### Angular
- [[Angular] AG Grid 實戰筆記：動態欄位、列操作按鈕、日期顯示與樣式（TypeScript）](/fRvZaSfCQF-mpsTaUpuY6Q) <small>(created: 2023-08-12)</small>
- [[Angular] ngx-bootstrap Modal 實作筆記：ModalService 開啟、initialState 傳值、以及事件訂閱流程](/1QQAckUFRM2iP43uuYpvPQ) <small>(created: 2023-08-13)</small>
- [[Angular] Integrating a Modal Component in Angular with ngx-bootstrap](/pCF6HjSoQV6pH1mCd1lLIA) <small>(created: 2024-03-12)</small>
- [[Angular] Building a Kanban Board with DragDropModule](/GcgBU-8KTP6CzZ9811z5-w) <small>(created: 2024-03-17)</small>
- [[Angular] Using Bootstrap Modal with ngx-bootstrap](/fihZbj2BQ06c1ZuOCr7iCQ) <small>(created: 2024-03-17)</small>
- [[Angular] Adding and Managing Buttons in AG Grid](/bTap-KSTS5Sl2DCBgXY1dg) <small>(created: 2024-03-18)</small>
- [[Angular] Using AG Grid to Create Tables](/luBC5KgTQD-4YbAFWwmpFQ) <small>(created: 2024-03-19)</small>

### JavaScript
- [[JavaScript] 網頁即時顯示時間：Date + setInterval（含 RWD 格式切換）](/hvMQ5q5KSXKdbT9hkb4bcA) <small>(created: 2022-04-19)</small>

### Astro
- [[Web] Windows 用 nvm-windows 安裝 Node.js LTS，並建立 Astro 專案](/sfdJj2scQ8m1uzeR7ymfEg) <small>(created: 2026-01-26)</small>
- [[Web] Astro Dashboard 實作（一）：MVP 架構、Islands（島嶼架構）](/Aou_ZM2jQ5m80nS_ufEtKQ) <small>(created: 2026-01-28)</small>
    - [[Web] Astro Dashboard 實作（二）：TopBar 放進 Layout、新增新頁面與 Pareto 繪製](/V082htl4QqGiSCCvT47Bsg) <small>(created: 2026-02-3)</small>
    - [[Web] Astro Dashboard 實作（三）：設備列表進階（Status Filter）、設備詳情頁（Events Table）、Breadcrumbs（麵包屑導覽）](/fCbZ7Y0vS8qboHCUHuthiw) <small>(created: 2026-02-5)</small>
    - [[Web] Astro Dashboard 實作（四）：Alerts 中心（Cross-link）與 Severity 視覺分級](/U0zOj2CPRq24G-n6xufZXw) <small>(created: 2026-02-5)</small>

Backend
---
### Web / API（FastAPI）
- [[API] Parallel Run with Python FastAPI](/-28h67PLQBCGZLsPSwj3Ig) <small>(created: 2025-01-27)</small>
- [[API] Multi-Thread with Python FastAPI](/aM2uFs-OTHeepMBc0YwoYA) <small>(created: 2025-01-28)</small>
- [[API] Multiprocessing with Python FastAPI](/jXZqeHTES1auguaEo1-0WQ) <small>(created: 2025-01-28)</small>
- [[API] Streaming with Python FastAPI](/Yrp8xbBBQzaJfvRIL7Wj4A) <small>(created: 2025-01-28)</small>

### Hosting / Server
- [[IIS] 在 IIS 上使用 Python 的配置與運行指南](/TL8v9kkpQsuoYrBz92F6jw) <small>(created: 2025-02-26)</small>

Data & Database
---
### MSSQL（Performance）
- [[MSSQL] Query Plan Overview](/BsV1gzQbQW6lJEy6NhBAeg) <small>(created: 2025-01-3)</small>
- [[MSSQL] Deadlock Overview](/hUWKCstlTyi3IopjfmgppA) <small>(created: 2025-01-26)</small>
- [[MSSQL] Index Overview](/3jOETlOHT3mCJDRtAPVLuQ) <small>(created: 2025-01-27)</small>


### MSSQL（Development）
- [[MSSQL] Trigger Overview](/D6thQHg8Rjm1yC6M6T93vQ) <small>(created: 2025-01-3)</small>
- [[MSSQL] Understanding and Using SQL Functions](/vSNpOne9SuaLS4rXcGBUfw) <small>(created: 2025-01-28)</small>
- [[MSSQL] User-Defined Types (UDT) Overview](/z07eoWCJSNqD0PqAXRuXbA) <small>(created: 2025-01-3)</small>

### MSSQL（Security）
- [[MSSQL] Roles Permission Management](/j6_-dk94TOKftABEvF0L2w) <small>(created: 2025-03-20)</small>

Programming
---
### Python
- [[Python] 字串模糊比對：用 FuzzyWuzzy 做相似度計算與簡單搜尋（Levenshtein）](/EdYYCPVOReGM1dQzJ5bppQ) <small>(created: 2023-08-14)</small>

### C#
- [[C#] Dependency Injection Guide](/m75f--q3QwqscCIJP4E6WA) <small>(created: 2025-01-26)</small>
- [[C#] Using Entity Framework to Connect and Query MSSQL](/GeaafPjaRFKOV7fxJ7lyHg) <small>(created: 2025-01-27)</small>

Ops & Troubleshooting
---
- [[Support] Python venv 資料夾搬家後壞掉：處理虛擬環境路徑重新定位（不推薦但可救急）](/hYmfJPa2T72pXTTm5Wum-g) <small>(created: 2022-06-16)</small>
- [[Support] VSCode 啟用 Python venv 失敗：Activate.ps1 被 ExecutionPolicy 阻擋（PowerShell）](/IYiNMX2ATsy4MfxnfTcN6A) <small>(created: 2023-04-14)</small>
- [[Support] Troubleshooting Guide: Citrix Workspace and Unity Engine Crashes](/icvx4pF_R7Sf994pwkfupA) <small>(created: 2024-03-23)</small>
- [[Labs] Django 檔案上傳 → 伺服器處理 → 產出結果下載（含 ZIP）](/5s82CLGNQ5Cq5w8_wE5o6g) <small>(created: 2022-04-22)</small>
    - [[Labs] Django IIS 部署後靜態檔無法顯示：排查思路與解法（回到官方文件）](/u0g7q-24QOqdG_xYDH18tQ) <small>(created: 2022-05-18)</small>
    - [[Labs] Django IIS 上的 Staticfiles 設定釐清：STATICFILES_DIRS vs STATIC_ROOT（以及 DEBUG 的影響）](/r2QYy49USVyPFJPMMuvpTg) <small>(created: 2022-05-24)</small>

Tools（工具 / 設定）
---
- [[Tools] yt-dlp 下載 YouTube：我的常用指令整理（含 cookies 與縮圖）](/kqttzHzoTj-eeufel3BomQ) <small>(created: 2022-05-20)</small>
- [[Tools] VSCode 我常用的擴充功能清單：從註解、Lint、Git 到專案管理（附記憶體優化設定）](/VLhM-RdtSSmJBlrwTMOHyw) <small>(created: 2023-04-15)</small>

Work & Reflection（工作與心得）
---
- [[心得] Agile 的工作模式感想](/NSrC6G6QSKCDbsyb2ZemXQ) <small>(created: 2025-01-28)</small>
