Timeline

2024  6

October  2

Regex 進階用法 - Lookbehind 與 lookahead

<span title='2024-10-25 18:12:13 +0800 +0800'>October 25, 2024</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;267 words&nbsp;·&nbsp;Madi

MySQL 資料修復 (Force InnoDB Recovery)

<span title='2024-10-20 19:49:13 +0800 +0800'>October 20, 2024</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;219 words&nbsp;·&nbsp;Madi

September  1

MySQL 備份筆記

<span title='2024-09-10 19:49:13 +0800 +0800'>September 10, 2024</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;241 words&nbsp;·&nbsp;Madi

July  1

[小專案] 自動辨識藥丸數量的網站

<span title='2024-07-29 15:50:04 +0800 +0800'>July 29, 2024</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;214 words&nbsp;·&nbsp;Madi

June  1

整理 PostgreSQL 的 Index 類型

<span title='2024-06-18 20:50:04 +0800 +0800'>June 18, 2024</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;541 words&nbsp;·&nbsp;Madi

May  1

初探傳統關聯式資料庫如何處理高併發情境

<span title='2024-05-05 00:49:13 +0800 +0800'>May 5, 2024</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;611 words&nbsp;·&nbsp;Madi

2023  21

May  2

深究 PostgreSQL 底層架構

<span title='2023-05-30 19:49:13 +0800 +0800'>May 30, 2023</span>&nbsp;·&nbsp;4 min&nbsp;·&nbsp;750 words&nbsp;·&nbsp;Madi

Redis - 被挖礦病毒入侵攻擊的事件紀錄

<span title='2023-05-16 00:49:13 +0800 +0800'>May 16, 2023</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;303 words&nbsp;·&nbsp;Madi

March  4

FastAPI 該用 async def 還是 def?

<span title='2023-03-28 19:49:13 +0800 +0800'>March 28, 2023</span>&nbsp;·&nbsp;4 min&nbsp;·&nbsp;651 words&nbsp;·&nbsp;Madi

初探 Prometheus 與 Grafana

<span title='2023-03-18 19:49:13 +0800 +0800'>March 18, 2023</span>&nbsp;·&nbsp;4 min&nbsp;·&nbsp;756 words&nbsp;·&nbsp;Madi

[閱讀筆記] Design Data-Intensive Application - Storage and Retrieval (OLAP)

<span title='2023-03-03 00:49:13 +0800 +0800'>March 3, 2023</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;352 words&nbsp;·&nbsp;Madi

[閱讀筆記] Design Data-Intensive Application - Storage and Retrieval (OLTP)

<span title='2023-03-03 00:49:13 +0800 +0800'>March 3, 2023</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;361 words&nbsp;·&nbsp;Madi

February  5

JWT & SendGrid - 實作電商忘記密碼

<span title='2023-02-27 00:49:13 +0800 +0800'>February 27, 2023</span>&nbsp;·&nbsp;5 min&nbsp;·&nbsp;923 words&nbsp;·&nbsp;Madi

React - useEffect cleanup with fetch abort

<span title='2023-02-21 09:32:04 +0800 +0800'>February 21, 2023</span>&nbsp;·&nbsp;4 min&nbsp;·&nbsp;745 words&nbsp;·&nbsp;Madi

Node.js - Socket.io 實作多人聊天室

<span title='2023-02-10 00:49:13 +0800 +0800'>February 10, 2023</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;585 words&nbsp;·&nbsp;Madi

密碼學中的 Encode(編碼)、Encrypt(加密) 跟 Hash(雜湊) 差異

<span title='2023-02-06 19:49:13 +0800 +0800'>February 6, 2023</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;521 words&nbsp;·&nbsp;Madi

DNS紀錄 - CNAME vs A record vs ACME-Challenge

<span title='2023-02-05 00:49:13 +0800 +0800'>February 5, 2023</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;386 words&nbsp;·&nbsp;Madi

January  10

Docker: PostgreSQL Backup & Restore

<span title='2023-01-31 00:49:13 +0800 +0800'>January 31, 2023</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;328 words&nbsp;·&nbsp;Madi

資料實時更新的方式 - Client Pull vs Server Push

<span title='2023-01-31 00:49:13 +0800 +0800'>January 31, 2023</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;638 words&nbsp;·&nbsp;Madi

為何Mac建置的Docker映像檔無法運行於Ubuntu上?

<span title='2023-01-25 21:49:13 +0800 +0800'>January 25, 2023</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;501 words&nbsp;·&nbsp;Madi

PostgreSQL-Constraint學習筆記

<span title='2023-01-25 19:49:13 +0800 +0800'>January 25, 2023</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;527 words&nbsp;·&nbsp;Madi

初探Caddy搭建AWS EC2的HTTPS Web Server

<span title='2023-01-24 09:32:04 +0800 +0800'>January 24, 2023</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;487 words&nbsp;·&nbsp;Madi

[閱讀筆記] Transactionally Staged Job Drain in PostgreSQL

<span title='2023-01-22 00:49:13 +0800 +0800'>January 22, 2023</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;421 words&nbsp;·&nbsp;Madi

Git Submodule 學習筆記

<span title='2023-01-20 19:49:13 +0800 +0800'>January 20, 2023</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;560 words&nbsp;·&nbsp;Madi

細究Content-Type的Multipart/form-data

<span title='2023-01-18 19:49:13 +0800 +0800'>January 18, 2023</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;294 words&nbsp;·&nbsp;Madi

PostGIS: 踩坑TWD67座標錯誤

<span title='2023-01-17 19:49:13 +0800 +0800'>January 17, 2023</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;387 words&nbsp;·&nbsp;Madi

新居落成: Hugo x Jamstack x Render

<span title='2023-01-11 19:49:13 +0800 +0800'>January 11, 2023</span>&nbsp;·&nbsp;3 min&nbsp;·&nbsp;440 words&nbsp;·&nbsp;Madi