Kunal Mehta

My name is Kunal, and I'm a senior software engineer at SOROCO. And I'm working in multiple technologies like Python, c sharp, Python, Pandas. And, uh, for the database part, we're using Postgres. In the past, I have worked in multiple text, like csharp.netcoreandangular, uh, for the front end. And also have used bit of React also. I've worked in Fintech and, uh, health care domains too. In past, I worked in Ola Financial Services and, uh, I guess, health. I've done my post graduation diploma from my in advanced computing from CDEC Pune, and I've done my, uh, bachelor's in computer science in from the Technological Institute of Textile and Science, Bhiwani. Yeah. That is all pretty much about me. Yeah. Thank you.

We can use select, uh, salary max salary from employees where salary is, uh, greater than selects max salary from employees. Yeah.

So entity framework provides in build function that, uh, that we can use. Uh, in inbuilt file, it it internally, it uses SQL queries. And, also, uh, it's a entity based framework. Like, every of, uh, class, every, uh, table is, every table is considered as entity, and, uh, its columns in tables are considered the variables. So it simplifies, uh, the problem very, uh, efficiently. Like, uh, database tables are considered as real world entities. So this is how it simplifies, uh, the data access and manipulation. Data access, it, uh, provides various functions for data access, and, also, it provides, uh, method like save and update directly. We can use directly, uh, these methods, and data will be updated directly. And, also, uh, suppose we are using a database today, MySQL, and in future, if we want to, uh, upgrade to a different database, then there will be less changes as compared to other if we are not using entity framework, then there will be more changes. But with entity framework, there will be very much less very less changes, uh, if we are changing any databases.

First thing, uh, that we need is, uh, we have we we will have to, add serialize, uh, serializable, uh, attribute over the dot net object that we want to serialize. After that, we can use, uh, in build. After that, we can use, uh, JSON library, uh, that, uh, we can use, and it we can use JSON serialize, and, uh, that will serialize the JSON object the dot net object to, uh, JSON JSON format.

So if you want to have a continuous deployment, uh, using Azure DevOps, then, uh, first thing required is a version control system. Version control system like git, um, GitHub or something, uh, some other version control system. After, uh, we have we have the version control system, we can have multiple other steps. So we have to set up a pipeline, and pipeline multiple steps will be executed as soon as there is a change in code. And whenever there is a change in code, the changes will go from the version control system. After that, we can set up a pipeline, uh, whenever the changes are there. So if changes will act as an event, whenever there is an event, this chain, uh, the pipeline will run. In pipeline, we can add multiple steps like check checking the linting, checking the formats, and, uh, checking the and having automated automation testing, uh, in the pipeline. And after all these steps are successful, then we, uh, like also, we have to set up a CI server. Uh, the CI server in CI server, the code will be build whenever, uh, there is a code push. So after the everything build is successful, testing is successful, and linting and format check is successful. That build will be deployed to the server. This is how SCA side CD pipeline will work, and this is, uh, continuous deployment using Azure DevOps.

To implement a system that maintains consistent data across multiple distributed system, We can have a master slave architecture where 1 node will be master node and other nodes will be slave nodes. As soon as there is a change, uh, in there will be data and there is a data insert in the master node, the data will be copied over to the slave nodes. And this is how, um, the data consistency will be maintained over all the nodes in a database distributed database.

The main problem with this, like, this code is, like, just we are just adding 2 numbers and as JavaScript is not type safe, uh, so there can be possibility that num 1 is string and num 2 is integer. So it will concatenate as a string. It will not add up 2 numbers. So this is 1 problem. So we have to, uh, make it type safe. And, also, like, we are only console do doing the, uh, console.log. We are not, uh, adding those numbers into a variable and not returning the variable. So this is also a problem. To solve this, we have to make it type safe. And if you want to return something, we want to add something, then, uh, we will have to, uh, add into number and save into a variable and then return from this function.

Here, we are doing, uh, group by order ID, and, uh, we are also checking if it has some of order quantity greater than 100. So only those rows will become when where, uh, the order ID count is some of the order ID is greater than 100. So this is the main issue.

The secure authentication module that we can set up is using c sharp is JWT token. So every time there is a request for login, a JWT token will be created, and, uh, that will be sent to the sending the response of login. And in further request, these j w this j wt token will be sent to every request, and this will be verified. So this is how, uh, the, uh, secure authentication will work. And it works it works with all the all the, uh, secure frameworks like Oath and, uh, OpenID also.

If you want a full toned system for microservice based architecture, then we should have, uh, we should have a proper monitoring. Also, uh, monitoring for the performance and every other thing, how it is performing. Also, we should have a proper, uh, logging also. Because if we have a good logging and monitoring, then we have 4 tolerant system.