rails-37-style-backend-database

What problem does it solve?

This Skill provides a set of best practices and patterns for structuring and interacting with databases in Rails applications, focusing on robustness, maintainability, and performance.

Core Features & Use Cases

• UUIDs as Primary Keys: Enhances security and distribution by using UUIDs instead of sequential integers.
• State as Records: Manages application state through dedicated database records rather than boolean flags, providing richer history and attribution.
• Database-Backed Infrastructure: Leverages the database for jobs, caching, and WebSockets (Solid Queue, Solid Cache, Solid Cable) to reduce external dependencies.
• Account ID Scoping: Implements multi-tenancy by consistently using account_id for data isolation.
• Hard Deletes: Employs direct record deletion for simpler queries, relying on audit logs for history.
• Counter Caches: Denormalizes counts to optimize read performance.
• Index Strategy: Outlines best practices for indexing foreign keys, query filters, and common query patterns.
• Sharded Search: Describes a strategy for scalable full-text search using sharded MySQL instances.

Quick Start

Apply the rails-37-style-backend-database skill to configure UUIDs as primary keys in a new Rails migration.