SQL vs. NoSQL

Search for a command to run...

No comments yet. Be the first to comment.
A few days ago, I got a question from a colleague about why we need to have an SSL certified website nowadays. I answered, “It's because you see the green lock in your browser,” off the top of my head. However, because I am the type of person who isn...
Hey 👋, I'm back with a new blog post after a long break! This past week, I’ve been diving deep into integrating push notifications into a mobile app. If you've ever wondered how they work and why they’re so effective, this post is for you! What Are ...

I'm back again with a new blog post. The idea for this post came very spontaneously. I'm currently investing a lot of time in my new development project, and I came up with how to further secure the application. As a solution to this issue, quite a f...

Node.js is an engine that allows us to run JavaScript outside the browser. Many applications today are powered by Node.js, offering numerous advantages and a few drawbacks. However, my intention today is not to introduce Node.js or JavaScript. Today,...

I have said many times that computer science is a huge field in which everyone can find themselves. Being a computer science student has its advantages and benefits, and one such advantage is what GitHub offers with its GitHub for Education program a...

Open Graph is an Internet protocol created by Facebook to standardize the display of metadata on social networks. What advantages does it bring? Open Graph brings advantages when displaying a website on social networks. Open Graph makes our posts mor...

In my previous article about what CRUD is, I also discussed that a part of any application is a database.
Today, a database is almost necessary for every application, because it allows us to store different data.
Databases can be relational or non-relational, they can be accessed via the Internet and the Internet, or they can be local on a local device.
Today, I will walk between relational and non-relational databases.
Relational databases are the most used databases. Data in these databases are stored in tables and rows.
The relational database is like Excel worksheets.
Relational databases have better readable data than non-relational databases because they have very structured data.
For creating queries in those databases is used an existing language called SQL is.
Advantages of relational database:
The biggest drawback of a non-relational database is the inability to dynamically change the schema. After all, if we want to add a new attribute to a relational database, this will affect the entire database.
At the same time, compared to non-relational databases, they need more time to execute and search for data.
Some relational databases:

Non-relational databases contain unstructured, structured or structured data, usually in a key-value pair.
The big advantage of those databases is the option of being very flexible. This allows you to quickly add new attributes which do not impact the full database.
The advantage of such a database is that we can store a lot of data in one table.
The non-relational database is faster than the relational sub-database.
The disadvantage of such a database is that each has its own method of making queries for managing data in the database.
Some non-relational databases:
I can figure out that relational databases are the best option in an application that had structured data and we want to have them portable and an option for use in different infrastructures. But, a lot of companies still use relational databases.
But non-relational databases get the most out when we start creating a project and want to have a lot of flexibility. Also, the non-relation database is great if we store a huge amount of data.
If you like reading what I write, you can donate me a cup of coffee or start following me on Twitter(@Patik123_).