Knowledge Base for IT Professionals, Teachers and Astronauts
If your PostgreSQL database table contains “timestamp with time zone []” or “timestamp without time zone []” type columns and you want to convert them to “timestamp with time zone” or “timestamp without time zone” type, add the USING directive to the ALTER COLUMN command to tell PostgreSQL how to convert the array to the scalar value. In …
Continue reading “How to convert PostgreSQL array column to scalar column type”
React web applications (Next.js, Remix) use React hooks to transfer data between the server side and browser side code. Remix uses the loader() function to run code on the server to produce data for the web page, and the instruction in the browser code to receive it. When the compiler throws the TypeScript error: TypeError: Cannot …
Continue reading “TypeError: Cannot destructure property ‘…’ of ‘useLoaderData(…)’ as it is null.”
Application configuration At this point Remix version 1 is “forward compatible”. It already contains the version 2 features, and you can start to use them before the official release. To enable the version 2 features in version 1 Migration notes Referencing files Instead of @ use ~ to refer to the root of the site, …
Continue reading “Migrating a Next.js web application to Remix”
If the table has no primary key, pgAdmin 4 cannot identify them, so disables the row insert and edit. Lock icons appear next to the column names, and the Add row button is disabled. To be able to edit table rows in pgAdmin4, select the primary key column of the table.
The Next.js React web application runs separate code on the server and in the browser. By default, the environment variables are only accessible in the server side script. Warning: by exposing environment variables to the browser code you may reveal secrets. Make sure the exposed environment variables do not contain any secrets. If secrets are …
Continue reading “How to expose Next.js environment variables to the browser specific code”
When the Node.js application runs correctly in the development environment, but throws the following error in higher environments: Error: Cannot find module ‘…’ Make sure the module is not listed in the “devDependencies” section of the package.json and package-lock.json files. If you have installed a package with the –save-dev @types/… option, the package is considered a …
Continue reading “Error: Cannot find module ‘…’ outside of the development environment”
Download the React Developer Tools for the browser you use from https://react.dev/learn/react-developer-tools
When the parameterized PostgreSQL statement has more elements in the “VALUES” option than the number of columns specified, we get the error message: error: INSERT has more expressions than target columns In the sample code below there are two columns listed, and there are three elements in the “VALUES” option. Solution Remove the extra elements …
Continue reading “error: INSERT has more expressions than target columns”
For security reasons we should always use parameterized queries to avoid SQL injections through parameters. The usual format is When a PostgreSQL command runs and a parameter is not used, we get the error message error: could not determine data type of parameter $1 Solution: Remove the unused parameter from the “parameters” array, in this …
Continue reading “error: could not determine data type of parameter $1”
If your Next.js React TypeScript web application uses database calls to display data on the pages, and during build time the database is not available, we need to disable the static page generation, otherwise we get the following error: info Generating static pages…TypeError: Failed to parse URL from ……code: ‘ERR_INVALID_URL’ To disable the static page …
Continue reading “How to disable static page generation during Next.js site build”