Dylan Paulus' Blog

Blame Management for Layoffs

Deploying Your Own GitHub Actions Runners on AWS

How to Use PostgreSQL for Data Normalization

Resizing AWS Mac Volumes

Recursive Query in SQL: What It Is, and How to Write One

Understanding SQL Aggregate Functions

Understanding Foreign Keys in PostgreSQL

Explaining PostgreSQL EXPLAIN

PostgreSQL Security Guide

How to Use a Common Table Expression (CTE) in SQL

Understanding PostgreSQL Tablespaces

How to Design Your PostgreSQL Database: Two Schema Examples

Creating a Fast Time-Series Graph With Postgres Materialized Views

Easily Generate Mock Data with PostgreSQL

Wrangling Table Bloat in Large PostgreSQL Tables

How to Reduce Your PostgreSQL Database Size

Unraveling Graph Structures: Exploring Adjacency Matrices

Improve Your Prompts for LLMs: Simple and Effective Techniques

Faster and Easier Python Debugging with breakpoint() and PDB

Postgres: The Graph Database You Didn't Know You Had

Git Worktree: Enhance your Git Workflow

Advice for New Software Engineers

NPM: What are project dependencies?

CSS Box Model

Start With No

Making React Fast: Tips on Optimizing ReactJS

Music That Defined My Decade: 2010-2019

Lost Connections: Why You’re Depressed and How to Find Hope

How Facebook Avoids Ad Blockers

On Writing Clean Code

Leveling Up Your Terminal/Command-Line Navigation

Intro to Functional Programming

Introducing React-Scroll-To v2

React: Controlling Rendering with Keys

Tips on Improving FabricJS Speed

React: Not Everything is State

Write Software that Evolves

Part Two: Using Typescript with Redux

Generic Type Arguments in JSX Elements

Part One: Using Typescript with React

Reusable Components: Factory Components

Global Component Registration

Encapsulating State with Functional Children

Tips on Creating Reusable Components

Introduction to Higher Order Components

Injecting Dynamic Elements to Components

Intro to FlightJS