Dog with Sunglasses

About
Projects

Backend

All things related to web frameworks, APIs, databases, and server infastructure

Resources

MySQL Visual Explain

Visual EXPLAIN for MySQL Research a slow query's performance problems on a simple visualization instead of trying to understand MySQL's cryptic output.

Act - Run Github Actions Locally

Run your Github actions locally without having to struggle through the commit, push, go to Github loop.

Marmot

A distributed SQLite replicator built on NATS

Upstash

Serveless data platform services for Redis, Kafka, and QStash

Docker Rollout

Zero downtime deployments with a simple command to replace in your deployment scripts

Relational Databases Explained

How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.

Triplit

A realtime database that syncs between the server and browser automatically

EdgeDB

An open-source database designed as a spiritual successor to SQL and the relational paradigm.

Backend Cheats

A repo full of cheatsheets for backend development

Redis Explained

A deep technical dive into all things Redis. Covering various Redis topologies, data persistence and process forking.

Cache Control Cheatsheet

A quick and easy to understand guide on the various cache-control values

Remix the Web

A set of web utilities that lean on web standards

Bruno

A FOSS alternative to Postman and Insomnia for API client testing

Tina - The Markdown CMS

A fully open-source headless CMS that supports Git

Designing APIs for Humans

A four part guide on how to design APIs that prioritize the human writing software to consume the APIs

How to Learn SQL

Several resources and guides on how to learn and practice SQL

Queueing - An Interactive Guide

See visual and interactive examples that explain the how and why we need queues.

UX of UUIDs

Guide on how to make user and developer friendly unique IDs

Bunny.net

A next generation CDN and edge content platform

SST

Build modern full-stack applications on AWS

Arcjet

Security as code. Bot detection. Rate limiting. Email validation. Attack protection. Data redaction. A developer-first approach to security.

ElectricSQL

The standard sync layer for local-first apps. Build reactive, realtime, local-first apps directly on Postgres.

Encore

A development platform for building event-driven and distributed systems.

Trigger.dev

The open source Background Jobs framework for TypeScript

Use the Index Luke

A guide to database performance for developers

Systems Design at Scale

Learn how to design systems at scale

Github profile for David Witt Linked profile for David Witt Twitter profile for David Witt

© 2023 - 2024 David Witt

Home About Articles Library Projects Resources Notes Colophon Tags