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>
{"title":"Learning Notes","description":"Learning Notes","contributors":"[{\"id\":\"ea6e9986-5315-483b-9b7b-9d3ae52afb57\",\"add\":20483,\"del\":12977,\"latestUpdatedAt\":1770447165015}]"}
Expand menu