NODE 2 explaining the fetch.

• 1

• 1

• 1

The SSL (secure socket layer) is a security protocol that establishes an encrypted link between the server and the browser, to keep the data transfered secure.

The nodeJs v17 fixes a security hole of SSL, it requires to update react-scripts on old create-react-app apps.

//For this error
"error:0308010C:digital envelope routines::unsupported"

//Update it to the latest
npm i react-scripts@latest

The cross-origin fetch requests, sent from the ReactJs client to the NodeJs server.js, may be blocked due to browser security restrictions.

We add a middleware to allow the content-type methods.

//The CORS config handles it automatically
app.all('*', function(req, res, next) {
  res.header('Access-Control-Allow-Origin','URLs to trust of allow');
  res.header('Access-Control-Allow-Methods','GET, POST, OPTIONS, PUT, PATCH,DELETE');
  res.header('Access-Control-Allow-Headers','Content-Type');
  if ('OPTIONS' == req.method) {
      res.sendStatus(200);
  } else {
    next();
  }
});

On the ReactJs client we set the fetch configuration object for our own server.js route. Check React-3 for more API fetch().

//The body has to be a string or a formData, so we JSON.stringify()
let [valore, setValore] = useState({
  nomen: "", cognomen: "", pass: "", logged: false,
})

async function mandato(e){
  e.preventDefault()

  let richiesta = {
    method: "POST",    //For the app.post() route in server.js
    body: JSON.stringify(valore),
    headers: {
      'Content-Type': 'application/json'
    }
  }
  
  //The client-side awaits the server to respond, then we parse the results as JSON.
  let response = await fetch("http://localhost:3000/aggiungi", richiesta)
  let json = await response.json()
  console.log( json )
}

The server.js receives and decostructs the request.body, we update the postSQL table and we response.send() the result.

then() pool.query

The response.send() data will be treated as an object, so do not return strings.

//check Database-1 for how to connect a postSQL table
app.post('/aggiungi', (req, res) => {
  let {nomen, cognomen, pass, logged} = req.body
  let query = `INSERT INTO users (username, email, password, loggedin) 
    VALUES ($1, $2, $3, $4)`
    
  pool
    .query( query, [nomen, cognomen, pass, logged] )
    .then((resultado) => {

      if(resultado){
        res.status(202).send(resultado)
       }else{
        res.status(404).send({error: "re-try"})
      }
    })
    .catch (error) {
      console.error(error)
      res.status(500).send("Internal Server Error")
    }
});

Await pool.query

On ReactJs we check the response object by using the status, statusText, and ok properties.

//Once the promise is furfilled we get the response object
//It can read the res.status() we set in the server
let response = await fetch("http://localhost:3000/aggiungi", richiesta)
response.ok ? console.log( response.status ) : console.log(response.statusText)

//The same for the results
let json = response.json()
json.length ? console.log(json) : console.log("Emptyness status")

Deploying a full-stack app on the web

We configure a PostgreSQL database instance and connect to it locally using DBeaver, employing the provided database name, username, and password.

//We connect the DBeaver Host using the Render hostname
//To check the exact location check the external URL
_HostName_.frankfurt-postgres.render.com

From Render to DBeaver

We deploy a server.js web service to handle backend logic.

//For the Build command you can also use
npm install

//Remove any external library for the start command
"scripts": {
  "start": "node server.js",
},

How we import a repository from github

This service connects to the Render-hosted PostgreSQL database using its internal URL, designed to minimize latence between services deployed on Render.

//The Pool connect to the internal URL, storing the included password in .env
require('dotenv').config();
const { Pool } = require("pg");

const connectionString = 
    `postgresql://userdb:${process.env.DATABASE_PASSWORD}@dpg-cupju01opnds7395o040-a/
     databasedb_cxni`;

const pool = new Pool({ connectionString });

The client-side application can be hosted anywhere. It communicates with the backend by making API calls to the URL of the deployed server.js web service.

//It takes path routes as any fetch call.
async function messo(data){
  let resp = await fetch("https://renderserver-1-3wv4.onrender.com/hotels")
  let json = await resp.json()

  console.log( json )
}

connect on server.js render web service

Private data on .env files

The .env file contains environmental variables, used to store configuration data, they are specific to the environment the app is deployed from.

The npm install dotenv module allows us to access the .env data.

//env
DATABASE_PASSWORD= "__password__"

//server.js
require('dotenv').config();
console.log( process.env.DATABASE_PASSWORD )

We include the .env file in the .gitignore, to avoid committing the data in Github.

//.gitignore
/node_modules
.env

We use an environmental variable to allow Render to set up its own Port.

//In local it uses the hardcoded value.
const PORT = process.env.PORT || 3030;
app.listen(PORT, () => console.log("Server is up and running"))

Render allows secure injection of .env data for sensitive information, either through Render's variable option (without "") or by importing/pasting the .env data directly (using "").

ENV database variable

1