Adding CRAZY DATABASE stuff to my game.

追加: 2026-05-21

[00:00:51]pretty everyday. A wow that's some riz ge.

[00:01:04]Hey Goral. Hey B.

[00:01:08]Good morning.

[00:01:10]Uh, yeah, I also need to make some breakfast. So, hello T Teach.

[00:01:19]Limited edition Riz am drunk. Oh, okay.

[00:01:22]Cool. That sounds fun.

[00:01:33]Morning in the morning, although an afternoon for me. Hey Bert, good morning.

[00:02:09]have an ad break here in a few minutes, in which case I will have to run to the kitchen and try to make breakfast very quickly.

[00:02:27]passes created documentation for a complete deployment process and data fetching.

[00:02:34]I'm going to write in latte.

[00:02:40]I like latte. I wrote I actually used to do like all of my homework assignments in university in latte.

[00:02:49]No joke.

[00:03:11]Basically, if I had math homework, I would do the math on paper and then type it up with latte. Uh, if I had a paper to write, latte came in so clutch because you could use like packages.

[00:03:28]You could use different latte packages or whatever they were called uh for different writing styles. So there was one for MLA, there was one for APA like five and six.

[00:03:41]So, in my classes on like the arts that I had, I I like never lost points for like formatting on my papers because I always used Latte to do it.

[00:03:57]Always used Word before. Dude, Latte is awesome. Latte is like really really awesome. It's what like academics typically use to write white papers and stuff. Actually, I'm pretty sure I wrote my thesis in with Latte. Hey, Bobby.

[00:04:17]Like, I really, really, really like Latte.

[00:04:22]It's been a while though. I used to make like you can make like slideshows and stuff with Latte.

[00:04:31]This is a lady, not a car. You think I'm stupid? No. No. No. It It ain't like that. It ain't like that.

[00:04:40]Do you guys think it's a hair update? It feels like a hair update to me.

[00:04:46]Hang on.

[00:05:00]Oh god.

[00:05:13]It's a Blue Jay's hat day. I mean, yeah, I could wear the Blue Jays hat.

[00:05:23]Latex is sick.

[00:05:26]I mean latte.

[00:05:35]Hey X pair sticking up in the back there.

[00:05:49]When I found out it was pronounced tech, I was applauded.

[00:05:54]Gosh. Yeah. Some people pronounce latex.

[00:05:58]It's kind of funny.

[00:06:05]My latte.

[00:06:07]Oh, what the hell? My hair just doesn't look good when it's up. Not as good as just holding it.

[00:06:24]Whatever.

[00:06:30]Okay. Hair is fine. Thank you. Thank you everybody. Dtomic today. That's interesting. I've never messed with the datomic really beyond like simple [ __ ] Hey Tannerax. Hey Dexter. Hey Pu. Hey Josh TV. TV Josh.

[00:06:49]Uh, a latte project.

[00:06:59]Yes, that one. Uh, Bert, I think it's that one.

[00:07:18]Uh, I'll answer in a sec. I'm going to go make breakfast real quick.

[00:12:34]Breakfast of the champions. Egg sandwich with a bubbly streamers on screen. Wow. I wasn't gone that long, was I?

[00:12:50]Maybe I was. I was like, there's no way it's going to take that long to whip an egg and put it in the microwave.

[00:13:17]Thanks Lada and thank you for the 10 stream streak.

[00:13:40]You're think, "Oh, yeah, the microwaved omelette is actually so clutch."

[00:13:47]Uh, Emac person. I'm going to use Emacs here soon.

[00:14:22]Yeah. No, I'm not a u not a VS Code person.

[00:15:57]All right, guys. Start thinking of some questions to ask me. I need to I need to farm some content here.

[00:16:54]So, okay. So, I've been thinking about the database stuff. It's not very exciting, but Oh, Patrick, thank you from YouTube. Um, yeah. So, the database stuff is not horribly interesting. However, Can I taste the difference? Okay, so in double blind studies, different eggs have not been found to taste different.

[00:17:23]However, pasture-raised eggs, for example, have much more orangey yolks, right? And sight is a part of like the dining experience, right? An orange yolk is much more like appealing.

[00:17:43]At least to me it is. And that's totally valid is even if it doesn't taste any different.

[00:17:50]That is often just the feed they give to the chickens. Yes. Or the feed that they forge for themselves being pasturized or whatever.

[00:18:10]feeding chickens certain things regardless of how they are raised. But why don't people do it then?

[00:18:31]Yeah, I suppose the variance in the diet like yeah, there's no taste taste, but like I I watched this YouTuber named Ethan Schlabowski and he breaks it down really well. He has a whole video on like different eggs and basically yes, it comes down to like sight and the human element when it comes down to different eggs.

[00:19:01]The conscience feels a little clearer.

[00:19:02]Eating eggs, then you know, brain chemicals and junk are might tell you that these are better or whatever.

[00:19:19]But in a double blind study where people can't tell the difference, people can't see the egg they're eating.

[00:19:28]Twitch chat sponsors use square.

[00:19:31]I'm not sure what that means.

[00:19:37]Okay, I got to take my inhaler and then we're jumping in the software and gamedev category.

[00:19:49]fresh eggs. That's like awesome. Yeah, my roommate in university, her parents raised chickens and uh we had just Yeah, we just had tons of fresh eggs all the time in the fridge. It was awesome.

[00:20:21]Chickens in the dorm. I never lived on campus. I always lived off campus in an apartment with like roommates.

[00:20:33]Do I use Vim? No, I use Emacs.

[00:20:45]Tell being healthy.

[00:20:47]Yes.

[00:20:51]I usually just run the the boiled eggs under really cold water. Usually that does it for me. That works pretty well.

[00:21:02]You got to run the tap for like five minutes though to get that level of cold water.

[00:21:13]Okay, I'm going to take this and then I'm going to talk about database stuff and then we're going to jump in the software and gamedev category. And you had better have some questions for me to do slash marker Done.

[00:22:46]Okay. Database stuff is exciting. Oh, okay. I'm glad you think so.

[00:22:53]Uh, everyone is so into eggs here. Eggs are awesome. Actually definitely survived on eggs a lot in university. Like I ate so many eggs.

[00:23:07]I still eat eggs. Usually I'm having like boiled eggs for breakfast unless I'm running late like today and then I'll microwave them.

[00:23:24]Yeah. Okay. So, I don't know if this is a real issue or not, but like the IO like blocking IO for database stuff in my game could be not great, right?

[00:23:46]I have to do what is database probably postgress phosphorus is anti-impregnation tool for ladies what yolks give ass cancer for dude what the [ __ ] are you talking about pisu What is blocking? I thought database is supposed to eliminate that. So blocking is when the thread stops to do some sort of work.

[00:24:28]That's blocking.

[00:24:31]So usually usually that means like input output stuff uh including database transactions, database queries, database transactions um file IO basically mostly IO No.

[00:25:03]Hey, Libas.

[00:25:09]All right, I'm going to the God Clanker to figure this out.

[00:25:13]Can eggs cause What's IO? Like a monad?

[00:25:30]Yeah. Input output basically. Okay.

[00:26:06]Oh god. Hey, Crash King.

[00:26:12]Sometimes when talk to database slow now everything's slow. Yeah, basically.

[00:26:21]So IO is like input and output like reading from some information from some source and outputting information to some source. So it can be files or file descriptors often. Uh usually it is you know reading from like a command line prompt from the user.

[00:26:47]My god, I might have to take my blue inhaler. I don't know why I'm coughing so much.

[00:27:10]Hey, Tin.

[00:27:21]This way while using a normal database or JSON objects in a folder for performance.

[00:27:40]Sorry, my nose is doing that thing again where it feels like the mucus is going to go all the way through and then it just kind of piles up at the back and doesn't go through.

[00:27:51]I might have to go back to the ENT.

[00:27:53]That's kind of weird. I've never had that feeling before.

[00:28:02]I am just getting over some sickness though.

[00:28:16]Ent ear nose and throat doctor.

[00:28:20]Uh what was I talking about? Blocking.

[00:28:25]So basically a thread will stop entirely and wait. Basically just stop and wait for the information to come to it.

[00:28:35]Right? Because whenever A program needs like information from a file using a file descriptor. They actually have to ask the operating system for that information, right? So they have to wait for theuler to context switch to the thing or whatever it is probably if it's like a running if there's like a process or if it's like the kernel like through a system call, right? Um, but basically the program in theory has to wait on something else to give it this information.

[00:29:15]So we we block the thread blocks, it'll just stop. And in a game, if you block the the thread that your game loop is on, it'll halt the simulation, right? If you're doing like a large database query or something that takes like a few hundred milliseconds. Well, now your game has basically stopped for like half a second, right?

[00:29:46]Many threads. Well, right now I only have one. And I'm trying to think of how I'm going to do this in a way that like doesn't lose information, which is why I use non-blocking, right?

[00:30:03]But the problem with nonblocking, and this is what I've yet to figure out, the problem with non-blocking IO, the problem with what is with my sinuses today?

[00:30:33]Well, the problem with nonblocking IO is if you're using something like uh a relational database, right?

[00:30:41]I'm going to just go take my blue inhaler. Like I I I can God, that's so annoying.

[00:30:54]The thing with relational day races is that while while an like there's no non I don't think there's any like non-blocking IO for Postgress right because it it won't be able to like have integrity if it was non-blocking so I need some kind of like buffer area with integrity but non-blocking to insert or make changes to Postgress you see what I This is what I was thinking of last night.

[00:31:56]God.

[00:32:00]All right, let's just jump in the software and game dev category.

[00:32:14]I was going to eat today for breakfast.

[00:32:15]We are very different.

[00:32:22]Wow. Pa soup, you weren't following.

[00:32:26]It's kind of surprising.

[00:32:35]Oh.

[00:32:37]I was like, where is Emacs? I had it minimized.

[00:32:53]I'll never be far. Okay. All right.

[00:33:10]Oh, hey uh YouTube folks, SA and Justin Martinez.

[00:33:19]God, sorry for coughing so much.

[00:33:24]Hi, Nora.

[00:33:43]How large is this database?

[00:33:45]I don't know. Not very large. It's just Postgress.

[00:34:27]What kind of data do I want to store?

[00:34:28]Well, I probably just store Oh my god, this is so annoying.

[00:34:52]Yeah. Uh, maybe I should just take my blue inhaler after all. Uh yeah, the not much data. What I want to store is a serialized version of the game state basically or a serialized version of the player.

[00:35:17]Maybe I want all the game state.

[00:35:31]What engine? None.

[00:35:39]The coughing makes me feel like I'm not on a remote job anymore with sick co-workers in the open space. I'm sorry.

[00:35:44]I'm just I just can't seem to cough up whatever the hell this is.

[00:35:59]No, not [ __ ] I was going to use I was planning on using Postgress in the memory. It is in memory already.

[00:36:33]Yeah, I'm trying to figure out like how to deal with this non-blocking stuff.

[00:36:38]Like, let's see.

[00:36:40]Well, if I go to the game loop or more importantly Play state implies aggress. I don't know about the history.

[00:37:02]Wait.

[00:37:24]Post fix implies a fix.

[00:37:37]Actually, I think I just need to switch powders. Pretty sure my powder is like just garbage.

[00:38:04]Uh, we're so bad at naming things.

[00:38:40]Hey, Fra. Huh?

[00:38:58]How's it going?

[00:39:01]Is there such a thing as watering plants too much? Yes, you can. You can actually drown plants. So, just be aware of that.

[00:39:09]Water it like every other day.

[00:39:13]Hello medi.

[00:39:18]Uh YouTube. What game am I working on? I am working on a kind of I don't know. I should come up with a name for it so people know.

[00:39:37]You got new hair. Yeah. Yeah. You didn't see You haven't seen it. I've been blonde for like what, two weeks now?

[00:39:48]When did the blondening happening happen?

[00:40:04]Yeah. Been like two weeks.

[00:40:11]And now I can't imagine having any other hair color.

[00:40:23]What about watering humans? Is there such a thing as too many showers? Not really. You might dry your hair out, though.

[00:41:12]Sorry, I just need to take care of some business. I felt long.

[00:41:40]Is this closure? Yes.

[00:41:43]Yes, it is. Actually, as a matter of fact, it is closure.

[00:41:54]How long does it take to dare dye hair like this? It took like an afternoon.

[00:41:58]Three and a half, four hours, I guess. I just got highlights, but they're like damn good highlights, and I'm going to get more highlights in August, probably.

[00:42:15]longer than Hannah.

[00:42:18]Yeah, but it was like whatever. It was fine. It wasn't that bad.

[00:42:40]That's probably fun, too, if the hairdresser is cool. Yeah. And my hairdresser is super cool.

[00:42:47]Databases a also work on some storage solutions today. Assembling furniture.

[00:42:52]Nice.

[00:42:55]Yeah, I was thinking like how am I going to get is it like cuz a game, right? You have players and they have like a position in like the world. Actually, this doesn't make any sense. I need to go back to the drawing board here because players have their islands, right?

[00:43:30]Trying to think of how to design this [ __ ] thing. Players have their islands. Uh doesn't make any sense.

[00:44:02]Only crazier than a database is not using one when you need one. Yeah, I'm like, do I need a database right now?

[00:44:09]I'm also like wondering that.

[00:44:18]I might even be overthinking it actually.

[00:44:27]Yeah, I'm just like I'm thinking like how would a game loop be structured?

[00:44:42]Would it be just one loop for all islands? I feel like that might not work.

[00:44:57]But if I do like one game loop per island, which is one thread, I'd have to have like a billion threads maybe.

[00:45:42]H I'm just trying to think how do I create the different worlds, the different I guess it wouldn't be that hard.

[00:46:15]batch the island updates so they're parallelizable.

[00:46:30]Wasn't World of Warcraft actually just one giant Oracle DB application? Was it That's kind of cool. Honestly, I'm like thinking of like the architecture. I guess maybe it could just be one one thing, but then I'm like, how do I was the point to have atomic transactions?

[00:47:36]Janet, start making a WoW server. No, I didn't. I'm just like I'm trying to come up with like stuff, I guess. Like, yeah, every island would have to be in the same like meta world really.

[00:48:04]or they could be their own like I guess what I'm trying to conceive of here. See how we have world this binding world and it's like bounds quattry insert all.

[00:48:21]Well, basically I'd have to have one of these for each player, I think, unless the players had joined worlds through the thing.

[00:48:37]The like plql probably Java and underlyings available.

[00:48:51]Good database. That's as good as database transactions. Well, this is what I was island little St. James. No. And please don't say things like that in the chat because I don't want to get banned.

[00:49:19]So yeah, maybe each I don't know. Yeah.

[00:49:22]Does it make sense to have one world or multiple islands or one world per island?

[00:49:34]The problem with having one world with all the islands in it just hidden from each other is that I'm going to have to write code that like puts islands in places that they don't overlap accidentally or collide or whatever. Right?

[00:49:55]If each player has their own world or island, that just happens, right?

[00:50:05]But then I have to do this operation for however many players are connected at any given time.

[00:50:15]I This is a good question. I don't know how many islands to expect. Honestly, it probably just be one island. It probably be my island. I don't think anybody's going to play this game.

[00:50:26]How does Animal Crossing do it? Yeah, I don't know. I have no idea. I'm just figuring this out.

[00:50:35]Okay, I'll ask God Clanker. Let's see.

[00:50:37]Uh, okay. One world per island or all islands in one world.

[00:50:50]Assume world is quad tree.

[00:50:54]fast collision detection.

[00:51:00]Oh yeah, that also kind of that might conflict with instancing as well cuz instances will have to be like their own may also be their own separate little world.

[00:51:15]But quadre are pretty fast so I'm not super worried about that.

[00:51:22]Depends on whether entities can cross island boundaries. One quad tree per island but under one game loop. Okay.

[00:51:44]Players colliding with environment entity can cross island boundaries with friends.

[00:52:06]Say that. See what the god clanker says.

[00:52:09]I don't usually like talking to Claude for architectural decisions though.

[00:52:36]Oh gosh. Okay.

[00:52:39]Per island quad trees seems to be the move here.

[00:52:46]And then if a player visits another island or they become one island mechanic is when become friends islands become free trade archipelos.

[00:53:12]How do I spell archipelago?

[00:53:29]I think. Yeah.

[00:53:35]Yeah. Merge them into merge them into an archipelago.

[00:53:40]Okay. This is good. This is good information. Chat room. I should probably spend a little more time like actually scribbling and designing this than just coding it, you know, willy-nilly.

[00:53:59]What's a quad tree? Uh Bert, do you know what a a binary tree is?

[00:54:11]AI is very smart. I don't know if it's very smart, but uh I think if I sat and thought about this for a little bit more, I probably would have come to the same conclusion.

[00:54:28]The real important thing is like not getting too in my head about like the architecture white paper live streams, but basically Yeah. So in a tree structure, you have a binary tree, right? Actually, square is probably wrong for this. You have a binary tree.

[00:54:50]So that's the root and then Oh, come on, Excaladra. [ __ ] off. God, what how who uses this? Why do I keep using it? It's so bad.

[00:55:07]Okay, so this is a binary tree.

[00:55:10]Make some more.

[00:55:18]One more.

[00:55:21]Yeah. Binary tree is where each child or each root has two children, right?

[00:55:36]This is the worst worst drawing of a binary tree ever. This is a binary tree.

[00:55:42]Uh so that's where each node has two children in exactly two children. Right?

[00:55:48]A quad tree is very similar except each except each node has four children instead of two. Right? We could literally just bring these two up here.

[00:56:09]And then yeah, we could also I mean it's going to be really difficult to draw this cuz by like the second second generation we've got like 16 children. Um but yeah, that's a quad tree. And the reason we use a quad tree is because we can actually very easily take a a quad.

[00:56:33]We can very easily take a quad like a square and subdivide it into four quadrants, right? We can take a square or rectangle and divide it into four quadrants. And you can actually recursively do this doing like recursively smaller and smaller squares until you get down to, you know, whatever the smallest square is. So by doing this, you can use a quad tree to actually very quickly do collision detection on large entity sets, at least in video games. And there's even something called an oct tree and 3D games, very similar, I'm sure you can guess by the name, where each node has eight children instead of four, right?

[00:57:25]And with an O tree, it's very similar.

[00:57:28]You can you can subdivide a 3D cube into I guess three-dimensional like sub cubes and recursively do that all the way down to a small unit for fast collision detection. So this is how some 3D games do fast collision detection.

[00:57:50]Databases do this for index searching too. Yeah, but indexes us or indexing usually relies on binary trees, but it's the same idea. Yeah.

[00:58:05]Uh B trees, quad trees, and oct trees.

[00:58:15]Maybe it's octo trees. I don't remember there. Wait, how does that work? I can imagine simplifying collisions by registering entities to regions, but how does the tree structure factor in? I'm not a game developer. I'm clueless about these things.

[00:58:31]Well, you can think of like the root node as being the entire map, right?

[00:58:37]And then if you if you turn the map into quadrants, maybe I can make this bigger.

[00:58:47]Come on. Come on. Excel. God damn it.

[00:58:52]So, let me grab this square. Right.

[00:58:56]So, this square. Oh, [ __ ] I get really angry at Excal because it just doesn't work the way I think.

[00:59:07]So, this is this is the entire game world right here. This square, right?

[00:59:12]And this square is represented by the root root node.

[00:59:21]If I cut this into fours, just pretend this is four even quadrants even though it's not.

[00:59:31]One.

[00:59:34]Why is that font so tiny?

[00:59:37]This is extra large, but it's like tiny skeleton. One, two, three, four.

[00:59:52]Okay, so we have this square. It's kind of hard to see. I'm sorry. I'm working with the stuff I ever saw. Yeah, they're pretty good squares, actually. But basically, so we have the root, and that's the whole thing. That's the whole whole thing on the outside here, right? And then each one of these nodes is a child.

[01:00:11]Oh my god. Excaladra, please.

[01:00:16]Oh, there's got to be I I have been so frustrated by Excaladraw before that I thought about just making my own.

[01:00:24]This is like kind of terrible.

[01:00:27]Yeah. Like why doesn't this come with Anyways, so we have root. That's the whole big square. And then each each quadrant is one, two, three, four, right? And then if we wanted to subdivide one into four of its own squares, which is just applying the same routine, we could do five, six, 7, and eight.

[01:01:03]And that corresponds to these.

[01:01:06]That's Yeah. No, this is five.

[01:01:10]Five.

[01:01:14]Oh my god, I can't type today. Feel like everything is just not going this way.

[01:01:19]Okay, so this is eight.

[01:01:22]So then we can recursively build out this tree, right? recursively build out this tree by constantly subdividing down to essentially the smallest like bit of information, which is usually like maybe a little sprite on screen or something.

[01:01:38]And then we can very quickly figure out which entities are going to collide, right? So we we can kind of traverse we can traverse down this route. See if we are like at the rooe and then there's the entity, you know, we're in quadrant 1, we're in quadrant five and then we can keep going down until we're just like down to uh basically two little boxes. And then you know are these entities are the entities inside this box overlapping?

[01:02:20]Basically that's it. Are the entities in these tiny little boxes overlapping?

[01:02:26]But normally the way people do this is something called uh axis align bounding boxes where they check every single entity in the game to see if the boxes those boxes are overlapping. But if you check every single entity in the game, you're probably wasting a lot of information or you're wasting a lot of compute on entities that aren't colliding, right?

[01:02:52]So, you want entities that will collide with the entity in question, right? So, basically what I do here, you can see it in the thing. So, we create the world, just a 10,000 x 10,000 bounds. We create the quad tree. Uh, we insert all the entities into the quad tree. So then they're put into their respective I guess sub nodes, right? And then I have to get uh in in the player.

[01:03:26]Thank you, Emacs.

[01:03:29]We go to the player for example. I take this quad tree and I receive I retrieve the intersections and see if the player basically I put the player in with the it's updated like movement coordinates right and check to see if it's going to like overlap with something and if it does overlap with an entity that is not this player as you can see by the next line other entity See then I just don't I just don't update the movement this this update frame right and then that creates the illusion of like you know collisions.

[01:04:16]So that's it that's yeah collision collision detection in a nutshell.

[01:04:27]Sorry for the longwinded explanation, but yeah, that's Hey, standard pointer.

[01:04:36]The idea you only subdivide dynamically if there are too many entities in one client, one quadrant, roughly the same amount of entities. Yeah, I think I think that's how the algorithm works.

[01:04:46]You you keep subdividing if there's more entities in it. But basically, you have to rebuild a tree every every frame, right? And then query it.

[01:04:56]Am I watching the big game tonight?

[01:04:58]What's which which big game?

[01:05:04]Which big game? Is there a Blue Jays game or something?

[01:05:08]Victtoire versus charge. Oh yeah. No, I don't know. Uh maybe I will actually.

[01:05:18]Frig, it's so sad. We were so we were so into the Toronto Scepters last year, but then the tickets were really expensive this year and yeah, they're not nearly as good and Sarah Nurse isn't on isn't on the team anymore.

[01:05:39]The Scepter has lost a lot of good players this year.

[01:05:48]What is that? We're talking about women's hockey.

[01:05:52]We're talking about professional w the professional women's hockey league, the PWHL, or as I like to call it, regular hockey.

[01:06:14]True. They don't get paid like regular hockey players.

[01:06:21]Am I an ex hockey player? No, I'm a Canadian.

[01:06:26]Do they fight sometimes? Actually, yeah, that's one thing that was really different about like this winter was I noticed there was more fighting on the rink.

[01:06:39]Last year there was not nearly as much like fighting on the rink.

[01:06:47]We're Canadian because you said sorry.

[01:06:53]Our trees might be easier to track down the paper for. Yeah, I just stick with quad trees for now.

[01:06:59]Oh, I hear the Canadian now. Oh, yeah, bud.

[01:07:09]All right, since we have an ad break, I'm going to go make a cup of coffee, I think.

[01:07:14]BRV. Yeah.

[01:08:25]Slowly allowing more hitting Uh, yes. Spacetime DB has an interesting concept.

[01:09:25]What should the trees solve?

[01:09:29]I'll just explain what the trees should solve. I guess the problem I'm trying to think of now is like architecturally.

[01:09:38]Okay, so we have basically separate quad trees for each island, one game loop.

[01:09:51]H I'm a little worried.

[01:10:57]Thanks for explaining. Quad trees boss called as soon as you started talking so I had to rewind. Oh.

[01:11:04]Oh, I see.

[01:11:11]Hey, Viking.

[01:11:13]How's it going? Are you in Kenyon again?

[01:11:27]still here. How are you? I am good.

[01:11:31]Actually, surprisingly pretty good.

[01:11:36]Just uh hacking away, I guess.

[01:11:45]Yo, what's up, Odin? I'm trying to think if there's anything new going on in life. Not really. Really kind of isn't.

[01:11:57]I'm trying to figure out how I'm going to do all these things I've never done before.

[01:12:30]like, yeah. Oh, yeah. Biking. How's the house coming? I saw a neurommancer hoodie the other day. I instantly thought of you. I wanted to buy for myself. A neurommancer hoodie. like uh wait the book neurommancer or Apple TV neurommancer.

[01:12:49]This is great. Did you move in yet?

[01:13:16]Yes. [ __ ] Okay, cool.

[01:13:52]need to finish electric plumbing and flooring. Server room is wired though.

[01:13:57]Priorities.

[01:13:59]My man has priorities.

[01:14:09]Yo, cucumber. Like, what? Why? Why did you come back to Why do you keep coming back to try and pick this bone?

[01:14:24]You did it yesterday, too. And you followed me.

[01:14:35]Oh, hey Johnson. Jeez, I didn't know you were here.

[01:14:56]At some point, we're going to find out that Cucumber here is like some like growth hacker for some AI company you've never heard of and educating the youth over You're having an awesome week.

[01:15:18]Yeah, it's pretty pretty good. Monday was a holiday, so yesterday first real day back.

[01:15:27]Been doing some spring cleaning.

[01:16:04]Yeah, I don't know, cucumber. I don't know if I don't know if that counts as educating the youth because I mean I was just explaining quad trees, but you're just shilling. So I don't It's like kind of like similar to when companies give away like free licenses to products for students so that then the students will become employees and have their company buy the business licenses, you know.

[01:16:52]So, okay. So, I guess it's decided AI is not a company. AI is absolutely a company.

[01:17:02]Well, I guess it's a ver a noun, but like all the cutting edge models are proprietary, so I don't know what you're talking about.

[01:17:21]Unless you're talking about like open source models.

[01:17:29]And I think it might blow your mind that the internet is is true. So, it's not a company, but it's actually, if you can believe it, it's actually a federation or confederation of different company networks.

[01:17:56]I feel like people don't understand that about the internet. The internet is actually like a federation of different company networks operating all on the same protocols.

[01:18:16]AI developer Twitch stream even work.

[01:18:19]Yeah, basically just praw pull that slot machine lever and hope for the best.

[01:18:27]In the past when I've tried to do it, it doesn't usually work out very well.

[01:18:34]Collusion detection now. Thanks for that collision detection. I'm glad you enjoyed it, Bert.

[01:18:44]Then the AI slot machine. Put bets on Poly Market.

[01:19:16]Okay. So, maybe I Gosh. Oh, goodness.

[01:19:21]This is all right. I need I probably need a way to send data to a database.

[01:19:28]and hot coffee. It is hot coffee like okay imagine we have a like a special thread for handling database crap. Basically the main thread the game loop says hey store this information for this player and then the the thing the thread does does the work obviously in a separate thread. So there's no blocking, but then we're going to have like this delay because there's going to be like a pipeline of things that constantly need to be written to the database, right?

[01:20:16]Maybe maybe Postgress is just the wrong thing for this. Is there like a streaming database?

[01:20:23]Streaming database.

[01:20:26]No, talk to them.

[01:20:44]Phone call or have talk to each other.

[01:20:46]What do you want? No. What do you want?

[01:20:56]I think the modern version of that is probably asking like a random website's chatbot to make you a React component or something.

[01:21:15]This is the second time someone's mentioned space-time DB. Let me look into this.

[01:21:28]apps and games. Of course, they have to say in the second line, "LMs go much further with space-time DB."

[01:21:39]Oh, no. Oh, I don't want to do this cuz you actually it's like one of those solutions that like combines code with it, right?

[01:22:16]Well, unless I create my own database, but I don't want to do that.

[01:22:22]Mean by streaming database. No, I was thinking like something with nonblocking IO or AI up.

[01:22:51]I need to have this coffee. I think my brain needs to do things.

[01:22:59]Wait.

[01:23:04]Oh, you said Nora. You said hot streamer. Hot coffee.

[01:23:12]Hey. Oh, you think I'm hot? Oh my. Oh my god. Stop.

[01:23:18]OTP does that.

[01:23:26]Brain do thing. Must thing more.

[01:23:28]Exactly.

[01:23:31]Brain no thing at the moment.

[01:23:36]Hot quad trees. Hot coffee. Hot quad trees.

[01:23:45]Maybe it doesn't matter.

[01:23:55]Ortho linear keyboard.

[01:24:00]Bim ortholineers look kind of cool. The pocket reform has an ortholinear keyboard.

[01:24:13]You get something like the glove 80. It makes a lot of sense cuz like it's like ortholinear with with like the curvature.

[01:24:22]The keyboard is curved like so it curves with like your fingers naturally or whatever.

[01:24:31]Very ergonomic. Very ergonomic.

[01:24:40]Well, I don't have an MNT pocket reform cuz they're expensive and they take forever to ship.

[01:24:54]I kind of wish I had one though.

[01:25:04]Okay, brain. Listen to me, brain. We got to do the thing here.

[01:25:20]Maybe it doesn't matter. Maybe an insert is like fast. How fast is an insert usually?

[01:25:32]Depends on the data maybe postgress insert.

[01:25:55]want to discover coding stream. Yeah, I'm trying to think of how I'm going to do like database stuff in my game.

[01:26:06]It's not going very well because my brain is not like awake.

[01:26:13]What is it adding a bee tree to a game?

[01:26:15]This is what you see on the screen is a quad tree. And I was explaining how quad trees work and what they're used for.

[01:26:38]Asynchronous IO unblocking Postgress possible your language stack.

[01:26:59]Uh, okay.

[01:27:08]Closure.

[01:27:18]Okay. So, basically, basically Claude just suggested what I was thinking this whole time, which was to run. basically just run the synchronous crap in like a core async thread.

[01:27:39]Okay. Uh yeah, with Java 21 virtual threads, I suppose what version of Java do I have?

[01:27:53]23. That means Core async uses virtual threads already.

[01:27:58]Sick. That's cool. All right. Freak it.

[01:28:02]Let's Let's Let's just do it. Chat room.

[01:28:04]Let's just do it. Let's just Let's just do it. Um depths. Eden.

[01:28:13]I have nothing.

[01:28:22]Java Postgress driver. We need the Postgress driver.

[01:28:28]Unless it's already here. I don't see it though.

[01:28:32]No.

[01:28:36]Download. Uh, wait a second, brother.

[01:28:42]Maven Central, homie.

[01:28:54]Good old Maven. Nothing beats that except when you get rate limited by [ __ ] Maven.

[01:29:01]You guys getting rate limited by Maven lately?

[01:29:05]I have been.

[01:29:07]Sucks.

[01:29:10]42.7.11.

[01:29:13]That is That's huge. Closure.

[01:29:19]Next. JDBC.

[01:29:21]JDBC homie.

[01:29:24]Hang on. I'm going to ask Clint God Clanker here. What about the in transit weary loss though?

[01:29:44]No.

[01:29:46]I mean stuff in the threads memory that hasn't made it to the DB yet.

[01:29:57]I guess I could create a write ahead to disk first.

[01:30:09]That's exactly what I was thinking, Clanker. a write ahead log because that's how databases actually do integrity now is they just literally write a log of the query to a file on disk. So I suppose I could do that if I was really concerned about losing the information.

[01:30:33]Ah frig my leg is itchy.

[01:30:38]This is why I don't use Claude.

[01:30:40]Basically, all all that like asking Claude for sometimes like this makes me really just second guess myself.

[01:30:52]I think that's probably why I don't like it is it just really makes me second guess myself and then like it tells me the same thing that I wanted to know that I had thought of already. Right?

[01:31:04]In that sense, it's validating, but in another sense, it's like I don't know, patronizing. Does that make sense?

[01:31:22]Poo. I don't know what those are.

[01:31:24]Honestly, I'm at the whims of like the closure build system.

[01:31:37]Okay, so I got the Postgress driver core async in there. What version of core sync is that?

[01:31:45]Closure core async core async latest version. Should we get the latest version chat room? I think we should. I think this version supports virtual threads all the same, but fine.

[01:32:06]And then uh yeah, next JDBC.

[01:32:21]Excellent.

[01:32:24]Although I can't wait for people to stop using GitHub aka Garbage Hub.

[01:32:31]Hello Pup. Hi.

[01:32:35]That mostly through the comment before figuring it out. It's a joke. Oh, that's not good for those kinds of questions. Castion do some write ahead log type stuff for integrity.

[01:32:54]That looks that looked kind of stupid.

[01:32:57]Um, well, that was funny. GitHub really fell off. I want to get off it. Bro, everybody's moving to Codeberg oring hosting their own forge, which I still need to do actually.

[01:33:08]And I have a sponsored stream coming up soon, which I need to figure out what I'm doing for that. Oh gosh, I have so much [ __ ] to do all the time.

[01:33:23]Uh, okay. So, what are we where are we at here?

[01:33:28]Why do I have a bunch of extra dependencies in here? Quad tree and stuff.

[01:33:36]I don't know. Okay, great. Amazing.

[01:33:41]Let's uh let's build it. Make sure nothing broke.

[01:33:45]I don't anticipate that anything broke, but [ __ ] happens.

[01:34:02]stressing over making the 1.7 merge window for PGCL.

[01:34:08]Is this like a common list thing? [ __ ] [ __ ] Sorry, I did not mean to delete your message. I meant to just remove the pin.

[01:34:21]You can post it again, Nadia, if you want. That was a mistake on my part.

[01:34:41]Yeah, but what's PGCL?

[01:34:52]like an open CL thing clustering ABI compatible algorithms for it. Oh, I see.

[01:35:04]Okay. Sauce. Where's my terminal at?

[01:35:08]Okay, we pulled all the stuff. We're good.

[01:35:16]Thank you, Nora.

[01:35:19]Thank you, Nora.

[01:35:21]Uh, brew services list. Let's see.

[01:35:30]Oh, great. Yeah.

[01:35:35]Brew services start Postgress.

[01:35:50]Homerew is just such a terrible, terrible [ __ ] thing.

[01:35:56]Unbound.

[01:35:57]How the Why do I have an Unbound Brew service that's not running?

[01:36:05]That's sus. That's That's [ __ ] sus, honestly.

[01:36:10]an unbound service. That sounds like a supply chain compromise.

[01:36:15]Uh, okay. Postgress.

[01:36:26]Mhm.

[01:36:30]How the [ __ ] do I connect to this [ __ ] World Progress does not exist. I'm pretty sure it does, dog. Actually, I don't know what the config is for this Postgress.

[01:37:21]Maybe I should not be using brew.

[01:37:23]Actually, I have like way too many Postgress things. I have whatever this uh elephant app is.

[01:37:54]Oh my god. What is uh Okay, there we go. Finally.

[01:38:12]God, forgot like Um, I ever remember how this works. Okay, it's so funny. I never I so rarely set up Postgress that I forget how to do it every single time.

[01:38:33]All right, let's do create database.

[01:38:39]I need a better name for this game.

[01:38:48]Do I have Docker? Yes, I literally have Postgress Docker. I have like two different brew services for Postgress 14 and 16. And I have the like elephant app or whatever it is that has uh version 15. It's a [ __ ] mess. Anyways, um I don't want to call it island game.

[01:39:12]That sounds stupid. My like I was calling it lowkey survival, but that's also kind of stupid.

[01:39:20]It needs a great marketing name.

[01:39:24]Great marketing name.

[01:39:27]Like a game that people are going to be like, "That's amazing.

[01:40:17]ball. Escape from Jankenov. We like island.

[01:40:28]Well, what's the I guess what what do I what do we what are we doing with the island? We're surviving.

[01:40:40]Islander.

[01:40:42]Uh we're surviving.

[01:40:46]Hang on. I need to check something real quick, you guys.

[01:40:50]Oh my god, you guys.

[01:41:21]Oops.

[01:41:27]Uh, Prince Elward Island: The Fall. Wow.

[01:41:42]Call of the Wilds. You guys are going to get me sued.

[01:41:56]Public domain book. Oh yeah, there we go.

[01:42:07]Island rush. That sounds like we're doing leather cleaner.

[01:42:17]Literally, I can't think of the word rush in any other context.

[01:42:22]Breath of Duty. Really?

[01:42:27]Oh my god. Okay, you know what? I'm just going to put in a placeholder name.

[01:42:33]Sons of the island.

[01:42:37]Once a legend.

[01:42:39]That sounds like something somebody who was once a legend would say. So Hang on, hang on, hang on, hang on.

[01:43:20]I forget how things work. Let's see.

[01:43:47]Hi Judy.

[01:43:51]Nice hold island. The fall of drop.

[01:43:55]Just put a bunch of like uh words in there.

[01:44:02]Bunch of good sounding words. Ball of drop.

[01:44:35]My little island growing the devil's lettuce is magic.

[01:44:41]Oh my god.

[01:44:45]Well, these are horrible names.

[01:44:49]It should be like one word that you can just say one word, right?

[01:44:54]If you have to have like a bunch of words.

[01:45:00]Oh, so it's like my idea is like adventuring maybe cave cave island cave land my widow island.

[01:45:15]That's that's that's good.

[01:45:21]Heycape Daddy's island.

[01:45:27]Oh my god.

[01:45:29]Widow. Yeah, Widow Grad Venture like graph. No, that's not No, it needs to pop Ireland.

[01:45:42]It needs to pop, you guys. Come on. It needs to pop like Bro, okay. You see a game named Bro and you're like, I get it.

[01:46:06]Bro, land.

[01:46:09]Come on.

[01:46:11]Oh my god.

[01:46:48]Don't worry, you didn't miss anything.

[01:46:59]There's something wrong with reality.

[01:47:02]No, there's nothing wrong with the reality. All right. Well, I'll have to think about the name. So, create database game.

[01:47:14]Database game.

[01:47:27]which is kind of a weak name, but whatever.

[01:47:34]DBG database game, nothing else.

[01:47:37]Perfect. It's perfect.

[01:47:57]Okay, great. Uh, let's connect to a game.

[01:48:07]read table.

[01:48:10]Oh, I should probably write these down somewhere.

[01:48:15]Oh, I don't want to do migrations. Boo.

[01:48:20]Uh, forget it. I'm not going to do migrations yet. We're just messing around. Create table players or users. table users.

[01:48:36]Uh jeez, how do I make ID?

[01:48:45]Why can't I remember how to do this?

[01:48:48]Okay, hang on. I can't I have to actually like open an SQL document probably.

[01:48:55]Oops.

[01:49:03]2L. Sure, why not? Amazing.

[01:49:17]Great database game.

[01:49:20]Evil if not exists.

[01:49:30]Does the if not exist go before or after?

[01:49:41]Yes.

[01:49:43]Okay. Well, it goes before, doesn't it?

[01:49:58]Message to be deleted. What's happening?

[01:50:00]An OM. Nah, OMS are more issues than they're worth, honestly, half the time.

[01:50:09]What? Why is there Okay, that was weird.

[01:50:12]table if non-exist players ID primary is it primary what got it primary key [ __ ] oh my god this is embarrassing serial primary key [ __ ] hell Proof of a conspiracy.

[01:50:48]No way.

[01:50:52]Oops.

[01:50:55]Username text unique not null password. Uh oh. I need the [ __ ] I need the [ __ ] crypto extension for [ __ ] stuff.

[01:51:20]Let's guess crypto extension password.

[01:51:32]PG crypto.

[01:51:38]Oh my. I need to use the washroom as well. Does this go before creating the database? I think it does actually.

[01:51:47]Uh, okay. Um, password. Yeah, it should be password hash.

[01:51:56]Text not.

[01:52:00]Mhm.

[01:52:03]Right. Right. Right. Okay. And then we use gen crypt and gen salt when we insert into the database.

[01:52:13]Right. Right. Right homie. Right. I remember how to do web stuff. I promise I'm a real professional software developer, you guys. I do get paid actual money to do this.

[01:52:34]Cloudflare shoeler.

[01:52:40]For some reason, that reminds me of Pomeranian dogs. I like palms. They're cute dogs.

[01:52:56]Yeah, they are cute game.

[01:53:02]I I have to sit down and think of a killer name for this game.

[01:53:10]Professional developer struggling to write SQL. I mean, yeah, that's basically the truth.

[01:53:17]basically the truth. Maybe Cucumber is right.

[01:53:23]No, I always forget how to do this.

[01:53:25]Inserting and stuff. No problem. But like it's always the stuff that I I've only I only do like rarely that I just like my brain just autodeletes, right?

[01:53:36]Adult simulator game. That's the farming game.

[01:53:56]created at updated. Oh, I don't like audit tables. All right, whatever.

[01:54:06]Time stamp default now.

[01:54:12]Default meow update at time stamp default meow.

[01:54:22]All right, that should be enough, right? Unless I want to like collect a bunch of user data and then get hacked and then get sued or whatever. Number of bands.

[01:54:52]Oops.

[01:54:54]Email 2FA.

[01:54:56]2FA. What?

[01:54:59]Username or Do I need email? Do I want email?

[01:55:11]I don't know if I want people's email addresses.

[01:55:26]All right. And I probably want to have a friends list, too.

[01:55:30]Oh, that's definitely a a friends list is kind of important.

[01:55:40]Amazing.

[01:55:42]Okay.

[01:55:44]Uh [ __ ] Friend. Could a friends list? Maybe even a block list? I don't know. Could a friends list be like just an array of other players ids or usernames rather is active flag. No, we're not like I don't want to build like a whole like friend ecosystem yet. I don't think I mean we we're talking about how to build the engine before we have wheels. Really?

[01:56:31]I don't want to build a social network.

[01:56:35]table friends.

[01:56:43]Friend friends player ID friend ID.

[01:56:52]Yeah, that could work. Judy, you need GraphQL. Okay, chat is not being very helpful right now.

[01:57:05]friends.

[01:57:16]Don't do any of the things he suggested.

[01:57:32]like player ID, int references, players ID, something like this.

[01:57:59]array of IDs on the player. That's what I was thinking. That was what I thought the first time.

[01:58:09]Entry for every friend and you have to match to the other side. That Yes, actually. Yeah, that's kind of stupid.

[01:58:16]Well, wait a second.

[01:58:18]It's kind of not dumb though.

[01:58:23]Do people have to ex people people, Facebook, Google.

[01:58:37]Well, like okay. So like logging an O flow is very different than this table. But yes, actually I did kind of want to support off flows like that too, especially like having like a a sign in with Twitch option, you know, for now. Anyways, sign in for Twitch.

[01:59:09]Sign in with Twitch during development would be kind of nice.

[01:59:19]So then all my subscribing homies can play the game or help me test it, I guess.

[01:59:28]Hand to survival. Perfect. Actually 10 out of the 10 name, honestly.

[01:59:58]Why are all the dev streamers on Twitch so hot?

[02:00:02]Uh, good question. I don't know.

[02:00:06]JSON B for friends and store them with a friends. Yeah. Well, I'm like, okay, so how does this work? Because like basically people get an invite URL and when when the target person accepts the invite by clicking on the invite URL and clicking accept, you become friends.

[02:00:41]No, no. I think we're thinking of this too literally, right? Like we're not they could be friends, but the thing is that the more important thing is that we need some information to be able to say these islands are in an archipelago. And if people don't want to be in the archipelago anymore, they can not be in the archipelago.

[02:01:07]So, I don't know if a friends list makes sense. Maybe it does. Then we we rebuild the archipelago.

[02:01:22]every when people log in or when the server starts by player ID. Well, if there's if if the person doesn't have an account already, then that would trigger the sign up flow, right?

[02:01:45]Can I explain what an archipelago is?

[02:01:48]It's just a chain of islands. That's it.

[02:01:51]quite literally just a chain of islands, you know, or a grouping of islands.

[02:02:08]I don't know how to spell archipelago and your fancy words.

[02:02:15]Just a bunch of [ __ ] islands.

[02:02:27]Wow. Island for sale here.

[02:02:40]I still can't decide if it's a hair up or hair day down day. Okay. So, yeah. I mean, archipelago.

[02:02:53]I guess we're gonna have to have friends.

[02:03:06]Hair of day is a good day. Hair looks nice both ways.

[02:03:12]Chat is very split on the hair.

[02:03:16]It seems I'm split on the hair invited by URL.

[02:03:26]Uh actually, I feel like yeah, maybe this won't work cuz if like someone invites a friend and then that friend invites another friend, do I hide the other island unless they're like they accept the friends request from the original friend or should it be more like a Discord model where people join like if people you know like it's like a the Discord server model somebody basically owns this archipelago but every time somebody joins the archipelago they add an island to it which could work.

[02:04:24]You want me to wink at you?

[02:04:27]I used the wrong eye meant to do with this one.

[02:04:31][ __ ] That was great.

[02:04:41]They can select island to click. Ah, yeah. I'm going to have to actually sit down and think more about this because I'm I'm beginning to realize problems with the model. But if it's a Discord model, then I feel like I don't want I what I don't want is to people to start over. They like unless I make the game loop a lot shorter than what I was originally thinking.

[02:05:09]How to make an architecture document.

[02:05:10]Yeah, I need to actually like probably make like some a game design document.

[02:05:15]And by game design document, I'm just scribble on paper.

[02:05:19]But yeah, architecture.

[02:05:23][ __ ] Yeah, that's tough.

[02:05:28]That is tough. Chat room. I'll say it.

[02:05:31]Banana boat. Flying fish.

[02:05:34]Komodo dragons. I need answers. There could be. We could add Komodo dragons.

[02:05:39]Hey, Fallen Learns.

[02:05:41]Does the Discord model work though?

[02:05:51]Does the Discord model work?

[02:05:55]High altitude flying fish. Oh yeah, probably for like fishing and stuff because I wanted I guess if like a fresh island is started.

[02:06:17]Well, actually, yeah, that's kind of what the fun part of is like when I think about So, I'm borrow There's some like inspiration I'm borrowing from World of Warcraft. Coding is hard as [ __ ] Yes. Yes, it is. Some I'm borrowing some There's some inspiration here from World of Warcraft and fresh servers are always the funnest servers and classic era servers.

[02:06:41]So many questions about the island. We can never really know what goes on on the island.

[02:06:48]When islands put sanctions on each other, it's more like everybody gets their own island. That's the model I wanted it to be. Everybody gets their own island and then you like make friends with other islands and then you can travel to other islands.

[02:07:05]So maybe actually BRB I'm gonna go to the Jeez. All right. Sorry about the hold up. Looking for a drinking coffee.

[02:12:21]Um, question for you guys.

[02:12:28]Have you ever wanted to get a landline in the year 2026 or 2025 for that matter? Actually, have you ever wanted to get a landline after the year 2020?

[02:12:44]You have a landline, shrimp? No way, dude. I'm like I'm like, do I want a landline? I don't know. Landlines are expensive for some reason. Landlines are expensive.

[02:12:58]I don't know why.

[02:13:01]Why would I need a landline who talks on the phone?

[02:13:04]Me, obviously.

[02:13:06]I talk on the phone.

[02:13:09]I can get unlimited local calling for like $60 a month, which is freaking insanely expensive. My My cell phone bill has unlimited Canadawide calling and internet access for less than $60 a month.

[02:13:35]here. Landline is not expensive. Shrimp, don't you live in Nova Scotia?

[02:13:40]Or am I thinking someone else? Oh, this is flat now.

[02:13:46]This bubbly is incredible.

[02:13:48]Blueberry pomegranate. But when it's flat, it tastes like cough syrup. Wrong continent. Oh, you're in the UK. Okay.

[02:13:57]It's either Nova Scotia or the UK. Very similar places.

[02:14:03]Very similar.

[02:14:06]So jet lag. So now I don't know where I'm at, where I am. Hi Bler land that comes with internet connection and it's free. I don't have a phone connected to it. Oh, see I like kind of miss having a landline a little bit.

[02:14:28]There's also like the Bluetooth thingy you can get that like turns any old telephone into like a Bluetooth hand headset handset I think.

[02:14:48]Where is my wish list at?

[02:14:51]Pretty sure I put it on my wish list.

[02:14:58]Does Amazon even have wish lists anymore?

[02:15:05]Stuff I want. Here we go.

[02:15:08]Oh, yeah. Okay.

[02:15:15]Um, nope. That's Nope. That's not it.

[02:15:23]Okay.

[02:15:26]I for what it's called. I forget what it's called. But you just want a physical old style phone, bro.

[02:15:38]Yo, React Mogs, you uh you're a possible ban evader being monitored according to Twitch.

[02:15:51]Looks so miserable. Is it because she don't have kids?

[02:15:59]Thank you, Nora.

[02:16:06]The additional eight attributes used to calculate Merkel branch trees and data span. Problem solved. They'll be back and in greater numbers.

[02:16:18]They wanted $30 a month thing to put up more cell towers in my town.

[02:16:23]JSON B for friends. I don't that's a good idea. I do need to sit and think more about stuff the game know when they come and say that like when people come in here and they say misogynistic things like that sometimes it doesn't really bother me like I can't have children so I don't unless I adopt kids so I'm Build Animal Crossing enclosure script.

[02:17:04]Make no mistakes. Perfect.

[02:17:32]Why can't I make a baby? Cuz I'm probably sterile. That's why Claude never makes mistakes. People just write mistaken prompts. Exactly.

[02:17:50]You know, I was thinking yesterday, I was like, for some reason, when it's hot and sunny, I feel really good, right? But not just good like cuz like the sun is nice and stuff.

[02:18:06]I actually feel much more like creative and stuff when it's like sunny out. Does that make any sense? I feel like I'm super creative in the summer and then in the winter I'm like depressed and I hate my life.

[02:18:21]Love the tech bros think don't make mistakes actually works well. I mean if you pull that slot machine lever enough times even a broken clock is right twice a day.

[02:18:36]Yeah. There's lamps to solve that. No, it's not the same. I don't think it's the same thing like sun and like energy and like vibr like like people like like this city comes to life in the summer basically.

[02:18:51]People outside are like they just look happy and they're vibrant and like everybody's like doing stuff right and then that energy is like yeah I feel more creative. I feel more energetic and more creative. Hey, Bedro them because I do work for a ton of people. You are making me making it squeal. What?

[02:19:14]I'm with you on this. I know. I'm like I'm like this close to being a digital snowad like for three or four months.

[02:19:21]Like I just want to skip the brutal part of Canadian winter and live somewhere warm and sunny.

[02:19:28]It's a real neon lamp. Oh, SQL. Yeah.

[02:19:32]Yeah. Yeah. No, I really got to put in some more like game design thought and then some architecture thought. I think my the brain like the gears in my brain were just like turning yesterday. I was like, "This is so smart. I didn't write any of my ideas down." I was like, "Yeah, I got to figure something's out.

[02:19:50]This is going to be cool." Right? And then today it's like not nearly as nice out. I'm like, I don't know. It's always when I'm when it's sunny and warm out I feel better.

[02:20:28]Moving to Florida. Yeah. No, not not Florida. Uh-uh. No. Once I get my new my new passport, I'm I was like thinking like could I get a digital nomad visa for somewhere hot and toasty since I'm like completely remote? Like I should really be taking advantage of like being remote AF.

[02:20:53]Well, then I I don't really want to move for like twice a year, right?

[02:21:00]I'd be basically if I did that I would end up living out of a suitcase or be paying like four months of rent for an apartment for no reason.

[02:21:14]So, kind of a tough decision, but imagine if I could just like pack up and stream from like somewhere warm.

[02:21:30]It's a lot of equipment to bring though.

[02:21:33]Very scary to check a bag with like electronics. So, I'm not even sure how that would work.

[02:21:42]skip US and go straight to Mexico. I would probably fly directly to Buenos Aerys Buenos Aris and learn Spanish. Kind of want to learn Spanish actually or maybe just go to Spain.

[02:22:06]Mhm.

[02:22:13]I don't know. Lots to think about. Lots to think about, but I'll probably forget. And then in like in when the winter starts to come back, I'll be like, "Oh, I should have left. I should have went somewhere." You know?

[02:22:33]Could, but you might. Not. But you will later. What?

[02:22:43]What?

[02:22:48]Oops.

[02:23:16]I also need to come up with a live stream segment. Oh my god, I have so many things to come up with. I don't even know what to come up with.

[02:23:25]Need for like a single long form video and I am not using it.

[02:23:31]So I don't know what to do.

[02:23:36]Argentina doesn't seem that great at the moment. Why?

[02:23:58]Yeah. Hi, Nora.

[02:24:03]economic troubles if I recall correctly.

[02:24:05]Yeah, they always have economic troubles though.

[02:24:09]There's uh like I think economists say every economy in the world is the same except for Japan and Argentina.

[02:24:22]These are like the two critical outliers in every economic data set ever.

[02:24:28]Usually Japan is the outlier on the good metrics and Argentina is usually the outlier on the bad metrics.

[02:24:41]No, it seems fine. I think it's it's probably fine. And it's also like one of the top cities on nomads.com right now, shockingly.

[02:24:53]I mean, Thailand would be cool, but I don't want to fly all the way.

[02:24:57]Well, actually, yeah, it's like 13 hours to fly to Buenos Aires. I think it's about the same amount of flying time to Thailand, but I feel like I could learn Spanish easier, right?

[02:25:13]Because I know a bit of French and Spanish actually felt kind of easy to pick up words when I was in Spain. So, It's the labia.

[02:25:34]Mhm.

[02:25:36]I don't know what dawn means.

[02:25:43]Where is the library?

[02:25:48]Why not Thailand? Hot and good place for a nomad. True.

[02:25:54]Uh, overseas. Yeah, I don't know how much how long does it take to fly to Thailand.

[02:26:06]Oh my god. Google, please.

[02:26:11]BKK.

[02:26:15]Sure. We'll fly tomorrow and return someday.

[02:26:24]Bro, no. Uh, there's no direct flights. Not a single direct flight.

[02:26:42]I guess that's probably because the air travel is just all bet like dried up.

[02:27:03]There aren't even in any direct flights from Air Canada. This the quickest flight to Thailand is apparently 29 hours.

[02:27:16]I don't know. Yeah, I don't know what happened to any of the direct flights.

[02:27:18]They just kind of disappeared. That's weird.

[02:27:22]When to pick up lady boys, bro. I am the lady boy.

[02:27:30]Although, I hate that. I hate that term.

[02:27:33]I think a lot of girls would consider it uh a slur.

[02:27:40]That's about 24 hours too long. Yeah, I think a flight to Buenos Aries is like 13.

[02:27:59]Let us depart. And it's cheap. What the heck?

[02:28:14]So like Air Canada has this recurring flight to Buenos Aries that has to stop in S.

[02:28:22]Paulo for a fuel up. But basically it's basically a direct flight because you would just get off, stay at the gate and get back on, I'm guessing.

[02:28:41]Yeah, actually I have no idea how that works. I've never been on an airplane that just had to stop and fuel up.

[02:28:53]Pretty sure it's the same flight.

[02:28:56]You see?

[02:29:01]Well, anyways, last time I looked into this, but yeah. Wow. Only $600 something dollars to fly to Buenos Aries.

[02:29:09]Flying to Thailand cost many thousands of dollars.

[02:29:14]I'll stop Ericen to Bangkok from Vancouver. Yeah, but then I got to fly to Vancouver first and then fly.

[02:29:25]Turn around in the air and refuel us without getting off. Interesting.

[02:29:35]Yeah, I don't know, guys. I don't know.

[02:29:37]But like I've just constantly been thinking and actually one of the reasons I wanted to be self-employed in the first place was actually to be able to travel more when I want to travel, right? And do stuff like this, like be a digital snowad.

[02:29:57]Yeah.

[02:30:05]got paid for that project. What project?

[02:30:08]What engine am I using? None. No engine here.

[02:30:15]I'm sorry. I don't remember the project.

[02:30:17]Bedro. I'm like a goldfish. Honestly, I don't remember anything anymore.

[02:30:24]DWDW Janet's own engine J Joe the Joe engine Janet JE wasn't it JWM is like Joe's window manager Yeah, I support this.

[02:30:58]Joe last name engine.

[02:31:06]Did Did the last once for all client cyber prediction fixing work the last time? Yes, it did. Actually, you want to see it in action?

[02:31:22]Call this guy left. Oh, and I figured out what the bug was from yesterday.

[02:31:29]I just haven't fixed it yet.

[02:31:32]Notice how the clock didn't show up until the scene loaded. I mean, I still have to fix that, but yeah, basically here it is. Client side prediction in all its glory. No drift.

[02:31:45]There's a little bit of hitching on the players part, but that's because of like it's very subtle. That's because I don't have any error tolerance built into the reconciliation function, but it's still pretty good. Like, look how accurate that is.

[02:32:07]Like what big problems did I have to fix for the prediction? Well, basically I just had to reimplement it from scratch.

[02:32:24]I just wasn't doing it properly basically.

[02:32:35]It clipped over the fourth quadrant.

[02:32:42]So yeah, it works. And the clocks are even synchronized like like both both screens will get dark like as the nightfall comes and stuff. So which is also very cool.

[02:33:15]displace two or three lengths to the right. Yeah, it would in the past, but that's because I wasn't even doing client side prediction correctly.

[02:33:24]I guess the key takeaway is that I what I was supposed to be predicting was just the players movement, nothing else. But I think in the previous iteration I was predicting other stuff too.

[02:33:43]Wait, GitHub says 3,800 repositories breached. What?

[02:33:55]Holy [ __ ] It's just one thing after the next for GitHub, isn't it?

[02:34:16]confirms breach of 3,800 repos via malicious VS Code extension.

[02:34:23]Well, that's what people get for using VS Code, first of all. Yo, T2, what's up? Welcome back. Welcome back. Welcome back to the to the stream to the Janetta car stream. Welcome readers. Hope you guys had a good stream.

[02:34:40]Thoughts on versus cyber security as a career.

[02:34:45]They're they're just different like but technically adjacent fields really and they overlap sometimes, right? If you if you want to go into cyber security like the best hackers build their own tools and that usually means coding. So, and usually the best SWE know enough about security to not bankrupt their company or a v GitHub.

[02:35:10]So, the tools you can't talk about still sick. I hate it. Take care of you all.

[02:35:18]Aw, I hope you feel better, T2. Usually when I feel sick, I make a big pot of soup. Chicken noodle soup. Party party savory chicken noodle soup with tons of vegetables. That always brings me back.

[02:35:32]I made it for me and my girlfriend this past weekend when we were sick. I felt better the next day.

[02:35:39]Me ain't raider. Oh, you're not a raider, Dexter. Even though it says you're a raider. I see you. This is cool. I understand. Everybody watches a few streams at once. You know, it's no big deal. Sometimes I just sit here and I'm like, I don't know what to do, which is pretty often if I'm being honest.

[02:36:05]Yeah, welcome readers. Uh, I was just showing off my client side prediction.

[02:36:13]Do I like dislike VS Code? I dislike Microsoft.

[02:36:20]Microsoft having its hands in GitHub, VS Code, and OpenAI. That is not a coincidence, guys. That is embrace, extend, and extinguish.

[02:36:38]It also speaks insane volumes that Microsoft employees are not even allowed to use AI coding assistance, or they weren't for a while. I don't know what the situation is now.

[02:36:54]So, you don't want a 2 GB Electron app running on your system? Honestly, Dexter, this game will probably be an Electron app. So, uh it's fine.

[02:37:08]But, uh VS Code, I I just like it's not that it's made with Electron.

[02:37:14]The thing about VS Code is that it's like sketchy.

[02:37:19]Microsoft controlling the entire like developer workflow scares the [ __ ] out of me.

[02:37:38]Everything centralized in one place makes it easy target. This is a bigger fallout.

[02:37:51]Yeah. So, I don't know.

[02:37:54]I guess like like I'm like Okay, you guys are you have to remember like I'm like old school open source, right? I was like using Linux when I was like 13 or something 13 or 14. 14, I think. Cuz I started coding at like 13 and then Linux came in high school.

[02:38:15]So, like, you know, like I I'm like I feel like I'm old school like Foss, right? Like I don't like Microsoft. I'm like not only old school but also old. Wow.

[02:38:30]Wow. You were being so mean, Bedro.

[02:38:35]The 80s, guys. Come on. It was like 2006 for God's sakes.

[02:38:41]Holy.

[02:38:45]You don't have to be old school to hate Microsoft. Yeah, but like Yeah. I don't know. I just grew up like I guess using free software and watching things like Revolution OS and all kinds of stuff, right?

[02:39:01]Born within 5 years of 2006, bro.

[02:39:06]To not reveal your age. So what are you like 25 Fedra or something?

[02:39:12]25ish.

[02:39:17]Remember when maths building lab had WW equals worldwide waste on the whiteboard? Everyone agreed so no one erased it.

[02:39:32]Early 20s.

[02:39:34]I am in my early 30s.

[02:39:41]Yeah. So, just a baby. Yeah. Oh my god. I feel you're making me feel old, Bedro.

[02:40:01]It's kind of cool. There's a like diverse like amount of people I bring into the stream though. That's kind of cool.

[02:40:14]Yeah, 90s. The '9s was cool. Actually, I find myself like being stupid nostalgic for the '9s, even though I only lived in the '9s for like, I don't know, eight years. I was only alive in the '9s for like eight years. A couple of which I remember like 97 onward is when I started having memories, right, girl? You need to visit Greece or Albania for this summer? That could be cool. I need to wait for my passport to come though. It's still printing.

[02:40:57]They're like it's expected by June 4th.

[02:40:59]like okay so without my passport I am going nowhere fast but basically when we went to Portugal I had like a taste of warm weather during the Canadian winter and now I'm like hooked. I'm like I'm out of here.

[02:41:50]Yeah, good old travel.

[02:41:55]Good old passports. Nothing beats that.

[02:41:59]Scan your face. You scan your passport and you travel around.

[02:42:12]holiday and Tom's during the dog days of summer.

[02:42:20]Actually, I don't even think I'd want to leave Toronto in the summer. Like, Toronto is a super fun city in the summer.

[02:42:28]Super fun. Like, really, really fun city in the summer.

[02:42:32]It's very common to just be walking around somewhere and there's some brand giving away free drinks or something.

[02:42:39]God, my nose is so itchy.

[02:42:46]I really want to move to Canada. Not going to lie. Canada's I kind of have a problem with immigration. So, um and winter sucks.

[02:42:59]Winter is okay until like after New Year's, right? Because like typically, especially in Toronto, like in December, you kind of have like three weeks of real winter and then right up until after New Year, once New Year's Day hits, then it's all downhill from there. The next four months are just [ __ ] miserable. Basically, next four or five months are like miserable.

[02:43:31]Yeah, once you get to January and February, oh, and then like those are the worst cold months. And then you get to March and March is just like rainy and cold and overcast and [ __ ] miserable. Like March is like the most [ __ ] month of the year.

[02:43:50]Absolutely.

[02:43:57]Crazy database. Yeah, why not use UTC for time stamps?

[02:44:04]Uh, I don't know because I don't really care at the moment.

[02:44:13]Oh man, why is my nose itchy behind the microphone here?

[02:44:27]Canada has deers. Good.

[02:44:37]You run it once to create the table.

[02:44:43]Yeah.

[02:44:48]Hey, wait a second. Didn't I put Oh, yeah. Okay. I thought I put the extension in there.

[02:44:58]I don't know how to pronounce that.

[02:44:59]Nadia Trumpo, you become a digital mailman. You will regret not having used UTC in your database.

[02:45:12]Okay, that's fair.

[02:45:15]It's pretty easy to set the time stamp though, I think.

[02:45:22]So basically Bedro when you have a database you have like migrations right and that's when you create tables.

[02:45:34]So usually there's an initial like schema for your database and then which is like you just create a bunch of tables. Then if you have a migration you typically have code that is an is like the up migration which creates like tables and stuff and columns and junk and then the down migration which undoes all of the up stuff.

[02:46:03]But yeah, typically you run migrations once just to change the structure of the tables and the database.

[02:46:15]You don't run it. You don't run it every time unless you want to unless you're starting from a clean fresh database in which case you would want to want to run it, right?

[02:46:27]That's why it says create database game.

[02:46:30]And then Which it probably should not say create database game actually because then that means I have to connect to the game database.

[02:47:00]Create database game connect to game.

[02:47:09]What squeal is this? SQL light. This is Postgress or Postgress Post Gree SQL or whatever.

[02:47:25]Why do I have that corporate shark upper management style? What? What gives you that impression? I'm I'm not even I'm not like I'm not even an employee.

[02:47:39]SQLite works for this project. I mean, it might work. SQLite is an in-memory database though.

[02:47:49]Imagine being employed.

[02:47:51]Can you imagine you guys? I cannot.

[02:47:58]If I give scrum master vibes, what should I just go out and become an agile coach? Then like companies can hire me. I'll be an agile coach, whatever that means.

[02:48:16]In memory DB it's is persistent though, right? No, an in-memory database means it lives in memory, but you can query it like a database, right?

[02:48:33]SQL light. Yeah, I'm sure that it like writes to files, but it's largely in the in-memory database.

[02:48:53]Yeah. Well, that's what they mean when they say embedded database, right?

[02:49:06]SQL light lives in one database or one file call it migration database and table creation cycle was so confusing. This migration is always associated from moving from one system to another. Well, I I guess you can think about it right when you say like a a migration, a database migration, you can think about it as in moving from one schema to another, right?

[02:49:36]That's how I would think about it because when you add tables or you change relationships, right? you change relationships in your like entity relationship diagram or something.

[02:49:49]Technically, you've created a new schema, right? You've created a new version or a new schema. So, you're like migrating to that new schema.

[02:49:58]I think that's where it come from comes from. I'm not 100% sure.

[02:50:12]ignorant, incompetent. I would never have been laid off and still have a job.

[02:50:16]Um, I don't know if that's how that works, Nadia. I think people are just laying off people left and right because it's good for the stock market.

[02:50:28]Investors love that [ __ ] you lay off like a bunch of people and say because of AI investors, oh my god, they will just they just gobble off all your stock. That's really what's going on here.

[02:50:53]I do not know about the SQL terms of service. SQL light terms of service.

[02:51:01]Gross but true.

[02:51:04]There are two now in the Janet's create table guaranteed to be equal.

[02:51:10]Uh maybe yo Zed, what's up?

[02:51:16]Zed Asia.

[02:51:21]Welcome raiders. Hope you guys had a good stream.

[02:51:27]Raiding back. How's your stream going?

[02:51:29]Uh, it's going. I'm not writing a lot of code today, but the other day we did figure out the client side prediction once and for all. It works properly now.

[02:51:40]So, that's cool.

[02:51:53]the rule.

[02:51:56]Uh, wow. Okay, that's um weird.

[02:52:09]Number 63. Love Chastity.

[02:52:12]Hell yeah.

[02:52:16]Who's chastity though?

[02:52:25]Going to serve 100k users. SQLite is not a good choice.

[02:52:30]Yeah, that's this is kind of be not addicted to wine. What is this list?

[02:52:44]attribute to God and not to self whatever good you see in yourself.

[02:52:52]That's weird.

[02:53:01]Yeah. If you don't want to if you don't want to [ __ ] with all the SQL like god stuff, there's also um H1. It's very similar, I think.

[02:53:11]Chat being weird again. No, apparently SQL Lite is being weird again or always was weird.

[02:53:22]The founder of SQL Light and all current developers have pledged to follow the spirit of the rule to the best of their ability.

[02:53:32]Okay.

[02:53:37]awkward.

[02:53:40]I mean, if they're that's their thing, that's cool, I guess.

[02:53:58]42 is weird.

[02:54:03]Maybe maybe SQL SQL light is a cult also love fasting.

[02:54:33]Wait, what? Love fasting.

[02:54:41]There's something sus going on here.

[02:54:44]Definitely something sus.

[02:54:56]Hey, see a bit. What's up?

[02:55:01]Again, we don't want to install any database on machine.

[02:55:09]It's a little um it's there's just a few things in here that are kind of sus.

[02:56:03]Oh, I like this comment from Hacker News. I'm not religious, but I've always liked this. It's fun to think of the SQL SQL light developers as a small monastery. If monasteries can produce beer for the world, why not software?

[02:56:25]do not love much talking.

[02:56:28]Talking good.

[02:56:38]Yeah, we we we need some island [ __ ] going here probably.

[02:56:47]Yeah, I don't Yeah, frig. I feel like I've got to like think about the game a bit more, then start like creating a list of things that need to be done and then figure out which order those some of those things need to happen in.

[02:57:02]Probably likely if that makes sense.

[02:57:22]slashplan for plan.md first island [ __ ] is a real punchy name I thought about calling it highland that's kind of dumb that's kind of a dumb name Island. Highland.

[02:57:55]Guess where you're going to end up.

[02:58:00]What other IDM IDE would I recommend?

[02:58:05]Uh, I don't know. I like some of the Jet Brains IDEs. I mean, they're really all the same IDE except for fleet. Um, but like yeah, I used to use Goland a lot for Go Sea Lion for C and C++ streamer crossing. Guys, look. Look. It's night time in the game world now.

[02:58:34]Isn't that cool?

[02:58:36]Now the clock's gonna roll over because I need to fix the clock, but whatever.

[02:58:58]I could call it SQL Land.

[02:59:01]Amazing. Great name.

[02:59:12]light land. I think we're too fixated on the island part. It is an island. Like there are islands, but it's more of a survival thing. Stardew Islands. Like it's a what's it called?

[02:59:31]supposed to be a survival kind of adventure dealio co-op thing going on, you know, mini survival.

[03:00:03]What language is this? Closure. The secret of chimpanzeee island.

[03:00:10]Oh gosh. Uh.

[03:00:16]Oh wait. Yeah, we're not. There's no closure on screen. This is SQL.

[03:00:22]That's funny.

[03:00:36]Wait, that's kind of cool. That's kind of a cool name.

[03:00:40]Survive.

[03:00:42]Is this survival? It's survivalisle.

[03:00:53]Survival. Survive. But it's like isisle but survival.

[03:00:59]Oh, that's kind of cool.

[03:01:08]I'll credit the YouTube streamer, the YouTube viewer ID with the strategic inspiration on that. No, survival is a horrible name.

[03:01:23]We have cats on the island. I don't No, I haven't decided yet. I don't know, you guys. I haven't decided. Okay.

[03:01:57]Survile. Survi survival.

[03:02:01]Survival. Survival. It's pronounced survival, but it's spelled survival.

[03:02:11]Come on. It's cool.

[03:02:20]Make setup and tear down SQL for your tables. Um, yes.

[03:02:27]Ice coating cat.

[03:02:30]Ice coding kitty cat.

[03:02:46]Meow land. Meow mountain.

[03:02:49]We're going to climb a me.

[03:02:56]How do I die in the game?

[03:03:01]Good question.

[03:03:02]I also haven't thought about that either. I must think more. I must write down things and think more.

[03:03:21]This is on screen. There's SQL.

[03:03:31]Maybe you die of boredom. Wow.

[03:03:34]Ouch.

[03:03:41]All right. Well, I'm gonna I'm gonna go.

[03:03:45]It's about that time. And yeah.

[03:03:50]Should we raid somebody on Twitch?

[03:04:02]Die in the game if you die in real life.

[03:04:04]Yes.

[03:04:21]Freya Homeler. Who's that?

[03:04:49]Yeah. Okay. Whatever.

[03:05:01]Looks like she's having a good day. And uh yeah, cool. Well, I'll have to put some more thought into this game stuff.

[03:05:08]So, but yeah. All right. I will see you guys probably tomorrow.

[03:05:17]Bye.

[03:05:29]Bye, Janet. Love you.

[03:05:31]Adios, amigos.