Xetera

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

Oh is this the contrapoints drama everyone's been talking about

Well hold on a second...

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

Trump is frantically taking notes

My database is a machine that turns business logic constraints into runtime errors 💀 🏋️

data dog? observability really is the future

How does oxlint compare to alternatives like biome? Is it similar to Rome's original vision before all the investor shenanigans?

You're 94% German now congratulations

Find the nextjs program

yeah it's probably not a song you hear often if you never spend time around your children

Hat with the words “please do not talk to me about AI I will kill myself”

Visiting friends in New York

A storefront neon sign reading "Hot Ones" in the style of sean evans' show on youtube

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

An image of a SQL text which has filtering clauses decorated based on how, if at all, the database used the index when processing the query

An image showing the visualization of a query and the `Index Scan` stage used to execute it. The index is on the `game` column, so it gets a green underline. The `date` column is NOT indexed so the database must retrieve and process records in order to apply that condition. That earns the associated text in the WHERE clause a red squiggly underline

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...

Diagram showing how the index (game) handles a query filtering on the date column.

Diagram showing how the index (score, game) handles a query filtering on the date and score columns. Diagram showing how the index (score, game) handles a query filtering on the date and score columns.

Diagram showing how the database has to filter all WHERE clauses when no index is being used

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...

That's such a heartless response man. This is about parents realizing they can trust their kid to behave when their hands are tied. I'm sure children aren't struggling with literacy because they watch videos to pass the time while their parents are stuck in meetings

This is what I'm wondering too

We initially didn't even realize we were building a database to do these visualizations from scratch @querydoctor.com about a year ago until we ran into PGlite, and realized we could leverage Postgres instead! It's been a huge game changer.

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.

sadly their employer, the Grinch, doesn't care

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

As a Turk, if I don't call Ivory Coast "Cote D'Ivoire," I don't see why anyone else would want to call Turkey "Türkiye"

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.