Intro to Data Modeling Deep Dive Workshop
00:00 Hello! We're going to be doing some database stuff. We're finally getting off of our in-memory database thing and we're going to be doing real database things. So let's take a look at the finished version of all this stuff. We've got a user search page. We can look for different users. We can dive into those users and those users now have images and
00:19 it's awesome. And those images can be edited and everything is sweet. We can change this. We can add a koala cuddle and all of that is the same, but this time it's actually going into a real database. So that rocks! So I'm excited about this. I think you're going to
00:38 have a really good time. Oh, and look, that user is now on top because we're sorting by the most recently updated user, the user that was most recent, had most recently updated their note. And so like that requires a fair bit of interesting SQL that we're going to be writing. So yeah, a couple of things. We're going to be creating a database schema
00:56 and managing relationships. So we got one-to-one and one-to-many and there's the many-to-many relationship we'll explore a little bit. And then we're going to talk about migrations and how to do zero downtime deploys and migrations. So that'll be pretty sweet. We're going to talk about seeding data and generating that seed data, which is exactly what we've got
01:15 right here. I did not hard code these usernames and these user avatars and stuff. And then we're going to talk about querying and updating data and then even writing raw SQL. This search is powered by raw SQL. And then we're going to optimize our models for query performance.
01:33 And it's, yeah, it's pretty sick. It's amazing how just a couple of lines can make things way, way faster. So this page right here, before we do this optimization can take like a whole second to actually load. And now you notice it's loading very fast. Thanks to a
01:49 single line code change, which is amazing. And consultants get paid an outrageous amount of money to simply do and have the knowledge that I am going to teach you in this workshop. So it's going to be awesome. I think you're going to love it. Have a good time in the
02:08 data modeling deep dive workshop.