1 00:00:00,300 --> 00:00:03,470 ‫Let's demo this thing and spin up my. 2 00:00:03,750 --> 00:00:04,360 ‫This is what I'm going to do. 3 00:00:04,470 --> 00:00:09,780 ‫I'm going to spin up on my second Docker container game and we're going to create a table with my Eyssen 4 00:00:10,440 --> 00:00:14,540 ‫and we're going to go another table with A.B., because you can do that. 5 00:00:14,550 --> 00:00:20,770 ‫You can have two tables with different storage engines because my signal is awesome, OK? 6 00:00:21,360 --> 00:00:24,350 ‫And you can connect the database with JavaScript, right? 7 00:00:25,500 --> 00:00:26,370 ‫That's what going to do. 8 00:00:26,420 --> 00:00:30,920 ‫We're getting connected and I made a video just specific of that, I'm going to release it before this 9 00:00:30,920 --> 00:00:37,310 ‫video goes out so you guys can see how you can connect from JavaScript, from Norges dormice equal. 10 00:00:37,310 --> 00:00:40,550 ‫And you you will be surprised how easy this thing is. 11 00:00:41,270 --> 00:00:47,480 ‫Once you know my sequel by default, you know, Matya DBI by default, you know, persona, see how 12 00:00:47,480 --> 00:00:48,620 ‫transactions behave. 13 00:00:49,160 --> 00:00:52,730 ‫We're going to we're going to see since my husband doesn't support transaction, I'm going to show you 14 00:00:52,730 --> 00:00:57,740 ‫how transactions behave in my Assim versus A.V. So we're going to do about that. 15 00:00:58,040 --> 00:00:59,360 ‫Let's just jump into it. 16 00:00:59,390 --> 00:00:59,800 ‫All right, guys. 17 00:00:59,810 --> 00:01:05,960 ‫So first thing we're going to do as you spin up on my sequel, Docker Container, because why why I 18 00:01:05,960 --> 00:01:08,780 ‫keep using Docker because your laptop is precious. 19 00:01:08,810 --> 00:01:13,700 ‫You don't want to install garbage on top of your laptop or your machine if you want to test something 20 00:01:13,700 --> 00:01:15,980 ‫and you're going to destroy it later, use Docker. 21 00:01:15,980 --> 00:01:19,520 ‫If you want to test spinnable duco container that you have your database on. 22 00:01:20,000 --> 00:01:22,520 ‫If you're done, stop and remove that container. 23 00:01:22,520 --> 00:01:23,090 ‫You're done. 24 00:01:23,270 --> 00:01:26,600 ‫You don't have to uninstall a stolen or configure a no. 25 00:01:27,290 --> 00:01:28,760 ‫You don't have to do all the garbage. 26 00:01:29,360 --> 00:01:30,370 ‫That's why I don't get along. 27 00:01:30,620 --> 00:01:33,050 ‫And you need Docker obviously to do this decoratively. 28 00:01:33,080 --> 00:01:36,320 ‫If you can do Dalkia run hello Ward successfully. 29 00:01:36,320 --> 00:01:41,330 ‫Whether you are on Windows or whether you are on Mac or whether you're a Linux, you're good to do this 30 00:01:41,510 --> 00:01:41,930 ‫tutorial. 31 00:01:41,930 --> 00:01:45,590 ‫So there is no endless intricacies of the actual platform. 32 00:01:45,590 --> 00:01:46,940 ‫I just isolated that stuff. 33 00:01:47,030 --> 00:01:50,450 ‫You have Docker, you can do this good aureole full stop. 34 00:01:50,720 --> 00:01:54,140 ‫OK, so once you do hello from Docker, you've got to go guys. 35 00:01:54,590 --> 00:02:00,250 ‫And so now what we're gonna do is we're going to open up my school database and how do we do that. 36 00:02:00,440 --> 00:02:03,800 ‫It's very simple yet to do a MySQL database. 37 00:02:04,190 --> 00:02:08,690 ‫You can do this DOCA on that name and you give it a name, right. 38 00:02:08,750 --> 00:02:10,760 ‫Always give you a container name, OK? 39 00:02:11,210 --> 00:02:13,220 ‫And I'm going to call them as my equal. 40 00:02:13,520 --> 00:02:16,210 ‫Yeah, I think this might exist. 41 00:02:16,240 --> 00:02:19,970 ‫I'm going to call my second one because I'm not sure if it exists or not. 42 00:02:21,290 --> 00:02:25,940 ‫And the next thing is I want to expose the poor part of my sequence. 43 00:02:25,940 --> 00:02:26,870 ‫Three, three or six. 44 00:02:27,710 --> 00:02:29,420 ‫I am exposing three, three or six. 45 00:02:31,410 --> 00:02:37,620 ‫So this is the internal part, that's the port that I want to expose my computer on, so that's what 46 00:02:37,620 --> 00:02:41,610 ‫I connect to when I do Hosain Mac, which is my machine name or localhost. 47 00:02:42,720 --> 00:02:47,340 ‫Next thing, the minimum thing we have to specify is a is a is a vitamines variable. 48 00:02:47,340 --> 00:02:53,850 ‫Dashi, my sequel Root Password, is called the most secure thing ever Password. 49 00:02:54,210 --> 00:02:55,500 ‫My password is called Password. 50 00:02:56,040 --> 00:02:59,880 ‫I don't even add one, two, three, because I'm that confident again. 51 00:03:00,210 --> 00:03:02,820 ‫So my physical root password equals password. 52 00:03:03,060 --> 00:03:09,150 ‫And then the final thing is this due to my sequel and that by default I will install the latest MISAKO, 53 00:03:09,150 --> 00:03:10,800 ‫which is I think version eight. 54 00:03:11,650 --> 00:03:17,820 ‫OK, and then yeah, if you're watching this three years from now, from some reason and this doesn't 55 00:03:17,820 --> 00:03:22,290 ‫work, just do this and that will force version eight to be installed. 56 00:03:22,440 --> 00:03:26,780 ‫OK, our version five four over version you won't get that's going to spin that up. 57 00:03:27,450 --> 00:03:28,290 ‫It's called one. 58 00:03:30,140 --> 00:03:36,650 ‫So and this will spin up and do all that jazz, listening to the poor, exposing the poor and all that 59 00:03:36,650 --> 00:03:37,190 ‫jazz. 60 00:03:37,220 --> 00:03:40,880 ‫And next thing, we're going to go to another terminal. 61 00:03:41,120 --> 00:03:44,400 ‫We're going to connect to this container because we're going to create a database, right. 62 00:03:44,420 --> 00:03:47,050 ‫Because we don't have any of that jazz database. 63 00:03:47,060 --> 00:03:48,110 ‫We're going to create two tables. 64 00:03:48,110 --> 00:03:49,520 ‫One is my -- and one is a.. 65 00:03:49,640 --> 00:03:50,300 ‫Let's do this. 66 00:03:51,620 --> 00:03:55,310 ‫Show new the profile, and here's the thing. 67 00:03:55,580 --> 00:04:03,710 ‫OK, what are we going to do is we're going to bash into the container, we're going to enter the container 68 00:04:03,710 --> 00:04:07,160 ‫command line prompt and we're going to run MySQL there, because guess what? 69 00:04:07,160 --> 00:04:10,210 ‫My skill is existing on my skill that everything. 70 00:04:10,550 --> 00:04:11,540 ‫So here's what I'm going to do. 71 00:04:11,570 --> 00:04:16,310 ‫I want to I don't want to install the client on my machine or that goofy stuff. 72 00:04:16,730 --> 00:04:20,380 ‫So Docker exec execute the interactive terminal. 73 00:04:20,720 --> 00:04:26,570 ‫I want to connect to which container is called MS1, or you can call it anything you want when you do 74 00:04:26,570 --> 00:04:26,930 ‫that. 75 00:04:27,080 --> 00:04:30,620 ‫I want to execute Basche because I want to bash into this thing. 76 00:04:30,890 --> 00:04:31,520 ‫Bash it. 77 00:04:31,520 --> 00:04:32,180 ‫I am there. 78 00:04:32,180 --> 00:04:37,190 ‫I'm Ruwart now and the next thing I want to do is one on my school. 79 00:04:37,490 --> 00:04:40,490 ‫I want to actually run the MySQL command line. 80 00:04:41,090 --> 00:04:43,670 ‫So you do my well that's you what you are. 81 00:04:43,670 --> 00:04:46,460 ‫You want to connect to route worst idea ever. 82 00:04:46,460 --> 00:04:49,220 ‫But sure it's editorial and then what's the password. 83 00:04:49,260 --> 00:04:54,050 ‫USPI and make sure and don't outerspace after be just immediately write your password. 84 00:04:54,800 --> 00:04:59,000 ‫Nagbe password doesn't work otherwise I have no idea why. 85 00:04:59,030 --> 00:05:02,810 ‫Again we are in Oracle on this thing. 86 00:05:02,840 --> 00:05:07,640 ‫OK, and then once we connect, guess what guys. 87 00:05:08,480 --> 00:05:09,530 ‫Let's create a database. 88 00:05:09,530 --> 00:05:12,010 ‫Create a database test. 89 00:05:12,630 --> 00:05:15,430 ‫OK, now I have a database called Next. 90 00:05:16,100 --> 00:05:18,110 ‫Let's create a table called. 91 00:05:20,110 --> 00:05:27,070 ‫Well, that's connected the database use database test, right, I think just use this sorry, so use 92 00:05:27,070 --> 00:05:27,310 ‫this. 93 00:05:27,310 --> 00:05:28,290 ‫I'm now in the database. 94 00:05:28,300 --> 00:05:36,460 ‫I'm going to create a table, I'm going to call it the employees underscore my awesome as just the name 95 00:05:36,460 --> 00:05:36,820 ‫of that. 96 00:05:36,820 --> 00:05:40,700 ‫But I want this to be on my -- on table, so I want to do it. 97 00:05:40,780 --> 00:05:45,170 ‫Integer primary key and auto increment. 98 00:05:45,170 --> 00:05:45,550 ‫Sure. 99 00:05:45,550 --> 00:05:46,030 ‫Why not. 100 00:05:47,250 --> 00:05:52,960 ‫And when I do that, I'm going to give my employee a name and a text, OK? 101 00:05:55,040 --> 00:05:59,270 ‫And then I want the engine to be my eyes, and that's how you do it. 102 00:06:00,170 --> 00:06:04,710 ‫That's how you said by default, if you don't specify, then I think the default engine will be A.B.. 103 00:06:04,730 --> 00:06:05,510 ‫I don't want that. 104 00:06:05,540 --> 00:06:07,610 ‫I want the default engine to be my ASRM. 105 00:06:08,180 --> 00:06:12,920 ‫And I forgot that semicolon and we have created the table. 106 00:06:14,220 --> 00:06:20,390 ‫I don't think I want to show before we create the other tables, you can actually show all the engines 107 00:06:20,390 --> 00:06:21,590 ‫that your data base supports. 108 00:06:21,590 --> 00:06:25,160 ‫If you do show engines and you can see all the data, all the engines. 109 00:06:25,160 --> 00:06:29,120 ‫I support A.B., I said, well, my assim I support this thing. 110 00:06:29,120 --> 00:06:30,140 ‫Merge, I assume. 111 00:06:30,140 --> 00:06:31,310 ‫I don't know what's the difference, really. 112 00:06:31,790 --> 00:06:33,320 ‫It's like let's say it's a different thing. 113 00:06:33,560 --> 00:06:38,540 ‫And if you in a storm db you can also get rocks db here as part of the engine. 114 00:06:39,360 --> 00:06:41,090 ‫You can get CCSVI if you want. 115 00:06:42,260 --> 00:06:48,410 ‫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 116 00:06:48,440 --> 00:06:54,530 ‫always exporting stuff to external table you might just make the storage engine to see ASV and just 117 00:06:54,530 --> 00:06:55,600 ‫take that CVN. 118 00:06:57,050 --> 00:07:00,410 ‫What are the next that said because it's essentially Excel. 119 00:07:00,410 --> 00:07:06,050 ‫Right, Excel can open since we thought that there might be a use case for you to make your table storage 120 00:07:06,050 --> 00:07:06,940 ‫engine to see ASV. 121 00:07:06,950 --> 00:07:08,120 ‫How cool design is. 122 00:07:08,210 --> 00:07:12,380 ‫This is part of the software architecture genius. 123 00:07:12,770 --> 00:07:19,190 ‫Right, that they built this as a as a separate layer so they can just swivel the engine underneath 124 00:07:19,760 --> 00:07:20,750 ‫coolish stuff. 125 00:07:21,470 --> 00:07:23,360 ‫So I'm going to create another table. 126 00:07:25,280 --> 00:07:28,180 ‫But I'm going to call it a. a. 127 00:07:29,540 --> 00:07:32,430 ‫Then we're going to go there and create a transaction by. 128 00:07:37,650 --> 00:07:42,170 ‫A.B., OK, and I'm going to call the table A.B.. 129 00:07:43,710 --> 00:07:47,550 ‫I don't know what A. stands for, guys, if someone knows me. 130 00:07:49,480 --> 00:07:54,880 ‫OK, now we have two tables, employees, A.B and employees myosin. 131 00:07:56,570 --> 00:08:06,560 ‫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, 132 00:08:06,560 --> 00:08:13,310 ‫my assim there is nothing select staff from employees and OTV. 133 00:08:14,570 --> 00:08:17,960 ‫So to this to us, this is just the table, right? 134 00:08:18,290 --> 00:08:23,080 ‫You you treat it exactly like just a client doesn't know if it's isaam or not. 135 00:08:23,090 --> 00:08:30,200 ‫Well, the client can know if you want to, but the underlining storage is completely different based 136 00:08:30,200 --> 00:08:31,370 ‫on how you store stuff. 137 00:08:31,370 --> 00:08:36,020 ‫And we're going to do another video where I can show performance between my assignment IDBI and such 138 00:08:36,020 --> 00:08:41,050 ‫like one million rows and one million rows and anybody being one million rows in my -- and one million 139 00:08:41,060 --> 00:08:43,660 ‫dollars in my my rocks and compare to the performance. 140 00:08:43,690 --> 00:08:47,300 ‫What's faster, like 100000 updates. 141 00:08:47,300 --> 00:08:48,820 ‫Hundred thousand dollars or less. 142 00:08:48,980 --> 00:08:51,970 ‫OK, let's go to videos to record our timecode against this. 143 00:08:51,980 --> 00:08:52,410 ‫How about that. 144 00:08:52,460 --> 00:08:56,960 ‫All right, guys, so I'm here and no Jass Visual Studio code again. 145 00:08:56,960 --> 00:09:02,540 ‫Guys, I'm going to reference the video that we did, my sequel vs. JavaScript. 146 00:09:02,540 --> 00:09:03,350 ‫And how do you do that? 147 00:09:03,360 --> 00:09:07,700 ‫I'm going to get to go through the details and how I did that, because I already did that in details 148 00:09:07,700 --> 00:09:08,350 ‫in that video. 149 00:09:08,360 --> 00:09:09,740 ‫So go check it out if you want to. 150 00:09:09,740 --> 00:09:15,260 ‫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 151 00:09:15,260 --> 00:09:17,300 ‫create a functional connect to my ASSIM. 152 00:09:17,480 --> 00:09:18,980 ‫This will insert a row. 153 00:09:19,010 --> 00:09:24,080 ‫And so this essentially will insert a row, but in a transaction. 154 00:09:24,080 --> 00:09:29,180 ‫So I'm not going to commit the transaction until I literally say commit, OK. 155 00:09:29,390 --> 00:09:35,230 ‫And we're going to go back to the terminal and see if that my table meyerrose there or not, despite 156 00:09:35,240 --> 00:09:36,200 ‫I am in a transaction. 157 00:09:36,200 --> 00:09:37,300 ‫So let's go and check that. 158 00:09:37,580 --> 00:09:40,220 ‫So connect my -- and let's go ahead and call this function. 159 00:09:40,760 --> 00:09:45,320 ‫And what it does is do I try catch connect to the database and this is my machine name. 160 00:09:45,320 --> 00:09:46,750 ‫You can do localhost as well. 161 00:09:46,760 --> 00:09:47,330 ‫Same thing. 162 00:09:47,330 --> 00:09:52,520 ‫Exactly, because some people, some of you guys say, like you're having trouble using the hostname 163 00:09:52,520 --> 00:09:57,680 ‫for some reason so you can use the localhost if it's the same machine and the port three three os x 164 00:09:57,680 --> 00:09:59,380 ‫because I'm connected to that. 165 00:09:59,390 --> 00:10:04,430 ‫The routers is miserableness password, the root password, the database that I'm connected to, that 166 00:10:04,730 --> 00:10:10,070 ‫next thing I'm going to do is I'm going to begin a transaction and anything in that thing. 167 00:10:10,070 --> 00:10:17,940 ‫If I do a transaction, if I insert into my table because employees insert the transaction says the 168 00:10:17,960 --> 00:10:25,010 ‫idea of a transaction is if I insurgents are due to do deletes, none of those guys can see any number 169 00:10:25,010 --> 00:10:30,920 ‫of other external clients can see my changes because of the isolation level. 170 00:10:30,920 --> 00:10:31,130 ‫Right. 171 00:10:31,280 --> 00:10:34,370 ‫Ideas, guys, right there she reads and all that stuff. 172 00:10:34,370 --> 00:10:35,270 ‫Noncommitted reads. 173 00:10:36,020 --> 00:10:39,680 ‫If I do that, no, nobody can see the list. 174 00:10:39,680 --> 00:10:43,070 ‫I commit my changes even if I commit. 175 00:10:43,610 --> 00:10:44,910 ‫There is a little bit of that. 176 00:10:46,630 --> 00:10:54,120 ‫Grey area there, because other transaction can have an isolation level of greed committed or read non 177 00:10:54,190 --> 00:10:59,380 ‫repeatable reads, if they do no reputable reads, even they are committed, they will not be able to 178 00:10:59,380 --> 00:11:03,250 ‫see my changes because their changes are essentially at the transactional level. 179 00:11:03,400 --> 00:11:05,770 ‫But I made a video about the asset, if you're interested to do that. 180 00:11:05,920 --> 00:11:10,810 ‫The watch that I actually more dive into, more details about isolation, all that. 181 00:11:10,810 --> 00:11:18,190 ‫Just what let's go ahead and do a connection to a query and I'm going to execute this query. 182 00:11:19,690 --> 00:11:20,680 ‫Insert into. 183 00:11:21,620 --> 00:11:25,290 ‫My it's called employees, and that's the thing. 184 00:11:25,310 --> 00:11:31,320 ‫This thing is lower, this is lower case, right, since my sequel's case sensitive. 185 00:11:31,730 --> 00:11:34,790 ‫So I have to do this, might ask them. 186 00:11:35,280 --> 00:11:35,840 ‫All right. 187 00:11:37,040 --> 00:11:40,820 ‫And I want to insert the idea what I have to build. 188 00:11:40,820 --> 00:11:41,780 ‫I'd just name. 189 00:11:41,900 --> 00:11:44,460 ‫And the values is right. 190 00:11:45,960 --> 00:11:50,370 ‫Values is nothing, and the name is Hussein. 191 00:11:50,700 --> 00:11:54,670 ‫OK, so I'm going to insert a user called Hussein here. 192 00:11:54,790 --> 00:12:00,540 ‫OK, and then after I do that, I'm going to do a wait on the comment. 193 00:12:00,550 --> 00:12:01,860 ‫I'm going to commit my transaction. 194 00:12:01,860 --> 00:12:02,550 ‫You OK? 195 00:12:03,210 --> 00:12:03,720 ‫All right. 196 00:12:07,750 --> 00:12:09,120 ‫Let's test this out, guys. 197 00:12:09,310 --> 00:12:15,130 ‫I'm going to put a breakpoint here on connecting to my ASRM and I'm going to run this thing. 198 00:12:15,700 --> 00:12:16,630 ‫All right, Ron. 199 00:12:18,750 --> 00:12:23,370 ‫And when we were about to execute the query, so I'm going to go ahead and execute it. 200 00:12:24,930 --> 00:12:32,850 ‫And I just executed the query, no, I inserted Hussein to employees, my isaam, let's go and see. 201 00:12:33,000 --> 00:12:34,110 ‫I'm not going to commit yet. 202 00:12:34,110 --> 00:12:36,080 ‫So the breakpoints right there are stuck, right? 203 00:12:36,090 --> 00:12:36,830 ‫I didn't commit. 204 00:12:37,050 --> 00:12:42,270 ‫So if I go to my assim my table and say select staff from employees. 205 00:12:44,300 --> 00:12:51,530 ‫I asked him what how did that get in other clients are seeing my changes and you know why, guys? 206 00:12:51,680 --> 00:12:55,210 ‫Because my eye does not support transactions, period. 207 00:12:55,790 --> 00:13:00,560 ‫You cannot do again transaction and you can change your stuff the moment you start inserting. 208 00:13:00,980 --> 00:13:02,750 ‫It's visible everywhere. 209 00:13:03,050 --> 00:13:04,570 ‫You're out of luck, man. 210 00:13:04,790 --> 00:13:05,570 ‫You cannot. 211 00:13:05,780 --> 00:13:06,770 ‫That's at the moment. 212 00:13:06,770 --> 00:13:08,690 ‫You do that whether you like it or not. 213 00:13:08,690 --> 00:13:12,590 ‫It's committed, whether you're committed or not, you can roll back. 214 00:13:12,770 --> 00:13:14,240 ‫There's no roll back on this thing. 215 00:13:14,240 --> 00:13:15,500 ‫OK, that's it. 216 00:13:16,070 --> 00:13:16,940 ‫You inserted. 217 00:13:17,240 --> 00:13:17,870 ‫You're done. 218 00:13:18,020 --> 00:13:18,620 ‫Sorry. 219 00:13:18,710 --> 00:13:21,530 ‫If you don't want it, do do do. 220 00:13:21,530 --> 00:13:23,780 ‫Essentially go ahead and try and delete it. 221 00:13:23,780 --> 00:13:24,080 ‫Right. 222 00:13:24,380 --> 00:13:28,580 ‫But that's essentially it because that's that's the my Isom story. 223 00:13:28,580 --> 00:13:30,890 ‫OK, so let's go ahead and do exactly thing. 224 00:13:30,890 --> 00:13:33,150 ‫But connect my a.b. 225 00:13:33,380 --> 00:13:33,550 ‫Yeah. 226 00:13:33,590 --> 00:13:33,950 ‫Let's do it. 227 00:13:33,950 --> 00:13:38,240 ‫My OTV and I'm exactly going to use this guy. 228 00:13:44,370 --> 00:13:46,800 ‫I'm going to steal code from you. 229 00:13:48,750 --> 00:13:51,780 ‫Because it's the same if you think about it's the same exact code, right? 230 00:13:54,750 --> 00:13:55,230 ‫All right. 231 00:13:58,730 --> 00:14:03,590 ‫All right, so this is my function called Connect, A.B., right. 232 00:14:03,740 --> 00:14:09,740 ‫Again, I'm going to put a break point here and I change this into A.B., right, because that's the 233 00:14:09,740 --> 00:14:11,120 ‫table I'm going to write into. 234 00:14:11,390 --> 00:14:12,850 ‫And I put a break point here. 235 00:14:13,400 --> 00:14:14,500 ‫I am calling Connect. 236 00:14:14,520 --> 00:14:16,490 ‫A.B., how about this this thing, guys? 237 00:14:17,000 --> 00:14:17,510 ‫Let's see. 238 00:14:17,900 --> 00:14:23,330 ‫Now, if I go, let's go select staff from employees. 239 00:14:23,870 --> 00:14:25,580 ‫A.B., there is nothing. 240 00:14:25,580 --> 00:14:28,610 ‫OK, so what I'm going to do here is run. 241 00:14:31,230 --> 00:14:36,600 ‫All right, I'm going to begin the transaction, I'm going to insert. 242 00:14:37,720 --> 00:14:47,680 ‫Hussein into A.B. table, I go here and I do select as well, it's not there because I did not commit 243 00:14:47,680 --> 00:14:48,760 ‫it despite me. 244 00:14:48,770 --> 00:14:52,360 ‫Now if I do if I stop, let's do this right. 245 00:14:52,630 --> 00:15:02,230 ‫If I do cause the result Rose schema equal Kondor query and I do. 246 00:15:03,570 --> 00:15:14,010 ‫Select staff from employees, A.B. Green got -- right we need to do a wait, obviously, guys, and 247 00:15:14,010 --> 00:15:14,370 ‫then. 248 00:15:17,870 --> 00:15:18,510 ‫Let's do it. 249 00:15:18,530 --> 00:15:25,130 ‫So if I do this query and then give me the rose back, look at that. 250 00:15:25,280 --> 00:15:33,260 ‫We have a row and there is Hocine, I did not commit, but within my transaction, I can see my own 251 00:15:33,260 --> 00:15:33,960 ‫Rose. 252 00:15:34,150 --> 00:15:35,960 ‫OK, I can even print them. 253 00:15:36,200 --> 00:15:38,060 ‫OK, I can see them. 254 00:15:38,070 --> 00:15:39,230 ‫I can query them. 255 00:15:39,420 --> 00:15:41,270 ‫I can query that changes I make. 256 00:15:41,540 --> 00:15:43,520 ‫That's what I go back here. 257 00:15:43,660 --> 00:15:44,480 ‫Select Star. 258 00:15:44,810 --> 00:15:45,990 ‫It's an empty set. 259 00:15:46,610 --> 00:15:52,580 ‫Other clients cannot see my changes, but the moment I commit. 260 00:15:53,870 --> 00:15:58,550 ‫I go back, look at that, it's right there. 261 00:15:58,730 --> 00:16:05,450 ‫OK, guys, so that's essentially what Transaction's so I asked him, you can change the engine my -- 262 00:16:05,450 --> 00:16:09,530 ‫and doesn't support transactions and he does Francie's all that stuff. 263 00:16:10,160 --> 00:16:17,360 ‫So this is just like a very little bit a demo showing you the difference between a.B and MySQL and just 264 00:16:17,360 --> 00:16:23,180 ‫the idea of you can change the underlining database engine and do cool stuff with that guys. 265 00:16:23,420 --> 00:16:29,870 ‫All right guys, I hope you enjoy this whole big videos about derivates engine I'm going to see in the 266 00:16:29,870 --> 00:16:30,440 ‫next one. 267 00:16:31,010 --> 00:16:32,100 ‫What do you want to see next? 268 00:16:32,450 --> 00:16:34,340 ‫Let me know and we'll have discussion. 269 00:16:34,710 --> 00:16:35,240 ‫Let's see. 270 00:16:35,330 --> 00:16:37,130 ‫What's your favorite databased guys? 271 00:16:37,430 --> 00:16:39,710 ‫What do you like to use in your projects? 272 00:16:40,250 --> 00:16:42,500 ‫You might equal because you can change the engine? 273 00:16:42,500 --> 00:16:45,770 ‫Or do you like the simplicity of just using Postgres? 274 00:16:45,770 --> 00:16:49,460 ‫And I don't really care that Bosco's do the optimization for you. 275 00:16:49,520 --> 00:16:50,210 ‫What do you like? 276 00:16:50,360 --> 00:16:50,530 ‫Right. 277 00:16:50,600 --> 00:16:51,890 ‫There is no wrong answers, guys. 278 00:16:52,040 --> 00:16:52,390 ‫Right. 279 00:16:52,700 --> 00:16:57,980 ‫And yeah, I'm going to pick up one of those databases, start making videos about then that is a lot 280 00:16:57,980 --> 00:16:59,780 ‫of videos that I want to make guys. 281 00:16:59,840 --> 00:17:01,970 ‫Yeah, I'm going to keep making audio videos. 282 00:17:01,970 --> 00:17:03,290 ‫I hope you enjoy that content. 283 00:17:03,290 --> 00:17:05,420 ‫Let me know what you want to see next. 284 00:17:05,420 --> 00:17:06,980 ‫I'm going to see you in the next one. 285 00:17:07,130 --> 00:17:08,240 ‫You guys stay awesome.