心得 | Howard Lee Cloud

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

By Howard Lee 17 April 2022

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

心得 Tutorial of Basic GraphQL API Service Setup

By Howard Lee 13 March 2022

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

心得 MacOS Monterey(12.1) Use Openssl3.0

By Howard Lee 15 January 2022

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

心得 Experience Learned From Developing a Feature of a Company Product 2021 | 從開發完成近期公司產品的一項使用者體驗功能，學習到的經驗

By Howard Lee 01 January 2022

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

心得 Execution orders of actions of Redux Observable Epic

By Howard Lee 21 December 2021

Received same action(s) within redux will be executed first and then one(s) in epic(s) of redux-observable if there are common action(s) existing in redux and redux-observable.[1] Figure 1. Excerpt statement from redux-observable official site [2] Figure 2. Order sequence diagram for redux-observable. Photo credit to Brian Leathem [3] Redux store is action-in and state-out. Redux-observable is action-in and action-out. Behavior of redux means it generate out new centralize-management state tree

心得 How to Take Over A Web Frontend Product or Project | 如何接手 Web 前端產品/專案

By Howard Lee 13 December 2021

It’s often to take over a web product for frontend-side from colleagues during work. When you’re on-boarding a company for a web frontend engineer role, you may find you situated in a misted forest. You may not see people or cowork with them, because there have some reasons such as they just quit the job or switch to another poducts. In modern frontend develop conventions, there are somethings you can

About

Category

Tag

Social