Using Caching to pull the Data from SQL server

Question

Hallo !
In this code I pull the data "Products" from SQL server and calculate the time the request takes to get all the products. The question is, how can I do the same task, but using "the cache" by adding it by redis ?......................... Noting that I saw an example explaining how to retrieve data from the net using Caching, but I want to get it from the SQL server not from net, how can I do that?

and this is my code:

productController.js:

const Product = require('../Models/productModel');
const express=require('express');
const takeData = async(req, res) => {
const dbResult =await Product.findAll(req.Product)
const allProducts = dbResult.recordset;
return res.status(200).json({message: '', products: allProducts})
}
module.exports = {
takeData:takeData
}

productModel.js:

const UniqueId = require('uniqid');
const SingletonSqlHandler = require('../SQLServer/singleton');
class Product {
constructor(ProductName, Price) {
this.ProductID = UniqueId();
this.ProductName=ProductName;
this.Price=Price
}
static async findAll(ProductID) {
const Pull_Products=await
SingletonSqlHandler.instance.sendQuery('SELECT * from
dbo.getAllProducts()')
return Pull_Products;
}
}
module.exports = Product

productRoute.js:

const router = require('express').Router();
const productController=require('../Controllers/productController')
router.get('/takeData', productController.takeData);
module.exports = router;

This is an example of pull the data from the net:
https://medium.com/tech-tajawal/introduction-to-caching-redis-node-js-e477eb969eab
This article is a very simple introduction to Redis and how caching works, by

Answer 1

You got to Install and start Redis server