Bookmarks

Bookmarks

46753 bookmarks
Custom sorting
Mastering Postgres Replication Slots: Preventing WAL Bloat and Other Production Issues
Mastering Postgres Replication Slots: Preventing WAL Bloat and Other Production Issues
Over the last couple of years, I’ve helped dozens of users and organizations to build Change Data Capture (CDC) pipelines for their Postgres databases. A key concern in that process is setting up and managing replication slots, which are Postgres' mechanism for making sure that any segments of the write-ahead log (WAL) of the database are kept around until they have been processed by registered replication consumers. When not being careful, a replication slot may cause unduly large amounts of WAL segments to be retained by the database. This post describes best practices helping to prevent this and other issues, discussing aspects like heartbeats, replication slot failover, monitoring, the management of Postgres publications, and more. While this is primarily based on my experience of using replication slots via Debezium’s Postgres connector, the principles are generally applicable and are worth considering also when using other CDC tools for Postgres based on logical replication.
·morling.dev·
Mastering Postgres Replication Slots: Preventing WAL Bloat and Other Production Issues
So why don't we pick the optimal query plan?
So why don't we pick the optimal query plan?
A follow up to my blog post exploring how often we pick the optimal query plan. Instructions how to reproduce it, why it happens and how to address it.
·vondra.me·
So why don't we pick the optimal query plan?
Developing a terminal UI in Go with Bubble Tea
Developing a terminal UI in Go with Bubble Tea
Developing CLIs and TUIs in Go is fun, and there are really good packages out there to make it so. And when it comes to terminal apps, there is an amazing library called Bubble Tea to build beautiful
·packagemain.tech·
Developing a terminal UI in Go with Bubble Tea
xnx3/translate: AI i18n, Two lines of js realize automatic html translation. No need to change the page, no language configuration file, no API key, SEO friendly!
xnx3/translate: AI i18n, Two lines of js realize automatic html translation. No need to change the page, no language configuration file, no API key, SEO friendly!
AI i18n, Two lines of js realize automatic html translation. No need to change the page, no language configuration file, no API key, SEO friendly! - xnx3/translate
·github.com·
xnx3/translate: AI i18n, Two lines of js realize automatic html translation. No need to change the page, no language configuration file, no API key, SEO friendly!
GitHub Copilot NESの内部実装が公開、そして続・AIエディタ戦争
GitHub Copilot NESの内部実装が公開、そして続・AIエディタ戦争
Copilot NESとは Copilot NES(Next Edit Suggestions)は2025年2月にリリースされたGitHub Copilotの内部機能です。コードの変更に連動して必要となる次の編集を予測し、タブキーを押しているだけで複数箇所にわたる修正を提案してくれます。通常のコード補完がカーソル位置の続きのコードを予測するのに対して、Copilot NESは「エディタ上の編集操作」の単位で続きを予測して補完します。 GitHub Next | Copilot Next Edit SuggestionsGitHub Next Project: Can we improve Copilot code completion by suggesting the next logical change, wherever it is in your project?GitHub Next この仕組みはCopilot NESの元ネタであるCursor Tab(Copilot++)によって実用化されましたが、Cursorはプロプライエタリなソフトウェアなので内部の詳細が分かり
·blog.lai.so·
GitHub Copilot NESの内部実装が公開、そして続・AIエディタ戦争
Passkeys for Normal People
Passkeys for Normal People
Let me start by very simply explaining the problem we're trying to solve with passkeys. Imagine you're logging on to a website like this: And, because you want to protect your account from being logged into by someone else who may obtain your username and password, you've turned on two-factor
·troyhunt.com·
Passkeys for Normal People
seuros/breaker_machines: Modern circuit breaker for Ruby & Rails. Thread-safe, fiber-ready async support. Built-in fallbacks, rich introspection, clean DSL. Memory-efficient with jitter & monitoring.
seuros/breaker_machines: Modern circuit breaker for Ruby & Rails. Thread-safe, fiber-ready async support. Built-in fallbacks, rich introspection, clean DSL. Memory-efficient with jitter & monitoring.
Modern circuit breaker for Ruby & Rails. Thread-safe, fiber-ready async support. Built-in fallbacks, rich introspection, clean DSL. Memory-efficient with jitter & monitoring. - seuros/break...
·github.com·
seuros/breaker_machines: Modern circuit breaker for Ruby & Rails. Thread-safe, fiber-ready async support. Built-in fallbacks, rich introspection, clean DSL. Memory-efficient with jitter & monitoring.
Caching is an Abstraction, not an Optimization
Caching is an Abstraction, not an Optimization
I've always been told that caching is a tool to make software faster. That, given some careful considerations to consistency, caching makes it so that when...
·buttondown.com·
Caching is an Abstraction, not an Optimization
Pennybase: a Pound-Shop BaaS
Pennybase: a Pound-Shop BaaS
Building yet another single-file backend as a service. As always, we focus on simplicity, but nevertheless we try to implement as many features as we can without making it too complex.
·zserge.com·
Pennybase: a Pound-Shop BaaS