sql-template | Nodejs template string for SQL queries | Runtime Evironment library

In my NextJS Vercel app, I am unable to successfully connect to my remote MySQL database which is located on GoDaddy, after following Vercel's official tutorial.

I expect the api pages to return JSON data that resulted from the database query. Instead I am getting

I tried changing the username, but for some reason, the 4 environment variables that I have - MYSQL_USER, MYSQL_DATABASE, MYSQL_HOST, and MYSQL_PASSWORD - never update on the live site! I changed in Production, Preview, and even Development, and they stay the same in the above link’s object.

Everything works fine on my localhost because my home IP address is whitelisted in cPanel. But Vercel has dynamic IPs so I can't do this on the live site. It also works fine if I host on GoDaddy, but I need to host on Vercel.

Here’s my source code for the db.js file which connects to the database

lib/db.js

I'm getting the following error when deploying to Vercel:

I'm trying to get an Express application to return a generated PDF. As per this answer, I'm trying to use the jsPDF library, with some fake globals. Also adding to the confusion is that the data is being fetched from a Postgres source.

I've never used .blob() before, and I suspect that that's the reason I'm not getting a response. Is there something obvious that I'm missing?

I've revised the question, in the hope of getting a clearer answer.

I'm trying to process data in ExpressJS, based on the incoming req.body and the existing data in the table.

I'm receiving a req.body that contains a JSON list of updated fields. Some of those fields are stored as JSONB in Postgres. If an incoming field is JSONB, then the form (external code) that is making the request has already run a jsonpatch.compare() to generate the list of patches, and it is these patches and not the full values that are being passed in. For any non-JSONB values, incoming values just need to be passed through to the UPDATE query.

I have a working version, as below, that pretends that the existing JSONB values in the table ARE NULL. Clearly, this is NOT what is needed. I need to pull the values from the db. The non-querying-of-current-values version and a bare minimum router, looks like this:

I have a large table of data (rendered using AG-Grid) and I want update it in the Postgres backend, but the best approach to the next part has me prevaricating, in terms of the amount of work, and the best course of actions.

Using the fast-json-patch library, I can get a JSON patch list easily enough in the client, and then something roughly thus:

I'm trying to use the sql template strings npm package to use template literals in my SQL queries securely, but I keep getting an error that states that there is a problem with the sql syntax. When I omit the "SQL" bit, everything works. I've installed the sql-template-strings package. What am I missing? Help appreciated!

I've written a pretty simple DAG that first does some python operations and afterwards should update a Database-Table with the returned value. Here is the DAG-Code:

I'm currently creating some API with Zeit Now, and I was trying to implement 404 error when the user variable is [] (an empty array), but when I fetch this endpoint, API is sending [] aswell. How can I implement it? Is it because the user is a promise?

I'm having trouble understanding where the undefined is coming from, during the following jest test. Here's the source file: