Building, just because…
Ah, crypto. A land of innovation, decentralized dreams, and—let’s be honest—some of the most impressive scams you’ll ever see. If you’ve been around long enough, you already know the playbook: hype, FOMO, cash out, disappear. And yet, people keep falling for it. Case in point: Hawk Tuah Coin. Yeah, that one. The meme-ified, blink-and-you-missed-it token … Read more
So, you’ve been building React apps, and things are fine—until they’re not. Maybe your SEO is struggling, your page loads are sluggish, or managing routing is becoming a headache. Enter Next.js, React’s smarter, more performance-driven sibling. If you’re on the fence about switching, let’s break Next.js vs React down a bit. 1. Server-Side Rendering (SSR) … Read more
Alright, so you’re building a React app, and now you need to style it. Easy, right? Well, sort of. With so many ways to handle CSS in React, it can feel like wandering into a buffet with too many options—overwhelming but exciting. Let’s break it down so you can pick the best approach without losing … Read more
Why You Need a Persistent Bottom Button Ever get annoyed when a crucial button scrolls away just when you need it? Same. Let’s learn how to lock your button in place. Whether it’s a “Next,” “Submit,” or “Continue” button, keeping it locked at the bottom makes for a way smoother user experience. This guide will … Read more
Tech is running the world right now—no debate there. And at the heart of it all are software companies. These giants don’t just make products; they create platforms and ecosystems that define how we work, communicate, and play. But have you ever stopped to ask: how exactly do these software companies make all that money? … Read more
Are you managing a BigQuery environment at scale and dealing with slow BigQuery job execution? Does your company have hundreds or thousands of jobs running simultaneously and sometimes experience wildly slow query execution? This happens. It’s growing pains. We’ll go over a couple of methods of bringing your query speeds back up which might eventually … Read more
In this blog post we’re going to cover how to make your SQL queries blazing fast. So, BigQuery is an incredible tool for wrangling massive datasets and running SQL queries at scale. But let’s be honest—just because it can handle huge queries doesn’t mean you should throw inefficiency at it. The faster your queries run, … Read more
This past weekend I decided to spin up a quick Airflow deployment for some personal scripts I wanted executed on a schedule. I didn’t have scale in mind and I didn’t have robustness in mind. I had speed. I’ll review how I’m deploying my version-controlled DAG code to my EC2. I want to highlight, this … Read more
Efficiently managing partitioned tables in Google BigQuery is crucial for performance and cost optimization. A common task is determining partition existence in BigQuery within a table. Instead of scanning entire tables, which can be time-consuming and expensive, BigQuery offers a more efficient approach using the INFORMATION_SCHEMA.PARTITIONS view. Using INFORMATION_SCHEMA to Check Partition Existence BigQuery’s INFORMATION_SCHEMA … Read more
Comms as a Data Engineer can be tough. Should you email a group of people? Should you dump a message in a public Slack channel they frequent? Should you follow up daily, weekly, etc? It’s a lot of manual labor. I don’t like manual work. Also, I hate email. This seems to be a common … Read more