Building React Router (Remix) web applications
Remix has an HTML first, simple data access philosophy. Most Remix web applications work without JavScript code in the browser. It is possible to create a complete dynamic data driven Remix web application with only server side JavaScript code with pure…
ERROR: relation “…_seq” does not exist
PostgreSQL has three auto increment column types: The pdAdmin 4 user interface unfortunately generates the wrong CREATE script for existing tables: If we execute it, we get the error message: ERROR: relation “test_id_seq” does not existLINE…
Filter search results in Visual Studio Code
When we search in web application source directories, we usually find the same resource and variable names in the build outputs too. To filter out false positive search results, enter the comma separated list of build directory names into the files to…
How to center a DIV with CSS
To center a DIV horizontally React example To center a DIV only vertically React example: To center a DIV horizontally and vertically React example For more information There is a great article by Jamie Juviler at 11 Ways to Center Div or Text in Div in…
Update Google Sheet with typescript
To be able to programmatically update Google Sheets, we need to enable the APIs and Service in Google Cloud Platform. Create a new Google Cloud project Enable the Google Sheet API
Apply Imported Fill Color is not available in Lucid Charts
To display dynamic data on Lucid Charts. we can link Google Sheets to Lucid Chart objects. The Pull fill color from Google Sheets section of the Lucid documents explain how to set the color of an object based on the cell color, but does not mention one…
Configure Epson ET-3850 scanning on Windows 11
Install the Epson ET-3850 scanner driver and scanning utility Connect to the Epson ET-3850 scanner Scan with the Epson ET-3850 scanner
GIMP moves the wrong layer
When you try to move a layer with a transparent logo or text in GIMP, sometimes the background layer moves. By default the Move Tool selects the layer of the dragged pixel regardless of which layer is selected. The tool only selects the correct layer if…
ReferenceError: json is not defined
Remix uses the loader function to provide a behind the scenes API for the browser side script to supply data in JSON format. The function should return serialized data using the json instruction. When you get the error message: ReferenceError: json is…
Initial url (undefined) does not match URL at time of hydration
React web applications pre-render the pages during application build for faster display and “hydrates” them with the client side javascript to make them interactive and to display data. This error can have causes: Initial url (undefined) does…