Choosing Redis Persistence: RDB vs. AOF for Durability and Recovery
A technical guide for choosing between Redis RDB snapshots and AOF logging, comparing durability, recovery speed, and performance impact for engineering decisions.
Loading…
ReadMeFeed / Community knowledge
#database-design
Real questions. Useful conversations. Find the people who know your stack.
redisEvaluating Data Infrastructure: When to Move Beyond Traditional Databases
Stop paying the 'infrastructure tax.' Learn how to decide between traditional RDBMS and modern data spaces to reduce backend boilerplate and operational overhead.
PostgreSQL Partial Indexes: Reduce Index Size and Speed Up Writes for Skewed Data
PostgreSQL partial indexes index only rows matching a WHERE predicate, shrinking index size and cutting write overhead for skewed data. Covers syntax, planner rules, unique soft-delete constraints, monitoring, and pitfalls.
Firebird Selectable Stored Procedures: When a Parameterized View Beats a Plain Query
Firebird selectable stored procedures act like parameterized views: encapsulate report logic, grant curated access, but watch the optimizer black-box trade-off.
firebirdMongoDB TTL Indexes: Let the Database Delete Your Expired Data (With Caveats)
MongoDB TTL indexes delete expired documents for you — no cron job required. Here's how they work, a working configuration, and the operational caveats that matter before you rely on them.
mongodbBuilding Bidirectional Project Tracking in Notion with Relations and Rollups
Create a relational Notion system where tasks automatically roll up into project progress metrics using Relations, Rollups, and Formulas — no external tools needed.
Decoupling Validation from Persistence with Ecto Changesets
Stop using fat models for validation. Learn how Ecto Changesets decouple data transformation from persistence to prevent mass-assignment vulnerabilities and handle race conditions.
ectoClickHouse ORDER BY Is a Storage Decision, Not a Query Clause
In ClickHouse MergeTree tables, ORDER BY is the physical sort order of your data, not a query clause. Here's how the sorting key drives sparse-index pruning, with a worked multi-tenant example.
clickhouseManaging Many-to-Many Relationships with Rails has_many :through
Learn how to implement has_many :through in Ruby on Rails to manage complex many-to-many relationships that require metadata, validations, and eager loading.
rails