‫Let's demo this thing and spin up my.
‫This is what I'm going to do.
‫I'm going to spin up on my second Docker container game and we're going to create a table with my Eyssen
‫and we're going to go another table with A.B., because you can do that.
‫You can have two tables with different storage engines because my signal is awesome, OK?
‫And you can connect the database with JavaScript, right?
‫That's what going to do.
‫We're getting connected and I made a video just specific of that, I'm going to release it before this
‫video goes out so you guys can see how you can connect from JavaScript, from Norges dormice equal.
‫And you you will be surprised how easy this thing is.
‫Once you know my sequel by default, you know, Matya DBI by default, you know, persona, see how
‫transactions behave.
‫We're going to we're going to see since my husband doesn't support transaction, I'm going to show you
‫how transactions behave in my Assim versus A.V. So we're going to do about that.
‫Let's just jump into it.
‫All right, guys.
‫So first thing we're going to do as you spin up on my sequel, Docker Container, because why why I
‫keep using Docker because your laptop is precious.
‫You don't want to install garbage on top of your laptop or your machine if you want to test something
‫and you're going to destroy it later, use Docker.
‫If you want to test spinnable duco container that you have your database on.
‫If you're done, stop and remove that container.
‫You're done.
‫You don't have to uninstall a stolen or configure a no.
‫You don't have to do all the garbage.
‫That's why I don't get along.
‫And you need Docker obviously to do this decoratively.
‫If you can do Dalkia run hello Ward successfully.
‫Whether you are on Windows or whether you are on Mac or whether you're a Linux, you're good to do this
‫tutorial.
‫So there is no endless intricacies of the actual platform.
‫I just isolated that stuff.
‫You have Docker, you can do this good aureole full stop.
‫OK, so once you do hello from Docker, you've got to go guys.
‫And so now what we're gonna do is we're going to open up my school database and how do we do that.
‫It's very simple yet to do a MySQL database.
‫You can do this DOCA on that name and you give it a name, right.
‫Always give you a container name, OK?
‫And I'm going to call them as my equal.
‫Yeah, I think this might exist.
‫I'm going to call my second one because I'm not sure if it exists or not.
‫And the next thing is I want to expose the poor part of my sequence.
‫Three, three or six.
‫I am exposing three, three or six.
‫So this is the internal part, that's the port that I want to expose my computer on, so that's what
‫I connect to when I do Hosain Mac, which is my machine name or localhost.
‫Next thing, the minimum thing we have to specify is a is a is a vitamines variable.
‫Dashi, my sequel Root Password, is called the most secure thing ever Password.
‫My password is called Password.
‫I don't even add one, two, three, because I'm that confident again.
‫So my physical root password equals password.
‫And then the final thing is this due to my sequel and that by default I will install the latest MISAKO,
‫which is I think version eight.
‫OK, and then yeah, if you're watching this three years from now, from some reason and this doesn't
‫work, just do this and that will force version eight to be installed.
‫OK, our version five four over version you won't get that's going to spin that up.
‫It's called one.
‫So and this will spin up and do all that jazz, listening to the poor, exposing the poor and all that
‫jazz.
‫And next thing, we're going to go to another terminal.
‫We're going to connect to this container because we're going to create a database, right.
‫Because we don't have any of that jazz database.
‫We're going to create two tables.
‫One is my -- and one is a..
‫Let's do this.
‫Show new the profile, and here's the thing.
‫OK, what are we going to do is we're going to bash into the container, we're going to enter the container
‫command line prompt and we're going to run MySQL there, because guess what?
‫My skill is existing on my skill that everything.
‫So here's what I'm going to do.
‫I want to I don't want to install the client on my machine or that goofy stuff.
‫So Docker exec execute the interactive terminal.
‫I want to connect to which container is called MS1, or you can call it anything you want when you do
‫that.
‫I want to execute Basche because I want to bash into this thing.
‫Bash it.
‫I am there.
‫I'm Ruwart now and the next thing I want to do is one on my school.
‫I want to actually run the MySQL command line.
‫So you do my well that's you what you are.
‫You want to connect to route worst idea ever.
‫But sure it's editorial and then what's the password.
‫USPI and make sure and don't outerspace after be just immediately write your password.
‫Nagbe password doesn't work otherwise I have no idea why.
‫Again we are in Oracle on this thing.
‫OK, and then once we connect, guess what guys.
‫Let's create a database.
‫Create a database test.
‫OK, now I have a database called Next.
‫Let's create a table called.
‫Well, that's connected the database use database test, right, I think just use this sorry, so use
‫this.
‫I'm now in the database.
‫I'm going to create a table, I'm going to call it the employees underscore my awesome as just the name
‫of that.
‫But I want this to be on my -- on table, so I want to do it.
‫Integer primary key and auto increment.
‫Sure.
‫Why not.
‫And when I do that, I'm going to give my employee a name and a text, OK?
‫And then I want the engine to be my eyes, and that's how you do it.
‫That's how you said by default, if you don't specify, then I think the default engine will be A.B..
‫I don't want that.
‫I want the default engine to be my ASRM.
‫And I forgot that semicolon and we have created the table.
‫I don't think I want to show before we create the other tables, you can actually show all the engines
‫that your data base supports.
‫If you do show engines and you can see all the data, all the engines.
‫I support A.B., I said, well, my assim I support this thing.
‫Merge, I assume.
‫I don't know what's the difference, really.
‫It's like let's say it's a different thing.
‫And if you in a storm db you can also get rocks db here as part of the engine.
‫You can get CCSVI if you want.
‫I don't know why would you do if is actually there is a good use case for the ASV if you like, if you're
‫always exporting stuff to external table you might just make the storage engine to see ASV and just
‫take that CVN.
‫What are the next that said because it's essentially Excel.
‫Right, Excel can open since we thought that there might be a use case for you to make your table storage
‫engine to see ASV.
‫How cool design is.
‫This is part of the software architecture genius.
‫Right, that they built this as a as a separate layer so they can just swivel the engine underneath
‫coolish stuff.
‫So I'm going to create another table.
‫But I'm going to call it a. a.
‫Then we're going to go there and create a transaction by.
‫A.B., OK, and I'm going to call the table A.B..
‫I don't know what A. stands for, guys, if someone knows me.
‫OK, now we have two tables, employees, A.B and employees myosin.
‫So now I kind of stuff I want to, but I want to go to the actual stuff I do, a select star from employees,
‫my assim there is nothing select staff from employees and OTV.
‫So to this to us, this is just the table, right?
‫You you treat it exactly like just a client doesn't know if it's isaam or not.
‫Well, the client can know if you want to, but the underlining storage is completely different based
‫on how you store stuff.
‫And we're going to do another video where I can show performance between my assignment IDBI and such
‫like one million rows and one million rows and anybody being one million rows in my -- and one million
‫dollars in my my rocks and compare to the performance.
‫What's faster, like 100000 updates.
‫Hundred thousand dollars or less.
‫OK, let's go to videos to record our timecode against this.
‫How about that.
‫All right, guys, so I'm here and no Jass Visual Studio code again.
‫Guys, I'm going to reference the video that we did, my sequel vs. JavaScript.
‫And how do you do that?
‫I'm going to get to go through the details and how I did that, because I already did that in details
‫in that video.
‫So go check it out if you want to.
‫But I'm going to do a lot of these ideas, so I'm going to use the MySQL Promise Library here and I'll
‫create a functional connect to my ASSIM.
‫This will insert a row.
‫And so this essentially will insert a row, but in a transaction.
‫So I'm not going to commit the transaction until I literally say commit, OK.
‫And we're going to go back to the terminal and see if that my table meyerrose there or not, despite
‫I am in a transaction.
‫So let's go and check that.
‫So connect my -- and let's go ahead and call this function.
‫And what it does is do I try catch connect to the database and this is my machine name.
‫You can do localhost as well.
‫Same thing.
‫Exactly, because some people, some of you guys say, like you're having trouble using the hostname
‫for some reason so you can use the localhost if it's the same machine and the port three three os x
‫because I'm connected to that.
‫The routers is miserableness password, the root password, the database that I'm connected to, that
‫next thing I'm going to do is I'm going to begin a transaction and anything in that thing.
‫If I do a transaction, if I insert into my table because employees insert the transaction says the
‫idea of a transaction is if I insurgents are due to do deletes, none of those guys can see any number
‫of other external clients can see my changes because of the isolation level.
‫Right.
‫Ideas, guys, right there she reads and all that stuff.
‫Noncommitted reads.
‫If I do that, no, nobody can see the list.
‫I commit my changes even if I commit.
‫There is a little bit of that.
‫Grey area there, because other transaction can have an isolation level of greed committed or read non
‫repeatable reads, if they do no reputable reads, even they are committed, they will not be able to
‫see my changes because their changes are essentially at the transactional level.
‫But I made a video about the asset, if you're interested to do that.
‫The watch that I actually more dive into, more details about isolation, all that.
‫Just what let's go ahead and do a connection to a query and I'm going to execute this query.
‫Insert into.
‫My it's called employees, and that's the thing.
‫This thing is lower, this is lower case, right, since my sequel's case sensitive.
‫So I have to do this, might ask them.
‫All right.
‫And I want to insert the idea what I have to build.
‫I'd just name.
‫And the values is right.
‫Values is nothing, and the name is Hussein.
‫OK, so I'm going to insert a user called Hussein here.
‫OK, and then after I do that, I'm going to do a wait on the comment.
‫I'm going to commit my transaction.
‫You OK?
‫All right.
‫Let's test this out, guys.
‫I'm going to put a breakpoint here on connecting to my ASRM and I'm going to run this thing.
‫All right, Ron.
‫And when we were about to execute the query, so I'm going to go ahead and execute it.
‫And I just executed the query, no, I inserted Hussein to employees, my isaam, let's go and see.
‫I'm not going to commit yet.
‫So the breakpoints right there are stuck, right?
‫I didn't commit.
‫So if I go to my assim my table and say select staff from employees.
‫I asked him what how did that get in other clients are seeing my changes and you know why, guys?
‫Because my eye does not support transactions, period.
‫You cannot do again transaction and you can change your stuff the moment you start inserting.
‫It's visible everywhere.
‫You're out of luck, man.
‫You cannot.
‫That's at the moment.
‫You do that whether you like it or not.
‫It's committed, whether you're committed or not, you can roll back.
‫There's no roll back on this thing.
‫OK, that's it.
‫You inserted.
‫You're done.
‫Sorry.
‫If you don't want it, do do do.
‫Essentially go ahead and try and delete it.
‫Right.
‫But that's essentially it because that's that's the my Isom story.
‫OK, so let's go ahead and do exactly thing.
‫But connect my a.b.
‫Yeah.
‫Let's do it.
‫My OTV and I'm exactly going to use this guy.
‫I'm going to steal code from you.
‫Because it's the same if you think about it's the same exact code, right?
‫All right.
‫All right, so this is my function called Connect, A.B., right.
‫Again, I'm going to put a break point here and I change this into A.B., right, because that's the
‫table I'm going to write into.
‫And I put a break point here.
‫I am calling Connect.
‫A.B., how about this this thing, guys?
‫Let's see.
‫Now, if I go, let's go select staff from employees.
‫A.B., there is nothing.
‫OK, so what I'm going to do here is run.
‫All right, I'm going to begin the transaction, I'm going to insert.
‫Hussein into A.B. table, I go here and I do select as well, it's not there because I did not commit
‫it despite me.
‫Now if I do if I stop, let's do this right.
‫If I do cause the result Rose schema equal Kondor query and I do.
‫Select staff from employees, A.B. Green got -- right we need to do a wait, obviously, guys, and
‫then.
‫Let's do it.
‫So if I do this query and then give me the rose back, look at that.
‫We have a row and there is Hocine, I did not commit, but within my transaction, I can see my own
‫Rose.
‫OK, I can even print them.
‫OK, I can see them.
‫I can query them.
‫I can query that changes I make.
‫That's what I go back here.
‫Select Star.
‫It's an empty set.
‫Other clients cannot see my changes, but the moment I commit.
‫I go back, look at that, it's right there.
‫OK, guys, so that's essentially what Transaction's so I asked him, you can change the engine my --
‫and doesn't support transactions and he does Francie's all that stuff.
‫So this is just like a very little bit a demo showing you the difference between a.B and MySQL and just
‫the idea of you can change the underlining database engine and do cool stuff with that guys.
‫All right guys, I hope you enjoy this whole big videos about derivates engine I'm going to see in the
‫next one.
‫What do you want to see next?
‫Let me know and we'll have discussion.
‫Let's see.
‫What's your favorite databased guys?
‫What do you like to use in your projects?
‫You might equal because you can change the engine?
‫Or do you like the simplicity of just using Postgres?
‫And I don't really care that Bosco's do the optimization for you.
‫What do you like?
‫Right.
‫There is no wrong answers, guys.
‫Right.
‫And yeah, I'm going to pick up one of those databases, start making videos about then that is a lot
‫of videos that I want to make guys.
‫Yeah, I'm going to keep making audio videos.
‫I hope you enjoy that content.
‫Let me know what you want to see next.
‫I'm going to see you in the next one.
‫You guys stay awesome.