Ronak Solanki

Hi. I'm Ronok Solengi. I have having I'm having experience of around 6 years in web development and all over software development industry. I have completed my best in best computer application in 2017 from Bhanagar University, Gujarat, India. Uh, since then, I am working as a software developer and a full stack developer for around 6 years, and I have expertise in PHP, Laravel, Vue. Js, uh, and Next.

Uh, yes. I'm aware of, uh, sub subqueries. We can, uh, write it using yellow account or query builder as well, uh, to because, uh, why we need that? Because sometime we need to get some datas from another table. And based on the results, we want to get from our first main table. So that in that case, we need subqueries.

Uh, okay. Uh, I developed a Laravel application as a middleware for the external ecommerce systems that is called Magento and software. Uh, to import the products from software. Uh, sorry. Uh, to import the products from Magento and send it to our software. And from software, get the orders for the customers and then send back it to the Magento. So in this case, uh, Laravel was used as a middle part to manage the import and export of, uh, products and orders. So in this case, I have added a middleware to authenticate the external APIs, uh, that is Magento APIs as well as software API. For the routing, uh, we basically implemented the web routes as well as API routes as well mainly and also console route because we were doing many things using artisan commands. Uh, to optimize the performance and scalability, uh, I used a queue so that everything happens on the background without, uh, admin of that, uh, Laravel middleware. Do not need to wait for it. And regarding the performance, uh, I tried to not use Eloquent because Eloquent is, uh, like, uh, not performance well, uh, techniques to deal with the database. And regarding scalability, uh, we have used a microservice architecture so that uh, horizontal and vertical scalability becomes more good in that way.

Uh, JWT is, uh, very secure because it's, uh, it uses auth and it's, uh, directly stored on the server, and we do not know the exact, uh, token string. So that it's more secure that so nobody knows the exact, uh, decrypted string.

To, uh, secure sensitive data in Vue. Js application, we must, uh, make sure that the ENV files is not accessible publicly. We should bill in that way And do not store, uh, sensitive information in local storage or session storage, uh, that might break, uh, the security. So we can use, uh, Vuex, uh, store management to keep such sensitive informations in a memory.

We can use, uh, CSS preprocessor like s a, double s, s. Uh, we can use webpack as well to bunch it and mini, uh, uh, serve as a minified version.

Lava will would, uh, fortifies, uh, for the authentication on the sing for the single page application mainly. I'm not sure about that.