Kajal Rana

Uh, hi. So I am a back end developer, uh, working, uh, in more back end mode JS framework with, uh, along with MySQL database. I'm having, like, uh, work experience of 5.2 years. And I have worked with several other back end technologies like NetJits, Databases like, uh, MySQL, MongoDB. Uh, I'm working my current organization is Bajaj Finser, uh, Health, which is situated in Pune. And I'm working with Bajaj since 2021, and I'm currently working in Bajaj itself. Previously, I was working with, uh, AmStaff technology, which was situated in Bangalore. And, uh, the the text attack was used in AmStaff was AWS and AWS services. And, uh, I am graduated from a college in Zurich in 2019. And I have done my internship in Zurich itself, uh, in. And the company is located in, uh, Surat named, uh, Logic Point. I worked, uh, 2 years in that company, uh, having, uh, worked on various doting projects.

So, um, implementing a middle map for rate limiting. So first, rate limiting is, uh, is to limit the API calls in certain amount of time. So a middleware can be integrated to rate limit. A middleware is something we can access the request and update the response. So we can write the middleware with realty meeting of 10 second per per API per per API file, And we can mention the endpoints. We can attach the middleware to that certain endpoints itself as middleware is plug and play kind of thing.

Indexing means, uh, so index of how the search queries work is the, uh, query will scan whole table if indexing is not done to search the required data. And if indexing is done, uh, the query will target directly to the indexed, uh, position of the data. Hence, the query, the search query, or the simple query will be will faster than the query which which is running on without index k table.

So to to prevent SQL injections in the NodeSource application, we can use SQL string package, which is available in NPM. It will stringify the data, will, uh, not allow the registered keywords, uh, and it will it will prevent it from SQL injections. So SQL stream package will be helpful. Plus, there should be some validations, uh, on the parameters that are, uh, getting fetched from the API call. Validation should be, like we should not allow special characters to result result words, like, select, update, delete, in, and, uh, in the parameters.

We can use Kafka to use the real time updates as it is asynchronous, uh, function that it works on. So Kafka will be the best approach to to use real time data updates. Plus, we can use Azure service bus to update the data in MySQL, uh, database without get without keeping load on database.

No idea.

In this, we can optimize NPM install to NPM install hyphen CI, which will which will install only the necessary package and other will be used from the cache. And uh, instead of copying packages and copy dot to dot will work so we can remove copying of packages and to the directory. Hence, optimization of 2 stack will be done in this.

To guarantee the asset property, we showed you a transaction. So transaction is something that I've used in MySQL queries and MySQL query uses transaction to commit and rollbacks, so the asset property can be achieved by using commit and rollback commit means all the operations are successful, transaction will not commit the changes, if any one of those fails, it will rollback all the changes and nothing will get updated in the database, so partial update will be restricted using transaction, database transaction and we can achieve the asset property.

Uh, we can create an environment file in the Docker file itself. So, uh, we can use Key Vault to, uh, to to to store the sensitive data in the dockerized development instead of keeping in the code base. So we can access it from the keyboard itself. We have to configure the keyboard in the code base, and we can access the keys from there. But so that we cannot directly add we are not directly adding the data, uh, the key and value of the sensitive data code base. So key keyword is the answer for the secure, uh, securely storing sensitive data in Node. Js and Moment.

So there is something called in AWS, there's something called CloudFront where you can monitor the performance of the application by the logs that, uh, AWS will provide. Plus, we can manage the highway traffic by load balancing. And, uh, yeah.

So CICD is continuous integration under this deployment. So, uh, for for the the benefit of using CICD is we don't need to always go and deploy the build manually. So if CICD is integrated, if any, uh, code is being pushed in the target branch, the deployment would automatically will automatically start in the containerized environment. So CICD is very helpful in the deployment where you have large number of team and you have many deployments. So we can set up the deployment using Docker or the Jenkins or Kubernetes to automate the process.