template-string | Simple template strings | 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

Is there a way to avoid having to escape literal curly brackets characters in a python3 f-string?

For example if you want to output a json string or a chunk of CSS rules it's really inconvenient to have to convert all the { and } characters to {{ and }} in case you want to use the f-string syntax.

I am aware that one can use the older syntax of e.g. div {color: %s} % color, 'text {}'.format(abc) or string templates but I wonder if there is a way to use the f-strings on raw text, preferably by having a way to mark the beginning and end of the 'raw' blocks with some kind of delimiter, for example similar to how you can use \Q and \E in a java regex in order to include unescaped raw characters in the regex.

As an alternative, is there something in the standard library that allows taking a chunk of raw text and converting it to an f-string-safe format? (again, similar to how you can use Pattern.quote for java regexes)

I'm trying to fill values in a formula string by using Python Template Strings. The formula sometimes contains identifiers having non-ASCII characters like α, ß, Γ etc. (see Unicode Greek and Coptic Chart). But as per python documentation, the template string is limited to only ASCII identifiers. The default regular expression to match the identifier is (?a:[_a-z][_a-z0-9]*).

How can I extend the default regular expression so it also matches the characters from Unicode Greek and Coptic Chart?

I'm building a website in Gatsby / React with 2 content types: Pages and posts and query my data via GraphQL (in Prismic).

I want to include a "Recent news"-module on the page, showing the latests blogposts.

My question is the following:

Is there a way to access the data directly in my module, without passing the data through every parent React component?

I'm using Prismic in this case, but the same scenario could apply to Contentful, Sanity or any other headless CMS I guess.

This is how I query my data:

I'm making a blog with Gatsby front-end, Strapi back-end. I made a query in component with StaticQuery

This is the technology stack our project uses:

• Symfony 2.8^†
• Twig 1.24^†
• AngularJS 1.5^†
• Webpack 1.12^†

We have an issue that our app.min.js file is cached and when we make changes that require a new app.min.js file, often our clients keep using the cached file instead of loading the new file and end up generating errors and having to call our Support desk.

I've looked into fixing this by embedding the hash of the file contents into the HTTP request, then having the server serve the original file using a rewrite rule. I've added [contenthash]. to the filename in webpack.config.js (see below) but when I run Webpack, it doesn't replace [contenthash], instead creating a file with that exact name.

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: