preloader
Chrome 瀏覽器 v114 對 popover 元件的影響
心得 Chrome 瀏覽器 v114 對 popover 元件的影響

Chrome 瀏覽器在 2023 年 5 月 30 日左右推出 v114 版本後,其中正式啟用 html 標準裡的 popover API ,也就是能在 html 標籤裡使用 popover 功能的相關屬性,呈現原生的 popover 效果。然而,前端 UI 套

read more
推薦財經書 2023
心得 推薦財經書 2023

2 月初在臉書上看到關於 one boy 牌的行銷幻想討論文(不是你學得起的行銷那篇),以及 GAGU 牌的不知道誰,講了公司財務在前兩年快速擴張之下,成本需要快速止

read more
How to Let Docker Containers on Synology NAS Can Be Connected to Internet
心得 How to Let Docker Containers on Synology NAS Can Be Connected to Internet

Many people have problems for setting connectivity between containers, home private network and Internet on Synology NAS. There’re few different points than normal linux systems such as Synology NAS has no built-in docker-compose program and it has the tricky firewall. Below will use them as example: docker images of postgresql A and express.js B from official on dockerhub DSM 6.2.4-25556 Update 6 Reverse proxy server on DSM Firewall on DSM

read more
How to Build @apollo/client to UMD-standard
心得 How to Build @apollo/client to UMD-standard

My goal is to build @apollo/client to UMD standard so that it can be used to browser extension. I always encounter error messages such as ERROR in ./node_modules/@apollo/client/react/context/ApolloConsumer.js 2:0-31 Module not found: Error: Can't resolve 'react' in ...(excerpted) ERROR in ./node_modules/@apollo/client/core/LocalState.js 3:0-40 Module not found: Error: Can't resolve 'graphql' ...(excerpted) Solution as below: Prequisites: You need to install webpack, webpack-cli, and copy-webpack-plugin. I use webpack v5.72.1, webpack-cli v4.9.2 and copy-webpack-plugin

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
How to Convert KML File to PostgreSQL, CSV or SHP format by ogr2ogr within QGIS-LTR | 如何使用 QGIS-LTR 裡的 ogr2ogr 程式,轉換 KML 檔案到 PostgreSQL, CSV 或是 SHP 格式
心得 How to Convert KML File to PostgreSQL, CSV or SHP format by ogr2ogr within QGIS-LTR | 如何使用 QGIS-LTR 裡的 ogr2ogr 程式,轉換 KML 檔案到 PostgreSQL, CSV 或是 SHP 格式

I want to convert data with a KML file to another one with CSV-, SQL- and SHP-format using ogr2ogr, but I encounter the problem about loosing content of KML file what I want. This article is for describing what problems are and what solutions can used for overcome. Problem 1: I can use GUI-based software, which name is QGIS-LTR, with command parameters of ogr2ogr to successfully transform a file from

read more

About

Howard Lee, Frontend-engineer with Angular 7+, Typescript, ReactJS, VueJS. Flutter, Dart, PHP, Ruby, JavaScript, HTML, SASS, CSS, Postgres, MySQL, Web Developer. 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 Form-filling, form-sharing, file-management, repair-managemnt and project-management for construction industry at Suiqui IoT management and EC platform for Liquid Petroleum Gas(LPG) at Wave-In Comm.

Know More

Tag

Social