dukepiki

If you mean the blog post is slop, you are 100% wrong. PlanetScale’s blog posts are all human written. I cowrote the TIN post with TIN’s main developer, and several of my very human colleagues reviewed it.

The folks at Springbird are giving it a shot: https://github.com/TeamSpringbird/stannum

BM25 is pretty similar everywhere: if a word in your query appears a lot in a document, the score for that document (for that one query) goes up, especially if that word isn't in very many other documents.

There are a couple of tuning parameters, and the notion of what a "word" is varies based on the tokenizer and stemming you use.

So it won't be exactly the same, but it's likely to be close.

We know about Resource Governor and wanted to bring something as good or better to Postgres. SQL Server classifies whole sessions into a budget. Traffic Control classifies individual queries instead. That's better granularity, especially when a pooler multiplexes multiple different workloads into a session. It also opens up more flexible classification, e.g., based on query plan or based on sqlcommenter tags carrying information about client apps, job queues, priority levels, or release versions.

Hi, I'm the lead engineer for Traffic Control. Glad to see it back in the news! If anyone's interested in more detail about how it works, check out https://planetscale.com/blog/behind-the-scenes-how-traffic-c..., or I'm happy to answer questions here.

Last release was two weeks ago. pgrx is actively maintained.

PlanetScale's internal extensions -- Insights, Traffic Control, and pg_strict -- are all built in pgrx.

Number of memory unsafety and race conditions I've had to debug in production in a year of use: zero.

pgrx is fantastic.

MySQL’s concurrency control is a limit on the total number of threads that can be active at once, across all queries.

Traffic Control limits concurrency and resource use according to configurable metadata like the username, remote address, or the contents of any sqlcommenter tags included in the query. So you can say things like “the batch processing role can’t run more than four queries at a time.” The finer granularity is key.

Hi, I'm the author of the post and the lead engineer on Traffic Control. Thanks for posting it here! Happy to answer questions anyone has.

Lead engineer from Traffic Control here. Read more at https://planetscale.com/blog/behind-the-scenes-how-traffic-c... about how it works, or I'm happy to answer any questions here.

There's definitely a light mode for planetscale.com (the docs, the blog, the changelog, and the UI). Should work on both desktop and mobile. Make sure your browser is requesting light mode. The browser doesn't always follow your OS-level preferences.