High.
So we just went through the entire chapter and the last session.
So all we had done that in my.
So if you.
So we started that out by Chang'e we had done things like creating a chat where one person sends and
calls to everybody else.
Right.
So in this particular chapter we also saw the benefits of networking and we saw how networking is used
in things much more than we could ever think about.
So basically where a client can talk where multiple clients can talk for hours and using the chat up
we did stuff like one client talks or multiple clients.
Right.
So as of now we of course these are a few things that we just did.
We learned about multi-threading we learned about networking and of course we created the chatter of
the chatter right now.
Something else that we can think about or which we can concentrate upon is is things like we would we
would want to we would want to understand more in detail something called as databases handling databases.
So why databases are required for for a particular program or why is database so very important.
So we have to create a package out here let's call it databases.
And why is this very important for us.
So let's think about it and let's go go much more in detail.
OK.
Now a database is nothing but where data is stored.
Right.
So if you have a look at chat apps right.
Or in this particular application we had a client.
So this is the client.
And we also have the server.
So the server what was what was doing was it was just basically whenever a client was run.
So if I ran the server if you remember whenever I ran the server the server was running up and running
and client and I ran the client.
Then I said when I run the client and said ABC OK and all.
And I ran another client.
And let's say it was X Y Z.
And now let me see another client let me say it was.
Now you are so there were three lines.
Each of them were connected and I got a connection from client to that address this that address this
or that or this.
Right.
So I have stored.
Now if I say hi from any one of them it goes to all the others at ABC right now.
Now comes the question there will be a thousand clients in the world right.
I could have stored I've stored all their details each client details or their connection and their
name I have stored it in in this particular client's dictionary.
But what if what if I had to store much more details about about each client.
All right let's say I want to store much more details about each line.
Let's say for example I wanted to store the client's name is his address is his Gnome's something like
his phone number his email id I want to sort his email id at least I want his email ID to be stored
and and then I would one along with his email id I wanted his date of birth to be stored.
So these are things that you know every client every client's data needs to be stored.
So now making a connection and storing the connection for each client in a dictionary is not enough
because in a dictionary you can just have maximum a name and connection.
That's it to just Hoopa just do arguments right.
Name calling connection but you cannot have something more than that.
Like for example it's you can have you can have corresponding to a name his role or his Chye his his
entire history.
You won't be able to.
So it's best to either you know get things into files or either do some kind of file you know do some
some kind of management of files or rather store them in databases so I could have stored in files but
of files storing them in files and accessing them and files are a bit tedious of course because they're
going to be stored statements and you know how to debug these statements how to create you know how
to cut across the strings.
It's very you know it's not that great but what if you have something like a spreadsheet where all the
data was there in spreadsheets or something like that.
So maybe you could have used a spreadsheet for that for that matter or see you file an excel file or
something like that where we could have done that and then this is using panderers.
But then what if you had to do it with if you had to do it with basic bited courting then in that case
let's say for example more stuff the companies most of the applications most of them deal with deal
extensively currently with database Hanzo So we need to get databases in detail and try to figure out
how things work and how our database is related to each other and how they're going to go ahead and
stuff like that.
So we go ahead with that and and as we do it let's understand more in detail exactly how things happen
and how things do not happen and stuff like that.
OK.
So indeed Hobbes's So one of the database that I'm going to deal with specifically currently is the
escrow database or that's really like to wish short of the database.
I might deal with the allotted a visa so the next sessions.
But for now we're going to deal with deescalated visas where we're going to learn how to how data is
stored and escalate databases and how they can be accessed using Python code and how Python code can
store stuff.
So we're going to use we are going to of course develop the same application a little more.
That is a chat app we're going to Delap this application a bit more by storing a lot of plain details
in data.
So that's my long term long term goal for this particular session.
But for now let's let's close all let's terminate all the connections as of now right now and let's
start with databases.
But for now let's see how things work out with the escalate and what exactly they escalate and what
is.
How do I create database in that particular fashion so you can just right now open into an icon prompt
open of an icon a prompt and when you open up Anaconda prompt if you want to create a database Let's
say I want to create a database.
Let's see escalatory is the one we just used escalatory spaces.
I want a real database.
Let me call the database name company.
OK.
Company dot DP So basically dot tv in the shows that it is a database that I'm creating.
So escalatory company daddy.
So all when I am in a particular database that is when I'm in companied on the over here I need to create
some tables inside companied IDBI to create something like that.
So let me say I'm going to create a table that we call it does imply.