dukepiki

3 ms·

1.
by dukepiki 11d ago
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.
2.
by dukepiki 11d ago
The folks at Springbird are giving it a shot: https://github.com/TeamSpringbird/stannum
3.
by dukepiki 14d ago
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
4.
by dukepiki 3mo ago
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, espec
5.
by dukepiki 3mo ago
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-
6.
by dukepiki 5mo ago
Last release was two weeks ago. pgrx is actively maintained.
7.
by dukepiki 5mo ago
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.
8.
by dukepiki 6mo ago
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,
9.
by dukepiki 6mo ago
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.
10.
by dukepiki 6mo ago
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.
11.
by dukepiki 10mo ago
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 you