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
I had been heard that GraphQL is a great tool for web frontend engineer because frontend engineer can query any form of data for variable needs of mobile-web and app. I want to explore GraphQL how to use, which ecosystem is becoming matured. In this article, we will go through it, and please following indexes. You can learn how to setup basic GraphQL API server without throttling. Article Index Introduction
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
I had found following problem as I install packages of python on macOS Monterey(12.1) by using a third party script: zipfile = ZipFile(StringIO(fp.read())) .pyenv/versions/2.7.18/lib/python2.7/socket.py", line 355, in read data = self._sock.recv(rbufsize) .pyenv/versions/2.7.18/lib/python2.7/ssl.py", line 754, in recv return self.read(buflen) .pyenv/versions/2.7.18/lib/python2.7/ssl.py", line 641, in read v = self._sslobj.read(len) ssl.SSLError: [SSL: KRB5_S_TKT_NYV] unexpected eof while reading (_ssl.c:1946) Briefly analysis for root-cause about this problem This is because macOS upgrade openssl to version 3.0.0
read more
2022 年讀過的書: 灰階思考。(2021 年 9 月購買, 2021 年 12 月 下旬開始讀，2022 年 1 月 6 日看完) podcast 頻道：股癌 的整理內容 講投資心態和理財的原則 被討厭
read more
English version: In the working time at 24th December 2021, I finally finished a critical UX feature of a product from current serving company and I had confirmed it can work as expected. I had been developed this feature over a month and it’s good to send a pull request for merging branch of codebase. Boss considers this feature is critical because of it can resolve headache about uploading files
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