News
Go's sql. Null[T] Will Never Get JSON Support. Here's What We Built Instead.
6+ hour, 42+ min ago (271+ words) Go 1. 22 gave us sql. Null[T] " a generic nullable type for SQL. Problem solved? No. Try marshaling it to JSON: That's not "Alice". That's not null. That's a broken API response. This is a permanent gap in Go's standard library....
"Four Remote Job Boards Have Free Public APIs. Here Is One Schema for All of Them"
7+ hour, 33+ min ago (291+ words) Remote OK returns its whole current board as one JSON array: The first element is a legal notice, not a job: they ask for a link back with attribution as a condition of using the feed. Skip element zero, and…...
The New HTTP QUERY Method Explained: A Better Way to Build Search APIs
3+ hour, 12+ min ago (112+ words) Learn why the new HTTP `QUERY` method exists, how it differs from GET and POST, and when you should use it in your REST "...
The Postgre SQL Guide to Partial Indexes on Soft Deletes
3+ hour, 20+ min ago (34+ words) If every hot query ignores deleted rows, stop paying to index them. Soft deletes feel cheap right up until your busiest query starts with WHERE "...
Database Indexing and Query Optimization for Python Developers
10+ hour, 25+ min ago (611+ words) Fixing N+1 queries with select_related/prefetch_related or selectinload (see the previous post) gets you down to a small, sane number of queries per request. The next bottleneck is what each query costs once the table has millions of rows " and that is…...
Testing Best Practices in Python
10+ hour, 25+ min ago (496+ words) Python's testing tools are lightweight enough that it's easy to write a lot of tests without writing good ones. A suite that mocks every collaborator, duplicates the same assertion ten times with different inputs pasted in by hand, or chases…...
Testing Best Practices in Java
10+ hour, 25+ min ago (576+ words) Most Java codebases have plenty of tests and still get burned by production bugs. The problem is rarely quantity " it's that the tests exercise the wrong things: they assert internal wiring instead of behavior, they mock away every collaborator until…...
Designing for Change: Boundaries, Contracts, and Dependency Inversion in Python
10+ hour, 25+ min ago (846+ words) Python's flexibility makes it easy to wire everything together directly " call the requests library from inside your business logic, import the ORM model straight into your pricing rules, instantiate a third-party SDK client wherever it's needed. It works, right up…...
Database Indexing and Query Optimization for Java Developers
10+ hour, 25+ min ago (668+ words) Fixing N+1 queries (see the previous post) gets your Hibernate app down to a handful of queries per request. The next bottleneck is what each of those queries costs once your tables have millions of rows " and that is almost…...
How to turn any web page into a PDF with one curl call
10+ hour, 48+ min ago (150+ words) I needed PDF copies of invoice pages for bookkeeping. The usual answer is Puppeteer, which means installing Chromium on your server, keeping it patched, and giving it a few hundred MB of RAM. On a small VPS that hurts. So…...