Dylan Paulus' Blog

import Activity from "@components/Activity.astro" import Gallery from "@components/Gallery.astro"; import p1 from ".

Managing a database is more than just storing information—it's about storing data efficiently, effectively, and balancing trade-offs.

I recently ran into an issue with our Mac build machine in AWS, where the EC2 instance kept running out of disk space.

As developers, querying in PostgreSQL for hierarchical data is difficult.

You may have heard that "data is the new oil."

Foreign keys in PostgreSQL are a fundamental way of defining relationships between tables.

EXPLAIN is a command we prepend to queries to tell us what operations PostgreSQL plans to run for that query, how many rows each operation touches in the database(s), and how long those operations take.

Databases store an application's most valuable asset: data.

Common Table Expressions (CTEs) are my go-to tool when writing complex SQL queries.

Tablespaces are a PostgreSQL feature that gets easily overlooked but can provide substantial speed improvements and cost-saving potential.

How we design and lay out our tables is one of the most important decisions in developing effective and efficient PostgreSQL databases.

Imagine you have a massive amount of time-series data you want to explore and visualize.

import { Accordion } from "../../../..

I worked with Timescale again to write an article on how table bloat effects large tables, and how we can fix it.

I had the pleasure of working with Timescale to write an article on how to reduce your PostgreSQL database size.

import { Image } from "astro:assets"; import baseGraph from ".

import { Prompt } from ".

Debugging is an essential skill for any software developer.

PostgreSQL (Postgres), is a powerful relational database that can store a wide range of data types and data structures.

Have you ever found yourself in the middle of coding a feature, only to receive a notification that production is down?

A few months ago I had an opportunity to give a presentation to soon-to-be Computer Science (CS) graduates.

Code dependencies are like Lego's.

CSS is one of those technologies that has a low barrier to entry (good thing 🎉), but because of this sometimes how it works can seem like magic.

Our default response to any idea that comes up should be: “Interesting.

import { Image } from "astro:assets"; import htmlDiagramImage from ".

This is an attempt at a different kind of post.

You need your nausea.

Many sites try to avoid our ad blockers through limiting content or just straight out pleaing.

We can all agree that writing clean code is important.

One motivating factor in using a terminal is the productivity gains... that is, once you can sweep the keyboard like an 80's metal guitarist.

This post comes from an example I presented at Boise Code Camp 2019 comparing imperative and functional ways of solving problems.

The latest version of a React component I maintain just released, v2 of react-scroll-to.

key, the property we throw some value into to suppress warnings.

FabricJS is an awesome library that handles Canvas interactions and rendering.

When working with React we get introduced to state as a way if storing component's data.

In software development, we can easily get trapped in analysis paralysis.

Last time we went through using Typescript with React, and setup a small counter application.

Typescript recently released generic type arguments for JSX in their 2.9 release.

Finished Example: Click Here Learning Typescript with React can be challenging, and in my case, cursing Microsoft and throwing any on every variable.

Beware the mega component.

Introduction Often, I find myself looking through open-source projects to see how they solve issues.

import Alert from "../../../..

Introduction A huge selling point of React is its use of composable, reusable components.

Introduction Think of Higher Order Components (HOC) like Pacman.

Introduction Let's say we're working on an UI component library using React JS.

This post is part of the archive.