yequari.com

I write code and occasionally blog posts.

Blog

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

Happy (Belated) JS Naked Day

Woah three blog posts in a week(ish) is unheard of

JS Naked Day🔗 happened this week, and as usual, I’m fashionably late. I decided to permanently remove a significant portion of the JavaScript from my site as it was affecting load times. There wasn’t a whole lot of JavaScript to begin with, which made this pretty easy to implement. What I did have was the following: 1. A script to randomly select from an array of quotes to display in the sidebar on each page load I just removed this as I just wasn’t finding it amusing anymore....

Dedicated Instant Messaging was Better

This didn't start out as a rant about Discord, but it sure ended that way.

fLaMEd’s post about instant messaging programs got me thinking about my own IM journey. I’m too young to really have experienced the peak AIM and MSN days, but I did use MSN/Windows Live Messenger in the late 00s to keep up with some online friends I had met through various forums. Eventually, I moved to Skype as that is what all my IRL friends were on at the time. I was also on Curse Voice for the brief time it existed, mostly for voice calls during League of Legends matches....

See Posts From

2022, 2023, 2024