Hey, welcome back.
In this lecture, we will talk about the differences between my SQL and SQL light.
Both of these are database systems, which means they are used to store and manage data.
In other words, these two are used to support apps as a data management system.
So let's talk about the advantages of my SQL.
So we used SQLite three previously and you know what it feels like to work with SQLite.
Now, with my SQL, you have better concurrency.
That's one of the first advantages with concurrency.
We mean, for example, in our previous app, we have these teachers accessing that app.
And the teachers can see the data on the table, but they can also add new students.
Now, when it comes to adding new students, we're talking about a right operation.
Now, if two teachers are using the app at the same time and they both want to insert a new student
here, we're dealing with a write operation.
So the user, the teacher wants to change something, wants to write something on the database.
At this point, my SQL tends to be better than SQLite.
Both SQLite and MySQL are good in supporting concurrency, so to users or more users doing the same
operation at the same time.
But my SQL would be better when it comes to thousands of operations at the same time.
So with two teachers only, that wouldn't be a problem.
But with very large data sets where you have thousands of users doing a write operation with read operations,
it's not a problem even if you have thousands and hundreds of thousand operations, but with write operations,
then MySQL can have an advantage.
The next advantage is better for bigger data, which is also somehow related to the first advantage.
So my SQL can give you less issues than as your lot when it comes to bigger data.
So if you have a program which doesn't have millions of records, then you're good with SQLite.
Otherwise it's better to install and use something like MySQL and I'll show you how to install and how
to use my SQL.
The next advantage is supporting more data types.
You know, in those database columns that we have, we had previously like ID, student name, mobile
number, we had different types.
For example, for the ID column, the ID column in the SQLite database was of type int, so an integer
and the student name column, for example, was a text data type.
Now my SQL supports a wide range of data types compared to skew light, so that's a slight advantage
of my school.
Anyway.
I SQL still supports a lot of data types that would cover practically all the cases you work with.
Apps, but this is still something to keep in mind about the difference between my SQL and SQLite.
The fourth advantage is inbuilt authentication.
You'll see how this actually works in practice when we use my SQL in the next videos today.
And this is also related to the fifth advantage multiple database users.
So let me explain this to with multiple database users, we mean that in SQLite three, you cannot have
different users in the database.
I'm not talking about teachers, but like users which can access the database.
SQLite doesn't have that option.
You'll see that my SQL does have this option and each of these database users will have their own username
and password so they can use my SQL software.
So my SQL also comes as a software, and from this software you can create multiple database users and
they can access the database through the my SQL software.
Now Python can also behave like a user, right, when you write a script.
We're going to give the username and the password to our Python script.
And so Python will access the database.
However, with SQLite we didn't have to give any username or passwords to the scripts because the concept
of multiple database users doesn't exist in SQLite, as you might also have some advantages, right?
For example, it's good for development and testing because it is easy to set up, so you just need
a file.
And then the Python script which accesses that that DB file.
However, later on you may want to remove SQLite and implement MySQL.
And this is something I'll show you today how to change from S.
You lied to MySQL.
And then the other advantage is that as SQLite is easily portable, it's a file system database.
So we have this DB file with my SQL.
You don't use a file, you install my SQL with SQLite.
We didn't install any software, but with my SQL we will install the MySQL software and that software
will contain the data.
But it's not a file.
It's it's a software that runs on the computer and that makes my SQL not as easy to be portable to another
computer compared to SQLite.
So these are the advantages of SQLite.
I hope you have a better idea of the differences between my SQL and SQLite.
So now we're ready to install my SQL, and then once we install it, I'll show you how to use the MySQL
system, the software, and then we will see how we can access my SQL database from Python.
So let's see in the next video.