yequari.com

I write code and occasionally blog posts.

WeblogPoMo2024

Thinking About Databases

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?...

Customizing Vim

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....

Building a Website is a Marathon, Not a Sprint

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....

Busy Weekend

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.

X-Men 97

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!...

Doing New Things Is Scary

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....

Clearing My Game Backlog

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....

Intermittent Fasting

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....