node-postgres | application demonstrates database operations | Database library

New to SvelteKit and working to adapt an endpoint from a Node/Express server to make it more generic so as to be able to take advantage of SvelteKit adapters. The endpoint downloads files stored in a database via node-postgresql.

My functional endpoint in Node/Express looks like this:

I am using node-postgres and attempting to use to_timestamp and receive the error:

ReferenceError: to_timestamp is not defined

Here is my code:

I'm using node.js w/ PSQL, along with express and node-postgres. I've got a file called config.js. The intention is to have it delete the database then recreate it along with the tables every time it is run. This works every second time, returning an error the other half of the time, and not re-creating the database.

I've looked through all of the documentation, and I'm having some trouble finding examples of the correct implementation. First of all, I have the Heroku Redis add-on as you can see below:

https://i.stack.imgur.com/9kcXW.png

I installed Redis and Bull to my Node.js environment and set up Redis as follows:

I am trying to deploy a serverless REST API with NodeJS, AWS Lambda, API Gateway, RDS and PostgreSQL.

So far I've set up the PostgreSQL RDS successfully and before start writing the functions to handle the requests to the DB I thought it'd be a good idea to test a small function first locally to check if the requests are being handled correctly.

So in the root of the project, I installed serverless-offline:

npm install serverless-offline

It threw several warnings during installation of the type:

npm WARN deprecated @hapi/pez@4.1.2: This version has been deprecated and is no longer supported or maintained

(I'm sorry if that information is irrelevant, I'm quite new and don't know what is important and what is not.)

Then I configured my serverless.yml:

I'm trying to connect with my database postgres, using the node-postgres package, but my connection is not working. I set every parameter that needs to stablish the connection, and even with all being set, I'm not receiving the message in the log that the database is connected. What I'm missing?

My code:

I'm new to postgres-node. Coming from a mySQL background, I'm unlearning old habits and now learning new things. I want to prevent SQL injections when inserting data. I read about parameterized query. Is this applicable to JSON type? I'm doing CRUD operations on a table in postgres that only have 2 columns. I'm manipulating JSON data (SELECT, INSERT and UPDATE). How do you prevent SQL injections when inserting JSON data in a table?

table

I have a route (in a node JS app) that inserts and updates some data in a PostgreSQL database (version 13).

In pseudo-code, here are all queries that are done in sequential order:

I'm working on a side project and have hit a bit of a dead end when coming across this error. I've ascertained that it's originating from node-postgres package somewhere, but I see nothing inherently wrong with my query!

Here's my code: