# queries (blogs) — RSS Amplifier

Recent posts from the 114 feeds in the RSS Amplifier directory that cover queries.

Page: <https://rssamplifier.com/topics/query/blogs>  
Feed: <https://rssamplifier.com/topics/query/blogs.md>

---

## ["My spine pressed into my throat." Please stop writing emotion this way.](https://parkerpeevyhouse.substack.com/p/describing-emotion)

_2026-08-22 · Parker Peevyhouse · The Writer's Attic_

Emotions shouldn't turn bodies into houses of horror

## [An animated FAQ accordion in pure HTML](https://markodenic.tech/an-animated-faq-accordion-in-pure-html/)

_2026-08-22 · Marko · Marko Denic Tech_

Delete every line of accordion JavaScript. Three lines of CSS replace it.

## [All Your GUCs in a Row: local\_preload\_libraries](https://thebuild.com/blog/all-your-gucs-in-a-row-local_preload_libraries/)

_2026-08-22 · the build_

Load shared libraries per-session from a single curated directory, no superuser needed.

## [The JasperFx / CritterStack AI and Event Modeling Strategy](https://jeremydmiller.com/2026/08/21/the-jasperfx-critterstack-ai-and-event-modeling-strategy/)

_2026-08-21 · jeremydmiller · The Shade Tree Developer_

Assuming you haven’t been living under a rock, you’ve probably noticed that topics related to Artificial Intelligence (AI) are pretty well dominating most conversations about software development right now. I’d like to lay out the Critter Stack community and JasperFx‘s strategy is for AI assisted software development at this moment and talk about all the … Continue reading The JasperFx /…

## [The AGPL: Radioactive by Design](https://thebuild.com/blog/the-agpl-radioactive-by-design/)

_2026-08-21 · the build_

Google maintains a public web page whose entire purpose is to tell Google engineers not to use one specific open source license. Not a general licensing policy (they have one of those too); a dedicated page, for one license, that opens with “MUST NOT” in capital letters and goes on to prohibit in…

## [✨The Modern Guide to Querying Literary Agents. Plus, Mapping Out Your Revisions✨](https://theshitaboutwriting.substack.com/p/an-excerpt-from-the-modern-guide)

_2026-08-21 · The Shit No One Tells You About Writing_

Also, we have three incredible author interviews this week!

## [✨Q&A with rising literary agent Tali Shammas!✨](https://carolinemadden.substack.com/p/q-and-a-with-rising-literary-agent-88b)

_2026-08-21 · Caroline Madden · Rising Tide Writers_

Plus: a special query link!

## [All Your GUCs in a Row: lock\_timeout](https://thebuild.com/blog/all-your-gucs-in-a-row-lock_timeout/)

_2026-08-21 · the build_

Prevent your migration from starving behind long-running queries.

## [Go 1.27's Runtime and Compiler: A Buffer Removed, Labels Added, Allocation Sped Up](https://ajitem.com/blog/go-1-27-runtime-and-compiler/)

_2026-08-21 · Ajitem Sahasrabuddhe | Lead Technology Consultant & Full-Stack Engineer_

go1.27rc1 removes the last escape hatch back to buffered timer channels, puts pprof labels in crash tracebacks by default, and speeds up small allocations by up to 39%. I benchmarked all three and ranked them by how badly each one can surprise you.

## [CritterWatch 1.0 is live!](https://jeremydmiller.com/2026/08/20/critterwatch-1-0-is-live/)

_2026-08-20 · jeremydmiller · The Shade Tree Developer_

CritterWatch 1.0 dropped yesterday, and you can read the official release on the JasperFx Software site. This blog post is just me being thankful for all the folks who helped build CritterWatch or test it along the way: And to Oskar Dudycz for all his contributions across the Critter Stack as much of CritterWatch are … Continue reading CritterWatch 1.0 is live! →

## [AI QA That Opens Fix PRs (Sponsored)](https://crawlproof.com/a/q5N7BmCdX1hK)

_2026-08-20 · **Sponsored**_

Runs browser QA, files issues with repro evidence, and opens fix PRs.

## [All Your GUCs in a Row: krb\_caseins\_users and krb\_server\_keyfile](https://thebuild.com/blog/all-your-gucs-in-a-row-krb_caseins_users-and-krb_server_keyfile/)

_2026-08-20 · the build_

PostgreSQL's GSSAPI authentication relies on two server-wide settings: \`krb\_server\_keyfile\` points to a dedicated keytab file (never share the system one), and…

## [What Actually Happens on \`git push\`](https://ajitem.com/blog/beneath-the-porcelain-part-2-what-actually-happens-on-git-push/)

_2026-08-20 · Ajitem Sahasrabuddhe | Lead Technology Consultant & Full-Stack Engineer_

Ref negotiation and packfile transfer, traced with \`GIT\_TRACE\_PACKET\`, and the CI failure modes they quietly explain: force-push races, corrupted refs, and "Everything up-to-date" surprises.

## [Local-only Voice Dictation](https://jaketrent.com/post/local-only-voice-dictation)

_2026-08-20 · Jake Trent · jaketrent.com_

Local-only Voice Dictation

## [CritterWatch 1.0 Live Stream Today](https://jeremydmiller.com/2026/08/19/critterwatch-1-0-live-stream-today/)

_2026-08-19 · jeremydmiller · The Shade Tree Developer_

We’re doing a live stream today on the CritterWatch 1.0 release — but it’s maybe a little dicy whether the official release happens before or after the live stream:-)

## [Query Club](https://parkerpeevyhouse.substack.com/p/query-club-12)

_2026-08-19 · Parker Peevyhouse · The Writer's Attic_

In which I critique your query letters

## [Agent Alert: 11 New Openings](https://agentalert.substack.com/p/agent-alert-11-new-openings-d87)

_2026-08-19 · Agent Alert_

Agents who have newly opened to queries (August 12 - 18)

## [A real chart in 15 lines of SVG, no library](https://markodenic.tech/a-real-chart-in-15-lines-of-svg-no-library/)

_2026-08-19 · Marko · Marko Denic Tech_

No chart library needed. Inline SVG plots your data in 15 lines, scales to any container, and styles with the same CSS as everything else.

## [All Your GUCs in a Row: join\_collapse\_limit](https://thebuild.com/blog/all-your-gucs-in-a-row-joincollapselimit/)

_2026-08-19 · the build_

PostgreSQL famously does not implement query hints. This is about 95% true, and join\_collapse\_limit is the other 5%: set it to 1, and the planner joins your tables in exactly the order you wrote them. This is not an exploit or an accident of implementation; it is documented, and according to Tom …

## [The go1.27 Goroutine Leak Profile: What Reachability Can and Cannot See](https://ajitem.com/blog/go-1-27-goroutine-leak-profile/)

_2026-08-19 · Ajitem Sahasrabuddhe | Lead Technology Consultant & Full-Stack Engineer_

go1.27 adds a goroutineleak profile to runtime/pprof that finds goroutines blocked on unreachable primitives. I built three fixtures: two it catches, and one identical leak it cannot see, because a package-level map still holds the channel.

## [CritterWatch RC.10 &#8212; the final one!](https://jeremydmiller.com/2026/08/18/critterwatch-rc-10-the-final-one/)

_2026-08-18 · jeremydmiller · The Shade Tree Developer_

CritterWatch will have its 1.0 release tomorrow (Wednesday, August 19th) just in time for a live stream on YouTube to show just the user interface part of CritterWatch. Today though, we finally got one last RC.10 release out for some much delayed feedback. We made a large amount of changes to optimize performance based on … Continue reading CritterWatch RC.10 — the final one! →

## [Trade Bitcoin & Ethereum (Sponsored)](https://crawlproof.com/a/qZ0u5pvex2dv)

_2026-08-18 · **Sponsored**_

Buy, sell and margin trade BTC & ETH with fiat currencies

## [SB 1000: Everyone Is a Covered Provider Now](https://thebuild.com/blog/sb-1000-everyone-is-a-covered-provider-now/)

_2026-08-18 · the build_

California SB 1000 is sitting on Assembly third reading right now, and the Legislature has until midnight on 31 August to pass it. It amends the California AI Transparency Act, which has only been operative since 2 August. If you ship model weights, or host anyone else’s, you should read it befor…

## [✨Query Critiques Inside! Plus, Writing for Today's Audience; Not Giving Up; & Meeting Your Dream Agent✨](https://theshitaboutwriting.substack.com/p/query-critiques-inside-plus-knowing)

_2026-08-18 · The Shit No One Tells You About Writing_

Also, what do birdhouses have to do with creative writing?

## [AI Overviews just launched in France, and they already appear on more than 52% of searches](https://seranking.com/blog/ai-overviews-france-study/)

_2026-08-18 · Yulia Deda · SE Ranking Blog_

Our analysis of 100,000 French searches found that AI Overviews appear on 1 in 2 queries, with YouTube and Facebook among the top cited sources.

## [All Your GUCs in a Row: jit\_debugging\_support, jit\_dump\_bitcode, and jit\_profiling\_support](https://thebuild.com/blog/all-your-gucs-in-a-row-jit_debugging_support-jit_dump_bitcode-and-jit_profiling_support/)

_2026-08-18 · the build_

Inspect the LLVM bitcode PostgreSQL generates with \`jit\_dump\_bitcode\`, or wire JIT-compiled functions into GDB and perf with \`jit\_debugging\_support\` and…

## [Sixteen Locks Ought to Be Enough for Anybody](https://thebuild.com/blog/sixteen-locks-ought-to-be-enough-for-anybody/)

_2026-08-17 · the build_

Every query locks every index on a table, even ones it doesn't use.

## [Deciphering Date Differences with DATEDIFF](https://connor-mcdonald.com/2026/08/17/deciphering-date-differences-with-datediff/)

_2026-08-17 · Connor McDonald · Learning is not a spectator sport_

(Try saying that 5 times quickly in a row) 🙂 There’s an old saying that’s gone around for years in IT circles which is “If you have a text parsing problem you can use a regular expression…now you have two problems“. I’d like to steal that phrase and manipulate it for the sake of today’s \[…\]

## [Kernel Modules](https://internals-for-interns.com/posts/linux-kernel-module-system/)

_2026-08-17 · Internals for Interns_

At the end of the previous article we handed a request to "the driver" and let it disappear into the hardware. That's been the pattern for a while now: the VFS hands off to a filesystem, the block layer hands off to a driver, the network stack hands off to a NIC driver. Every one of those handoffs ends at some code that wasn't in the kernel image when the machine booted.

## [All Your GUCs in a Row: jit\_above\_cost, jit\_inline\_above\_cost, and jit\_optimize\_above\_cost](https://thebuild.com/blog/all-your-gucs-in-a-row-jit_above_cost-jit_inline_above_cost-and-jit_optimize_above_cost/)

_2026-08-17 · the build_

PostgreSQL's JIT compiler fires based on estimated query cost, but that estimate measures data volume, not expression complexity.

## [Parallel Branches Without Stashing: \`git worktree\`](https://ajitem.com/blog/git-quick-hits-part-2-parallel-branches-without-stashing-git-worktree/)

_2026-08-17 · Ajitem Sahasrabuddhe | Lead Technology Consultant & Full-Stack Engineer_

Reviewing a PR while you're mid-feature usually means stash, checkout, review, checkout, stash pop, and hope nothing got left behind. git worktree checks out a second branch into its own folder instead.

## [Go 1.27 and encoding/json/v2: The Engine Changed, the Contract Didn't](https://ajitem.com/blog/go-1-27-json-v2/)

_2026-08-17 · Ajitem Sahasrabuddhe | Lead Technology Consultant & Full-Stack Engineer_

go1.27rc1 replaces the engine under encoding/json with encoding/json/v2 internals, and existing callers will not notice: the v1 shims restore every v1 semantic, including two the v2 docs call security relevant. What moved is performance, split by payload shape and direction, and what moved is opt-in, behind an explicit import.

## [Real SIMs for AI Agents (Sponsored)](https://crawlproof.com/a/QwHHF5rUd1By)

_2026-08-16 · **Sponsored**_

Pass 2FA and verifications with real carrier numbers via our API.

## [My HTML boilerplate in 2026](https://matuzo.at/blog/2026/html-boilerplate)

_2026-08-17 · Manuel Matuzović - Blog_

Every element I use for the basic structure of a HTML document, with explanations why. Five years ago, I shared the HTML boilerplate I use for most of my projects. Since then, a lot has happened in HTML. It's time to give it an update. My boilerplate This is the final document. Scroll down for details. \<!DOCTYPE html\> \<html lang="en" class="no-js"\> \<head\> \<meta charset="UTF-8"\> \<meta…

## [Nobody knocked](/posts/nobody-knocked/)

_2026-08-17 · Josh Brody_

Nobody knocked My history of cybercrime is typical: the usual shithead tour of carding, account takeover, game cheats, denial of service. All of it more than fifteen years removed. In early August I spoke at the 2026 National Cybercrime Prevention Forum in Sydney (the accents are wild). It was a room of law enforcement, government, industry, and academics, and I was there to give my opinion on…

## [All Your GUCs in a Row: jit\_expressions and jit\_tuple\_deforming](https://thebuild.com/blog/all-your-gucs-in-a-row-jit_expressions-and-jit_tuple_deforming/)

_2026-08-16 · the build_

PostgreSQL's JIT compiler has two jobs: compiling expressions and deforming tuples. Here's how to isolate JIT bugs with two simple boolean toggles.

## [The curious case of Google&#x27;s AlloyDB](https://boringsql.com/posts/google-alloydb/)

_2026-08-15 · Radim Marek · boringSQL | Supercharge your SQL & PostgreSQL powers_

Google launched AlloyDB in 2022. They claimed it is fully compatible with PostgreSQL. Can be up to 100 times faster for analytical queries than vanilla Postgres. Four years later, I haven&#x27;t personally seen it gain significant traction. But it comes in discussions. When people ask me what AlloyDB actually is, I was able to pin point the features, but wasn&#x27;t really sure what it delivers.…

## [How To Set Up A Great Payoff (Without Being Obvious)](https://parkerpeevyhouse.substack.com/p/how-to-set-up-a-great-payoff-without)

_2026-08-15 · Parker Peevyhouse · The Writer's Attic_

A subtle set-up leads to a more emotional payoff

## [A before/after image slider in 2 lines of JavaScript](https://markodenic.tech/a-before-after-image-slider-in-2-lines-of-javascript/)

_2026-08-15 · Marko · Marko Denic Tech_

The plugin you were about to install is just input\[type=range\]. Stack two images, clip one, done. Works with the keyboard too.

## [All Your GUCs in a Row: jit and jit\_provider](https://thebuild.com/blog/all-your-gucs-in-a-row-jit-and-jit_provider/)

_2026-08-15 · the build_

PostgreSQL's JIT compiler trades upfront compilation time for faster query execution—but it silently does nothing if the LLVM library isn't installed.

## [Generic Methods in Go 1.27: What Changed, What Didn't](https://ajitem.com/blog/go-1-27-generic-methods/)

_2026-08-15 · Ajitem Sahasrabuddhe | Lead Technology Consultant & Full-Stack Engineer_

For as long as Go has had generics, a method could only use the type parameter its receiver declared, so producing anything else meant a package-level function taking the receiver as its first argument. Go 1.27 changes that, but only partway…

## [✨Fight Club on the Podcast; & Defying the Algorithm. Plus, a Behind-the-Scenes Look at How an Agent and Author Work Together✨](https://theshitaboutwriting.substack.com/p/fight-club-on-the-podcast-and-defying)

_2026-08-14 · The Shit No One Tells You About Writing_

And how even difficult feedback can be a gift!

## [All Your GUCs in a Row: io\_method and io\_workers](https://thebuild.com/blog/all-your-gucs-in-a-row-io_method-and-io_workers/)

_2026-08-14 · the build_

Choose your I/O execution engine with \`io\_method\` and size the worker pool with \`io\_workers\`—and yes, you can resize workers without restarting.

## [Set Desktop Color Scheme with Pywal](https://jaketrent.com/post/set-desktop-color-scheme-pywal)

_2026-08-14 · Jake Trent · jaketrent.com_

Set Desktop Color Scheme with Pywal

## [✨9 Rising Literary Agents Actively Seeking Clients!✨](https://carolinemadden.substack.com/p/9-rising-literary-agents-actively)

_2026-08-13 · Caroline Madden · Rising Tide Writers_

Plus: an amazing competition for writers of YA/Children's Fiction

## [Using the Wolverine &#8220;Side Effect&#8221; Model to Simplify Code](https://jeremydmiller.com/2026/08/13/using-the-wolverine-side-effect-model-to-simplify-code/)

_2026-08-13 · jeremydmiller · The Shade Tree Developer_

First off, let me peel some egg off my face because I had allowed Claude to write quite a bit of code without close enough examination until just now. Arguably, we re all good because we do have test coverage for the code I just refactored, so it s all good in the end, but maybe just Continue reading Using the Wolverine Side Effect Model to Simplify Code

## [Understanding Prometheus queries and why they might not work](https://colinpaice.blog/2026/08/13/understanding-prometheus-queries-and-why-they-might-not-work/)

_2026-08-13 · Colin Paice · ColinPaice_

I had a query sum (rate(traces\_span\_metrics\_duration\_milliseconds\_bucket\[1m\]) ) by(le) / sum(rate(traces\_span\_metrics\_duration\_milliseconds\_count\[1m\]) ) and it returned no data. Why? I discuss how I debugged this problem in Debugging Prometheus queries The Prometheus documentation has a sections on queries and data. Prometheus calculations Data types There are different sorts of data in Prometheus…

## [Debugging Prometheus queries](https://colinpaice.blog/2026/08/13/debugging-prometheus-queries/)

_2026-08-13 · Colin Paice · ColinPaice_

I had a query sum (rate(traces\_span\_metrics\_duration\_milliseconds\_bucket\[1m\]) ) by(le) / sum(rate(traces\_span\_metrics\_duration\_milliseconds\_count\[1m\]) ) and it returned no data. Why? Ive explained the reason for this in Understanding Prometheus queries and why they might not work Getting started In Prometheus specify a query sum (rate(traces\_span\_metrics\_duration\_milliseconds\_bucket\[1m\]) ) by(le)…

## [&#8220;Where are my patches?!?!&#8221;](https://connor-mcdonald.com/2026/08/13/where-are-my-patches/)

_2026-08-13 · Connor McDonald · Learning is not a spectator sport_

Anyone that follows me on the socials knows that I m pretty keen on security. Whilst all those other day-to-day things like performance and uptime etc etc are all important, rest assured; people will generally forgive you for being down for a while; they will forgive you for being slow for a while, but they will \[ \]

## [All Your GUCs in a Row: io\_max\_concurrency](https://thebuild.com/blog/all-your-gucs-in-a-row-io_max_concurrency/)

_2026-08-13 · the build_

PostgreSQL 18's new io\_max\_concurrency caps per-process I/O operations in flight.

## [The Bare Repo Pipeline](https://ajitem.com/blog/beneath-the-porcelain-part-1-the-bare-repo-pipeline/)

_2026-08-13 · Ajitem Sahasrabuddhe | Lead Technology Consultant & Full-Stack Engineer_

A bare repository and a nine-line post-receive hook turn \`git push\` into a full deploy, with no CI platform, no webhook, and no build server in the loop.

## [Go 1.27: A Release Map, Ordered by What Can Break You](https://ajitem.com/blog/go-1-27-introduction/)

_2026-08-13 · Ajitem Sahasrabuddhe | Lead Technology Consultant & Full-Stack Engineer_

Seven posts, one companion repository, and a benchmark run against go1.27rc1. This one is the map: what each post covers, and an upgrade checklist ordered by how badly each change can surprise a running system, not by how large its number is.

## [Introducing Fisher: Sqlite Backed Document Db &#038; Event Store Critter](https://jeremydmiller.com/2026/08/12/introducing-fisher-sqlite-backed-document-db-event-store-critter/)

_2026-08-12 · jeremydmiller · The Shade Tree Developer_

I know, you were probably wandering around today and thinking to yourself, my life would be more complete if there was just a library out there that gave you the developer experience of the tried and true Marten library, but backed by Sqlite so you could just get things done on projects that don t really Continue reading Introducing Fisher: Sqlite Backed Document Db Event Store Critter

