Let’s say you’re running a web service where users can add other users as friends. How do you store each user’s friends list in the database? The simplest solution would be to use one large table called “friends” with each row being an entry on one user’s friends list. How well does that perform if you scale up to millions of users? Are indexes applicable to speed things up here? Is there a better way to represent this data in the database?
...
I’ve been using vim (specifically neovim) for over a year, I really enjoy how customizable it is, though up until today, I’ve only customized it through plugins made by other people. Today I wrote two Lua functions to streamline my workflow. I’m not very familiar with Lua but it was quite easy to pick up.
First is a function to split my window so it would have two side by side, and a smaller one at the bottom, which gets turned into a terminal.
...
When I first created my website just over two years ago, I spent a lot of time fretting over what exactly to put on it. The common answer of “anything you want!” wasn’t helpful because I didn’t actually know what I wanted.
Spending time browsing others’ personal sites and chatting with their webmasters gave me inspiration for new pages to build and new topics to blog about. After two years, I am learning what I want to put on my website. I enjoy blogging and sharing the things that I know and the things that I like. As a result, I’ve published more blog posts, created my links page, my /now page, and just yesterday, published a bunch of notes I’ve taken as I learn more about computers and web development. Coming soon will be a page to share music I’ve discovered recently.
...
Though I didn’t have any big plans this weekend, I kept myself busy around the house. I mailed some packages, did the grocery shopping, prepared some meals for the week, rearranged my kitchen, cleared out some expired food, and cleaned up my desk. It feels very good to be this productive.
I’ve been keeping up with X-Men 97 weekly, it’s such a good show. I love that it has a pretty serious plot but also keeps some of that Saturday morning cartoon charm. The weekly release schedule is so nice, I love spending the week leading up to the next episode hypothesizing with my partner about what will happen next. It’s also gotten me into the X-Men more in general, I’ve been watching the original 90s cartoon in between episodes, and I think I’ll pick up some comics as well!
...
I’ve been looking at gigs on Upwork to try and bring in some extra cash and bolster my experience. Some of these jobs seem braindead easy but I’m still so afraid to apply for them. Logically, I know that if something goes wrong nothing bad really happens, but the fact that something could go wrong terrifies me. I guess I just don’t want to disappoint people. My browser currently has a half-filled out proposal for a job. It would take me a couple hours to complete. I just need to submit it.
...
I love video games. Or, at least, I think I do. I don’t finish very many of them. I either play them for a few hours and forget to come back or I hyperfocus and get like 75% through the story but lose interest before getting to the end. This summer, I’d like to make progress on my backlog of unplayed games. I’ll start with Baldur’s Gate 3 and Cyberpunk 2077. These both fall into the 75% category and I last played them recently enough that I won’t be completely lost with what’s going on in the story. After that I’ll dig into some indie games, stuff like Hades, Hyper Light Drifter, Hotline Miami 1 + 2, because they are shorter to complete and do a lot of interesting things. Then I get back into AAA games and beat one beginning to end, just to prove to myself that I can. I’m thinking one of Persona 5 Royal, Spider-Man, Ghost of Tsushima or Final Fantasy VII Remake. A challenge I face with this goal is that a lot of first-person and third-person games trigger my motion sickness, so I can only really play for an hour at a time until a build up a tolerance to them (which I lose if I don’t play for a few days). Usually I stick to top-down games like strategy and simulation games to get around this, but I really want to play these games, so I will try my best to persevere.
...
I’ve started doing intermittent fasting to help achieve my fitness goals. It’s only been a week so far but I’m liking how it’s making me be more intentional about my eating habits. My eating hours are from 11am to 7pm, so I basically get two full meals and some snacks. I thought the hard part would be waiting until 11am to eat, but it’s actually pretty easy (probably all the coffee helping there), then when I do eat breakfast I can put more thought into it than when I’m half awake. What is actually hard is not being able to eat after 7pm. I eat dinner around 6 but by 9:30 or so I’m starting to get hungry again. Maybe the solution to this is just going to bed earlier. I imagine it will get easier as my body gets used to the new schedule and I figure out exactly how much I need to eat in those 8 hours.
...