The Post Archive
These are the posts I've written over the years, archived here for you and Google. I've decided to move away from blogging here, and moved my stuff over to my newsletter site, up on ConvertKit (love them).
Join over 15,000 programmers just like you and me
I have a problem when it comes to trying new things and learning about computer science stuff. I'm self-taught, so it's imperative I keep up with what's going on. I love sharing, so sign up and I'll send along what I've learned right to your inbox.
Video
- Test-driven Development In Action
- Meet Playwright
- A Functional Programming Primer, jUst FoR yOU
- Weird Brazil Date Bug with Jon Skeet
- Data Structures and Algorithms
- Fast and Simple Web Apps with Nitro
- Hello PostgreSQL
Software-design
Frontend
- 👻 Hacking Ghost for Fun and Profit
- 🤖 A Real World Approach to Playwright
- What Is Your Yeet Threshold?
- What Should Be a Plugin vs a Composable vs a Store in Vue?
- Trying Something Different: A Real World Tutorial for Frontend Programming
- Everyone Has a Plan, Until They Get Hit in the Face
- The First Draft of Anything Is Shit
- Five Things I Learned Building Bigmachine.io Using Nuxt and Firebase
- What's the Difference Between Vue 2.0 and Vue 3.0?
Career
- Surviving the Structured Interview
- Seven Simple Steps to Overcoming Imposter Syndrome
- Developing A Potent Voice
- Why Blogs Make Outstanding Books
- What's Your Exit Plan?
- WTF is Big O Notation?
- Imposter's Handbook, Season 2 is Released
- Mod and Remainder are not the Same
- Working Smarter, Not Harder, Part 1
- Calling Your Own Shots
- Dumb CS Problems And Your Next Job
- Yet Another Fork In The Road
Theory
- Explain It Like I'm 5 - Why Are Hashes Irreversible?
- The Fabulous Linked List
- Big O Notation
- What’s the Best Hashing Algorithm for Storing Passwords?
Updates
Postgres
- Using Constraints to Protect Calendar Data in PostgreSQL
- Handling Dates and Times Properly in Postgres
- Striking Gold in My Archives
- The Easiest Postgres Experience You've Ever Seen
- Creating a Full Text Search Engine in PostgreSQL, 2022
- Importing a CSV Into PostgreSQL Like a Pro
- PostgreSQL Tools for the Visually Inclined
- A Pure PostgreSQL Document Database API
- Interview On .NET Rocks About A Curious Moon
- My New Book About PostgreSQL, Data and Saturn: A Curious Moon
- My Writing Process (This Week)
- JSONB and PostgreSQL: Work Faster By Ditching Migrations
- PostgreSQL Document API Part 4: Complex Queries
- PostgreSQL Document API Part 3: Finding Things
- PostgreSQL Document API Part 2: Full Text Search and Bulk Save
- Designing a PostgreSQL Document API
- Membership In a Box with PG-Auth
- Document Storage Gymnastics with Postgres
- Embracing SQL In Postgres
- It's Time To Get Over That Stored Procedure Aversion You Have
- Inserting And Using A New Record In Postgres
- Using Custom Types in Postgres
- Pulling Documents From a Relational Query in Postgres
- A Better ID Generator For PostgreSQL
- Using Entity Framework 6 with PostgreSQL
- PostgreSQL Rising
- How To Backup Your Postgres DB To Amazon Nightly
Life
- The Importance of Knowing Your Numbers
- Fun Geeky Things To Do For the Holidays
- Losing Yourself
- Just Paddle
Opinion
- People Who Create Tutorials Need to Try Harder
- The Logical Disaster of Null
- The Modern Dev Team
- Hello Elixir. Wow.
- Staying Hungry, Staying Foolish
- Writing a Better Abstract
- Repositories On Top UnitOfWork Are Not a Good Idea
- Are You Really Doing BDD?
- JavaScript Frameworks Are Amazing and Nobody Is Happy
- Knowing More Programming Languages Will Make You Smarter
- Lost at Sea
- Leaving Your Mark
- Someone Save Us From REST
- Open ID Is A Nightmare
Azure
Writing
- Writing, Editing and Formatting a Technical Ebook in 2021
- The Imposter's Handbook, Print Edition Now Available
- Writing A Book Is Frustratingly Addictive
- Writing A Book: The Imposter's Handbook
News
Node
- Postgres For Those Who Can't Even, Part 3 - In The Real World
- Postgres For Those Who Can’t Even, Part 2 - Working with Node and JSON
- Bringing The Power of Postgres to NodeJS
- Your Own Private Heroku with DigitalOcean and Dokku
- Avoiding Messy Situations With KnockoutJS and JavaScript
- Try It Quiet
- NodeJS Callback Conventions and Your App
Database
- PostgreSQL For Those Who Can’t Even, Part 1
- Fine Tuning Full Text Search with PostgreSQL 12
- Virtual, Computed Columns in PostgreSQL 12
- Transactional Data Operations in PostgreSQL Using Common Table Expressions
- Simple Monthly Reports in PostgreSQL Using generate_series
- Setting Up a Fast, Comprehensive Search Routine With PostgreSQL
- Massive: 400 Lines of Data Access Happiness
Books
Travel
Firebase
- Hooking A Web Page To Firebase With VueJS
- Wiring Serverless Routines With Firebase
- Thinking In Events With Firebase
- Should I Trust Firebase? Of Course Not!
- Kicking The Tires On This Serverless Thing
Elixir
- Red4 Store Part 5: Fun With Phoenix, OTP, and Agents
- Learn Elixir The Fun Way
- Thinking About Function Signatures in Elixir
- How To Learn a New Programming Language While Maintaining Your Day Job
- Recursion, Not Recursion
- Using Recursion In Elixir To Break Your OO Brain
- Using Elixir's Pattern Matching And Case Statement To Handle Errors
Tekpub
Screencasts
- Screencasting Like a Pro: The Demos
- Screencasting Like a Pro: The Script
- Screencasting Like a Pro : Beginning, Middle, and End