preloader
我的學習進度 2025 | Study Status 2025
學習 我的學習進度 2025 | Study Status 2025

分享我在2025年第一季到四月為止學習內容。 說英文,訂閱 Speak app,每天用幾分鐘練習講英文,主要上課程學生活會話,從去年十二月訂到現在。例如我

read more
學習 Datetime Format With YYYY-MM-DD HH:mm:ss in Nodejs V18 and After | 在 nodejs v18以上版本是用內建函式製作日期時間格式 YYYY-MM-DD HH:mm:ss

Using nodejs v18+ built-in datetime formatter, code are below new Intl.DateimeFormat('fr', { timezone: 'Asia/Taipei', year: 'numeric', month: '2-digit', day: '2-digit', hour: '2-digit', minute: '2-digit', second: '2-digit', }).format(new Date('2024-10-24T10:00:03Z')) print 2024-10-24 18:00:03 It can be used to server and serverless environment such as GCP cloudfunction, …etc.

read more
How to Copy PostGIS Table Data to Another Table
學習 How to Copy PostGIS Table Data to Another Table

I want to copy data in a table within postgis to another table, so I use following sql statement: INSERT INTO yourtablename (SELECT TO_DATE(name, 'YYYY-MM-DD'), TO_NUMBER(area, '9999999999.999999999'), TO_NUMBER(fd_depth, '9999'), TO_DATE(fdate, 'YYYY-MM-DD'), town_name, address, description, effect_range FROM yourtmptablename); Notice: Before you executing above snippet, please make sure yourtablename has same column names as output of column names from SELECT statement. I have encounter data format problem about “-"(hyphen) for numeric column

read more

About

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

Tag

Social