Bilingual

Getting Rails' ActiveStorage blob IDs from file URLs
13 hours ago
- Extract blob ID from expiring ActiveStorage URLs to avoid re-downloading images.
- The expiring URL contains a base64-encoded JSON object with a consistent blob ID.
- Method: split URL path by '/', take the third segment from the end, split by '--', decode base64, and read '_rails.data' from the JSON.
- Blob IDs are unique and not reused, allowing reliable file identification.
Questions for the Team During Onboarding
19 days ago
- A set of questions for developers, CTO/EM, and business stakeholders to audit a Rails codebase.
- Questions for developers focus on code fear, deployment timing, and production issues not caught by tests.
- Questions for CTO/EM cover feature blocks, error visibility, and underestimated feature timelines.
- Questions for business stakeholders address quietly disabled features and unfulfilled customer promises.
- Mentions recent articles related to sqlite-utils updates and agent video demo tools.
Avoiding SQLite Database Locks in Production
23 days ago
- The article discusses encountering SQLite3::BusyException in a Rails app using Solid Queue due to SQLite's single-writer locking mechanism.
- Key solutions include proper SQLite configuration with busy_timeout and timeout set to the same value, enabling WAL mode, and optimizing pragmas like synchronous and mmap_size.
- A misconfiguration in deploy.yml (SOLID_QUEUE_IN_PUMA env var) caused Solid Queue to run twice, leading to lock issues; fixing it resolved the problem.
- Recurring jobs in Solid Queue should be scheduled to avoid simultaneous execution to identify lock causes through logged exception times.
- Avoid using .find_each for batch updates in jobs as it holds a read cursor open; instead, pluck IDs and process in small batches to release locks quickly.
- An opencode skill was created to prevent SQLite lock issues by guiding AI agents to avoid read cursors during writes and batch writes in transactions.

rails

Getting Rails' ActiveStorage blob IDs from file URLs

Questions for the Team During Onboarding

Avoiding SQLite Database Locks in Production