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
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
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
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