學習
我的學習進度 2025 | Study Status 2025
分享我在2025年第一季到四月為止學習內容。 說英文，訂閱 Speak app，每天用幾分鐘練習講英文，主要上課程學生活會話，從去年十二月訂到現在。例如我
read more
分享我在2025年第一季到四月為止學習內容。 說英文，訂閱 Speak app，每天用幾分鐘練習講英文，主要上課程學生活會話，從去年十二月訂到現在。例如我
read moreUsing 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
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
Circular import components are common within nodejs and graphql. This article provide a easy way to resolve that warning. The easy solution is adding related imports to limited scope in javascript instead of importing them at file start position. The example scenario contains three parts: User, Role and UserRoleRel. An user has many roles and a role has many user had been taken. The relationship of many-to-many is recorded at
read more
2022 年讀過的書: 灰階思考。(2021 年 9 月購買, 2021 年 12 月 下旬開始讀，2022 年 1 月 6 日看完) podcast 頻道：股癌 的整理內容 講投資心態和理財的原則 被討厭
read more
If you want to upload file content to remote server using Angular, there are roughly two kinds of methods can achieve requirements. First is about raw file content. You can upload raw content with other values of form fields together, and their values will be separated automatically by browsers using Content-Type: multipart/form. myForm: FormGroup = null; fileName: string = ''; /** * constructor of a component */ constructor( private _formBuilder:
read more
Howard Lee, Frontend-engineer with Typescript, JavaScript, HTML, CSS, Angular 19+, ReactJS, Next.js, GraphQL, Tanstack Query, Material-UI, Cypress, Postgres, Amazon Web Services, Google Cloud Platform Docker and TestCafe. Have a certificate of AWS Solution Architect Associate with verify number: 8FYNL55LCEEQ10W5. You can verify at AWS Certificate site or Credly site Tech lead role Lead 4 colleagues to build products and infrastructure Coordinate schedule of delivering products Senior web frontend developer role Products Team-management, form-filling, form-sharing, file-management, repair-management and project-management for construction industry at Suiqui IoT management and EC platform for Liquid Petroleum Gas(LPG) at Wave-In Comm.
Know More