sqlite-fault-tolerant-queries

作者：agent67尚無安裝尚無按讚更新於 2026年6月17日分類：其他

它能做什麼

Use when managing database schema transitions, writing math rate routes, and creating server endpoints.

安裝會在你的 AgentsRoom 桌面版開啟這個條目。如果還沒有安裝應用，你會被帶到下載頁面。

SKILL.md

---
name: sqlite-fault-tolerant-queries
description: Use when managing database schema transitions, writing math rate routes, and creating server endpoints.
---

# SQLite Database Concurrency & Cold-Start Procedures

1. **Concurrency Protection:** Always query using the core database singleton connection mapping (`database.js`). Never spin up loose parallel `new sqlite3.Database()` handlers to avoid `SQLITE_BUSY` runtime lockups.
2. **Outlier Mitigation:** Refactor raw linear velocity averages to support moving averages or lookback metrics (e.g., filtering for the last 7 days) to minimize massive one-off sales anomalies.
3. **Zero-Transaction Defenses:** If an item's transaction log maps to `N/A` or zero historical velocity lines, invoke structural fallbacks (`Math.max(1, daysElapsed)`) to eradicate program-crashing mathematical division-by-zero errors.

標籤

backendai-forecasting-specialist