1 00:00:00,120 --> 00:00:07,650 ‫Sequel Light, how did we go that far without talking about a beautiful sequel, Light created by Dwayne 2 00:00:07,650 --> 00:00:08,290 ‫Johnson? 3 00:00:08,310 --> 00:00:09,030 ‫Oh my God. 4 00:00:09,060 --> 00:00:17,430 ‫OK, Rock Clyde, Dwayne Richard Hip in 2000, he said, Oh, my God. 5 00:00:17,430 --> 00:00:18,720 ‫Can I just why? 6 00:00:18,720 --> 00:00:24,300 ‫I'm writing just when I write locally to this guy, I'm writing directly to files and using I order 7 00:00:24,310 --> 00:00:25,440 ‫filed that right. 8 00:00:25,710 --> 00:00:27,570 ‫I want a database locally. 9 00:00:27,570 --> 00:00:29,160 ‫Can I please have it please. 10 00:00:29,190 --> 00:00:30,720 ‫So I created equal like. 11 00:00:31,690 --> 00:00:38,590 ‫And it was so popular, I think it's the most very popular it what the hell is a very popular look at 12 00:00:38,590 --> 00:00:43,630 ‫this very popular embedded database for local data? 13 00:00:43,720 --> 00:00:46,180 ‫Game is everywhere, guys. 14 00:00:46,210 --> 00:00:49,480 ‫This is this local database and data point. 15 00:00:49,810 --> 00:00:50,650 ‫It's everywhere. 16 00:00:50,980 --> 00:00:53,560 ‫Sequoyah, like everybody's using it. 17 00:00:53,560 --> 00:00:57,370 ‫It's in the browsers in the it's in software. 18 00:00:57,370 --> 00:01:00,370 ‫It's an operating systems by default. 19 00:01:01,300 --> 00:01:03,940 ‫So this guy's created a beast of a database. 20 00:01:03,940 --> 00:01:10,790 ‫And if an embedded database came over or a storage engine and it uses B3 by default. 21 00:01:10,810 --> 00:01:11,160 ‫Right. 22 00:01:11,890 --> 00:01:13,690 ‫And this guy, Richard. 23 00:01:14,800 --> 00:01:19,720 ‫Tried to create them as an extension, I read, and I'm going to reference the article below. 24 00:01:20,470 --> 00:01:27,190 ‫I read that he tried to implement LSM because it was just. 25 00:01:28,420 --> 00:01:33,840 ‫Just became popular all of a sudden around, so he said, OK, I'll bite, let me do it as an extension. 26 00:01:33,850 --> 00:01:40,900 ‫So he did and he did not see that much performance increase with SQLite because of the architecture 27 00:01:40,900 --> 00:01:41,610 ‫that is built. 28 00:01:41,620 --> 00:01:41,830 ‫Right. 29 00:01:41,850 --> 00:01:49,180 ‫It's just you cannot build all of that stuff right in in one way and then just decide to change it. 30 00:01:49,200 --> 00:01:49,450 ‫Right. 31 00:01:49,580 --> 00:01:54,070 ‫The whole storage engine is just like it's very intertwined. 32 00:01:54,070 --> 00:01:54,400 ‫Right. 33 00:01:55,090 --> 00:02:01,360 ‫That's why my sequel, The Smart Way to separate these concerns, like so there is the database itself 34 00:02:01,540 --> 00:02:06,850 ‫and there is the database storage engine itself, and you can swizzle the engine to do anything else. 35 00:02:07,150 --> 00:02:09,130 ‫So he didn't give that performance. 36 00:02:09,130 --> 00:02:11,140 ‫But I think you can support an extension. 37 00:02:11,140 --> 00:02:12,610 ‫You can try it if you want to. 38 00:02:13,570 --> 00:02:20,200 ‫It's very prosperous, like mine, and it supports full acid. 39 00:02:21,100 --> 00:02:21,510 ‫Right. 40 00:02:21,530 --> 00:02:22,510 ‫And that's attractive. 41 00:02:22,690 --> 00:02:26,170 ‫I still want to do acid transaction even locally, guys. 42 00:02:26,540 --> 00:02:26,810 ‫Right. 43 00:02:27,190 --> 00:02:30,490 ‫Don't prevent me from doing that, even if it's locally or why not. 44 00:02:30,910 --> 00:02:32,020 ‫But only support stable. 45 00:02:32,030 --> 00:02:34,150 ‫Lukken doesn't have role level looking. 46 00:02:34,320 --> 00:02:42,000 ‫OK, and if you think about it, I don't know if you're going to need or level locking on local database. 47 00:02:42,310 --> 00:02:44,500 ‫You don't have multiple users anyway, right. 48 00:02:44,500 --> 00:02:51,700 ‫There's no multiuser, there's one single database and you better be one single user for if you, if 49 00:02:51,700 --> 00:02:53,470 ‫you want to support multiple users. 50 00:02:53,470 --> 00:02:53,830 ‫Right. 51 00:02:53,830 --> 00:02:58,900 ‫You have a client server, DBMS like, like MySQL, Oscars or something else. 52 00:02:58,900 --> 00:02:59,100 ‫Right. 53 00:02:59,110 --> 00:03:03,100 ‫That has ports that listening to a TCP connections and all that jazz. 54 00:03:03,120 --> 00:03:03,310 ‫Right. 55 00:03:03,700 --> 00:03:09,280 ‫You cannot just have a local database that does all that jazz concurrently. 56 00:03:09,280 --> 00:03:10,210 ‫Denverites. 57 00:03:10,810 --> 00:03:12,970 ‫Yes, it has concurrent read and concurrent. 58 00:03:12,970 --> 00:03:13,130 ‫Right. 59 00:03:13,150 --> 00:03:15,100 ‫You can write unparallel. 60 00:03:15,400 --> 00:03:18,700 ‫How bad -- is this guy's game yet. 61 00:03:18,940 --> 00:03:22,990 ‫So he's using the operating system and he can write in parallel. 62 00:03:23,770 --> 00:03:24,670 ‫That's amazing. 63 00:03:26,020 --> 00:03:32,470 ‫So we've sequel if you saw ever see a sequel in your browser, if you go to console browser, you can 64 00:03:32,470 --> 00:03:34,030 ‫see a sequel that's a sequel light. 65 00:03:34,030 --> 00:03:34,360 ‫Right. 66 00:03:34,750 --> 00:03:41,040 ‫And now I might do a video on what sequel included in many operating systems by default, windows go 67 00:03:41,140 --> 00:03:41,740 ‫by default. 68 00:03:41,740 --> 00:03:43,660 ‫I believe Linux have it by default. 69 00:03:43,870 --> 00:03:44,680 ‫Might be wrong there.