© 2022 Hashnode
#mysql
Introduction Manipulating data to get information out of it is a vital skill to know as a developer. Even if you are not a developer, it is a great skill to learn. SQL is a query language that is very…
I clicked on the link to the challenge and the first thing I saw was Combine two tables. I scanned through the problem and saw that it required an SQL solution. I went through a crash course on SQL be…
I will first go with what is a database, it is a holder where data can be easily collected in an orderly way, or it is an organized collection of data stored and accessed electronically thus managing …
We recently started a new API project for an existing web application. The existing app has no API, and our client wants to create a fresh mobile app experience. Our new API will support the mobile a…
These days we have options to use ORM, raw SQL, or even both. So which one you should use? I've managed several teams and various developers with different experiences, and there's one thing I observed. People who were just starting out ten…
Introduction : Multi-tenancy means that multiple customers of an application are using the same codebase and server but with different databases. Despite the fact that they share resources, customers …
Brief Overview of CAT Many modern applications adopt a CAT architecture, which is a great way to provide a compact, modular and flexible infrastructure to run a variety of apps. CAT-> Client, API, To…
The database we'll be using in this article is MySQL, but what you will learn in this article can also be used for other databases. Before we start, you need to go to your project terminal (Virtual environment) and type the command pip inst…
Hello buddy😊! Today we will use a Discord bot powered by Discord.py to manage our Prisma records, but in this article, we will pretend that we got a shop and we use the Discord.py bot to manage the s…
Let's take a look at the MySQL CONCAT() syntax, learn how to use it, and explore the differences between CONCAT and CONCAT_WS - https://blog.devart.com/mysql-concat-function.html
