POV: you forgot to index to your query and now the whole team is laughing at you

Just had the perfect phone call with the president of Turkey. Absolutely tremendous

Find the nextjs program

Visiting friends in New York

If anyone ever blatantly steals my branding in the future I hope they at least make it fit in nicely like this restaurant

Can the code underlining approach used by IDEs be applied to show indexing problems directly on SQL text? @simp.engineer thinks so! See how his latest work magically surfaces scan type details from query execution on the relevant clauses in the query itself: app.querydoctor.com/ixr/share/w3...

What better first post than to announce a feature? How the DB handles the WHERE clause of a query is now shown directly in the diagrams! Easily see how the logic of SQL is translated into a plan the DB can use to find the results. Check it out an example here: app.querydoctor.com/ixr/share/QQ...

A visual guide to database query execution querydoctor.com built by @simp.engineer using @pglite.dev

To an asshole, all virtue is "virtue signaling."

The struggle is real.

Anyone else experiencing this bug with their Spotify wrapped? It instantly skips past every slide and goes to the last screen. A restart won't fix it either. I know I have the most cursed combination of top artists, don't even get me started... (seizure warning)

An unordered / non-exhaustive list of things that helped scale Bluesky's infra efficiently: + Exiting the cloud (colocation) + HAProxy w/many Node backends + Go w/clever code + ScyllaDB + SQLite w/per user databases + Redis w/many instances + AMD servers w/many cores + Purchasing bandwidth directly

Security pro tip: if you find a USB key on the ground somewhere, DO NOT plug it in to your home computer. Take it to the office and plug it in there. They have way better software that will mitigate any threats.