After stumbling on a pair of interesting blog posts — You Don’t Need Kafka, Just Use Postgres (Considered Harmful) — somewhat in the style of good old “flame wars” (which are increasingly rare these days) in the recent Postgres Weekly, as a response to a previous article — Kafka is...
PostgreSQL 18 introduced a powerful new feature that lets you enforce uniqueness across time periods: Temporal Constraints. With this addition, you can now define UNIQUE, PRIMARY KEY, or FOREIGN KEY constraints by either Date Range or Timestamp Range fields, making it easier than ever to prevent overlapping data.
Did you know? Tables in PostgreSQL are limited to 1,600 columns
It's a hard-coded limit in Postgres for tables to not exceed 1,600 columns. Let's test all the ways you can reach that limit, and explore how to address the situation when you reach this limit unexpectedly.
What do the new Index Searches lines in EXPLAIN mean? - pgMustard
In Postgres 18 you’ll now see “Index Searches” lines in EXPLAIN ANALYZE output. If like me you were wondering what those mean exactly, you’re in the right place.
PostgreSQL 13 Is Reaching End of Life. The Time to Upgrade is Now!
PostgreSQL 13 is reaching end of life on November 13, 2025. Treat your upgrade not as maintenance, but rather as an investment in security, stability, and innovation.
Learn how to build an inline editing feature using custom elements in Rails. A clean, framework-agnostic approach to editable content with just HTML and JavaScript.
Unlocking the full power of Copilot code review: Master your instructions files
Ready to make your code reviews smarter and easier? Learn how to structure your instructions files for better results, avoid common pitfalls, and see real-world examples to get started. 🚀
Build Rails applications that scale. Discover the small changes that make a big difference in efficiency. Design applications for performance from the start.
The Embulk project is going into the maintenance mode. Please do not expect that Embulk will be maintained actively. Even if you submit a pull request to the Embulk project, it may not be reviewed nor merged.