Bookmarks

FixtureBot gives you the speed of fixtures with the syntax of factories

The speed of fixtures with the syntactic sugar of factories. - rubymonolith/fixturebot

A contributor trust management system based on explicit vouches to participate. - mitchellh/vouch

That fluffy developer

Node.js web handler / middleware for processing GitHub Webhooks - rvagg/github-webhook-handler

Stop babysitting your CI/CD pipeline with a workflow that automatically retries network failures.

The fastest "npm run" possible. Contribute to dawsbot/nr development by creating an account on GitHub.

Recently, I landed a change that moves the Single Executable Application (SEA) build process directly into Node.js core - a hobby project I’d been tinkering with for some time. It took some effort to

Explore different types of leaks and how to detect them in modern Go versions.

I made my next game twice as fast by forking go's crypto library

At The Guardian, like many engineering teams, we rely heavily on CI/CD pipelines to keep our software fresh, secure, and reliable for our users. Our workflows hinge on GitHub Actions, so when things go wrong or get expensive, the impacts are felt quickly. This is the story of why we moved away from GitHub-hosted runners to using our own self-hosted runners, what the process involved, and what we’ve learned along the way.

Advanced seed data handling for Rails, combining the best practices of several methods together. - willnet/seed-do

Text classification for Ruby made simple. Bayesian classification and semantic analysis with one gem.

A general classifier module to allow Bayesian and LSI classifications. - cardmagic/classifier

 For a long time, I kept putting off posting Rails UI to Hacker News. I checke...

An inside look at how OpenAI scaled PostgreSQL to millions of queries per second using replicas, caching, rate limiting, and workload isolation.

The DBA’s Guide to Music Matching - pg_trgm and pgvector with 100K Spotify Albums - The Problem: Dirty Input vs...

How PostgreSQL actually manages memory, from shared_buffers and dirty pages to the OS page cache sitting underneath it all.

In this tutorial, you will learn about PostgreSQL 18 Temporal Constraints, which allow you to enforce time-based data integrity using the WITHOUT OVERLAPS clause for primary keys and unique constraints, plus the PERIOD clause for foreign keys.

Who’s this for Basics How data is stored in disk How indexes speedup access to data Costs associated with indexes Disk Space Write operations Query planner Memory usage Types of Indexes Btree Hash BRIN GIN GiST & SP-GiST Conclusion Who’s this for This text is for developers that have an intuitive knowledge of what database indexes are, but don’t necessarily know how they work internaly, what are the tradeoffs associated with indexes, what are the types of indexes provided by postgres and how you can use some of its more advanced options to make them more optimized for your use case.

I am not intentionally trying to upset anyone with this blog post or minimize the efforts of many brilliant people whom I admire. However, ...

Learn how to use PostgreSQL as a Dead Letter Queue (DLQ) for event-driven systems. Case study from Wayfair showing how to handle failures in Kafka consumers.

RegreSQL catches query regressions before production. Compare query outputs against baselines, track EXPLAIN plan costs, and test migrations with confidence.

Regression Testing your SQL queries

Free & OSS PostgreSQL RDS / DBaaS, Self-Host PG like a Pro - pgsty/pigsty

DGate is fast and easy-to-use database client and SQL editor for MySQL, PostgreSQL, SQL Server, MongoDB and more. For desktop and web, it's open-source.

In my last post, I wrote about technical deflation. We’re seeing the cost of code is dropping so fast that we need to change our tech debt payment plans. The smart teams…