軟體工程
為 Postgres 全文搜尋加速 - 在表格加上 tsvector
寫了一陣子的英文部落格文章，這篇用中文書寫調劑一下。Postgres 在 8.3 版之後的版本開始提供全文搜尋功能，資料表上若沒加上 tsvector 的欄位，每次查詢
read more
寫了一陣子的英文部落格文章，這篇用中文書寫調劑一下。Postgres 在 8.3 版之後的版本開始提供全文搜尋功能，資料表上若沒加上 tsvector 的欄位，每次查詢
read moreUse below command to start/restart/stop the postgresql easily: brew services start postgresql brew services restart postgresql brew services stop postgresql Reference: How to start postgreSQL server on mac os x? http://stackoverflow.com/a/24251522/2704360
read more從CSV格式檔案倒資料到PostgreSQL資料庫，倒入CSV的全部欄位到PostgreSQL資料表的部份欄位，建議填寫指令的欄位順序要跟C
read more
Howard Lee is a Staff Software Engineer based in Taipei, specializing in frontend architecture, CI/CD, and production-quality engineering for enterprise web applications. With 13+ years of software development experience, Howard has worked across B2B SaaS, IoT energy-management platforms, online travel marketplaces, and Android applications. His work focuses on modernizing large frontend systems, improving delivery quality, and building reliable product workflows with automated testing, observability, and practical cloud/platform integration. Core Expertise Frontend architecture: Angular 5 to 19 modernization, TypeScript, JavaScript, React, Next.
Know More