DevOps&SRE Library

PGKeeper: Building the bouncer we needed for Postgres

This is the story of why and how we built PGKeeper, a scalable and reliable service to support Figma’s rapidly growing products and database workload.

https://www.figma.com/blog/pgkeeper-building-the-bouncer-we-needed-for-postgres

deepsec

deepsec an agent-powered vulnerability scanner that you can run in your own infrastructure, optimized to perform on-demand review of all code in existing large-scale repos.

https://github.com/vercel-labs/deepsec

honker

honker is a SQLite extension + language bindings that add Postgres-style NOTIFY/LISTEN semantics to SQLite, with built-in durable pub/sub, task queue, and event streams, without client polling or a daemon/broker. Any language that can SELECT load_extension('honker') gets the same features.

https://github.com/russellromney/honker

How We Reduced Median Memory Estimation Error by 99%, With the Help of AI

When you're running a system that processes hundreds of thousands of compaction jobs, even small inaccuracies in memory usage estimates compound into real operational pain.

https://mixpanel.substack.com/p/how-we-reduced-median-memory-estimation

When upserts don't update but still write: Debugging Postgres performance at scale

At Datadog, we track the life cycle of millions of ephemeral hosts that report telemetry data to our platform. When a host stops emitting data, we eventually need to clean it up to avoid bloating our metadata store. To detect inactive hosts, the Datadog team that manages the host metadata store introduced a new upsert to track the last time a host was seen. We expected this new query to have minimal impact. Each host would be updated at most once a day, so even at 25,000 upserts per second, most queries should have been no-ops. But when we rolled out the new query, disk writes doubled and Write-Ahead Logging (WAL) syncs quadrupled. We discovered that even when an upsert doesn't change any values, it still locks the conflicting row, which is recorded in the WAL. Given that a Postgres cluster can only have a single writer, there's a hard limit to how many writes it can handle. The increase in disk writes introduced by the new query was consuming too much of this limited budget and had to be fixed. In this post, we'll walk through how we diagnosed the unexpected overhead by inspecting Postgres's WAL and how we rewrote the query to eliminate the cost without sacrificing correctness.

https://www.datadoghq.com/blog/engineering/debugging-postgres-performance

agent-vault

An open-source credential broker by Infisical that sits between your agents and the APIs they call. Agents should not possess credentials. Agent Vault eliminates credential exfiltration risk with brokered access.

https://github.com/Infisical/agent-vault

quarkdown

Quarkdown is a modern Markdown-based typesetting system designed for versatility. It allows a single project to compile seamlessly into a print-ready book, academic paper, knowledge base, or interactive presentation. All through an incredibly powerful Turing-complete extension of Markdown, ensuring your ideas flow automatically into paper.

https://github.com/iamgio/quarkdown

goshs

goshs is a single-binary file server built for the moments when you need more than Python's SimpleHTTPServer but don't want to configure Apache. HTTP/S, WebDAV, SFTP, SMB, LDAP/S, basic auth, share links, DNS/SMTP callbacks, NTLM hash capture + cracking — all from one command.

https://github.com/patrickhener/goshs

otelite

Lightweight OpenTelemetry receiver and dashboard for local development Otelite is a single-binary observability tool that receives OpenTelemetry data (logs, traces, metrics) and provides a web dashboard and terminal UI for viewing it. Designed for local LLM development with minimal resource usage (<100MB memory, <5% CPU), it starts in seconds and requires no external dependencies.

https://github.com/planetf1/otelite

otel-cardinality-processor

An OpenTelemetry Collector processor that catches metric cardinality explosions before they reach your TSDB.

https://github.com/YElayyat/otel-cardinality-processor

How we built a real-world evaluation platform for autonomous SRE agents at scale

Bits AI SRE is Datadog’s autonomous agent for investigating production incidents. It reasons across metrics, logs, traces, infrastructure metadata, network telemetry, monitor configuration, and more to determine, triage, and remediate the root cause of an issue.

https://www.datadoghq.com/blog/engineering/bits-ai-eval-platform

Реклама. Рекламодатель ООО «Авито Тех». erid: 2Vtzqx6K4Ns

Эх, захотелось… Но пока работаем с тем, что есть в SRE-реальности ↖️ Ребята с подкаста «В SREду на кухне» посвятили бюджету ошибок целый выпуск — вместе с Кириллом Борисовым, тимлидом из VK, они обсудили: 🔸 что такое Error budget и можно ли жить без него;  🔸 как объяснить бизнесу его необходимость; 🔸как его считать; 🔸 почему идеальная надёжность — это опасная иллюзия и миф; 🔸 как метрики помогают упростить расчёт. Смотрим и слушаем по ссылкам: 📱 YouTube 📱 VK 📱 Rutube #sre

sish

Open source SSH tunneling for HTTP(S), WS(S), TCP, aliases, and SNI. If you like the simplicity of serveo/ngrok-style sharing but want to use plain SSH and run your own infrastructure, sish is built for that.

https://github.com/antoniomika/sish

x509-certificate-exporter

A Prometheus exporter for certificates focusing on expiration monitoring, written in Go. Designed to monitor Kubernetes clusters from inside, it can also be used as a standalone exporter.

https://github.com/enix/x509-certificate-exporter

cpg

Cilium Policy Generator -- because writing CiliumNetworkPolicies by hand in a default-deny cluster is nobody's idea of a good Friday night.

https://github.com/SoulKyu/cpg

kloudlite

Kloudlite provides cloud-based development workspaces with live service connectivity. Think Telepresence meets cloud IDEs — but with per-developer environment ownership, instant environment switching, and cross-team collaboration built in.

https://github.com/kloudlite/kloudlite

aibrix

Cost-efficient and pluggable Infrastructure components for GenAI inference

https://github.com/vllm-project/aibrix

warden

The open-source egress gateway for AI agents — every API call is authenticated, authorized, and audited. No credentials ever reach the agent.

https://github.com/stephnangue/warden

ing-switch: Migrate from Ingress NGINX to Traefik or Gateway API in Minutes, Not Days https://blog.kubesimplify.com/ing-switch-migrate-from-ingress-nginx-to-traefik-or-gateway-api-in-minutes-not-days