Pankaj Patidar

My name is Pankaj Panditha and I have 7 years of experience in development, 5.4 years in GIS. I have worked with the old 3D framework, such as Express and Fastify, and a little bit about Core. I have 1 year of experience in Angular version 8. I work with databases like MySQL, MongoDB, and PostgreSQL, and I also work with AWS services. So, one of the Node projects we are using AWS Lambda and EventBridge for triggering Cron jobs from the Node script. For demo purposes, I have created one POC with API gateway implementation using different methods, and I am using DynamoDB also for small user CRUD. So, that's what I have and I work with; majorly, I work on e-commerce projects and admin APIs, for which we have created APIs for Node.js using Express and Fastify also.

Directing with the database. Okay. So in MySQL and Postgres, if you're doing some cluster indexing, then if you're not doing any indexing, the database is going slow. If you're doing indexing, then the database performance is very high. And with the help of Node JS, we can access the database. So, for making any API, you know, we can easily interact with the database from normal applications.

So, here we are, we are using Express. And what we expect we are getting this kind of error? So from that one, we are using Express. In Express, we are using the OK. So here, we are creating a middleware, and then we can check like whatever the memory we are using for the application.

So, if you have to import the database in the backend, then with the Express framework, we are using JWT authentication method. And we are restoring the JWT token for the particular user in the DB, and then we are checking with the middleware. With the help of middleware, we can check if the particular request is coming from the particular user or not. So that, we can handle the authentication part in the Express application. We are checking like that particular user is logged in with different devices, then we can check the device ID and the token, whatever the token we have entered for the user while the user is logged in, we have created a token. The same token we expect from the frontend, like any front-end application.

Suppose yes. So, with Postgres, if we are using a migrations file with the Simple ORM tool or Postgres or PG tool, we can use the next and this ORM tool if we are using the ones that have already provided the migration. So, we are creating a migration for that particular schema. As per the migration, the schema is created on the database. So, we can create the migration file, and we can run this migration file first, and then we can create data for development purposes. Then we can create the schema of the tables in the PostgreSQL database and the MySQL database. And not just the application when we run the migration. So, we can run the migration. We configure this migration command in our start descriptor of the Node JS project, then we can easily handle all the migration files.

What technique do you use to perform real-time data update in a Modis application that uses a MySQL database? Okay, so in the MySQL database, if we want to update data, then we use an update query or we write a log query. If we want to use any ORM tool, then we can use a pre-built ORM tool query for updation. To update data in the database directly, we can do that. In a Node.js application, there is a package called socket.io. For that, we can trigger all the events for updating the data. We can trigger all the database triggers once we need the data operation. So we can easily do that kind of thing. We can do that trigger with the help of a trigger, and we can easily set a.

The Docker file would be meant to set up an auto application. Can you identify an optimization that could be made? So here, we can configure in place of the two copy commands. You can remove one copy and we can configure as follows. I'm thinking we are ready to proceed. Because it's just not an app like this.

So, in Express, with the express relation, if we're using Postgres and MySQL databases, both support transactions. With the help of transactions, we can achieve the atomic property in our application script. So, suppose we're writing an Express application, creating a migration, and inside the migration, we can write code for transactions, like ways. Or, we can write support some code in transaction code in our application controller also. So, once we run the application controller, the transaction is running, and we need to handle install, commit, and rollback easily. Suppose we want to use order processing. While the order process, we're inserting data into different tables. Here, we can do one thing. Here, we can implement transactions. And with the help of transactions, we can achieve this as a property for the order process.

This application without exposing sensitive data and for personal control system. How will you manage secrets for access to the application? Okay. So, Docker and Docker's development environment. We can be inside Docker, we have a security purpose thing. Docker means like we have a container. So in Docker, we have different kinds of containers. So every container has its own authentication process and services for multiple services we use there. So there's no particular service that exposes sensible data. So here, each Docker container has its own authentication services.

In heavy traffic scenario, how will we do it? Okay. So, in AWS tool, we can use easily the logs. We can implement there the logs. So, we control logs, and we can use event bridge and AWS services for checking the performance effectively of the node US code. So, if we use crumbs in our code, then we can do separate things. We are just hitting the routes from every day. So, we can easily manage from there. We can set up other things there.

So, we can use the CICD pipeline for deploying our application to server. If you want to use, we can use AWS for also. I'll have both commit and CICD pattern we can do here for the business, all these things. With the help of CICD DevOps, we can streamline deployment process, centralize our node just application. And, with the setup of our gate repository, we can directly push code in gate also, then the code creates a build, CICD pipeline creates a build, and then they deploy to our server.