cloudflare-d1

SKILL.md

Status: Production Ready ✅ Last Updated: 2025-11-23 Dependencies: cloudflare-worker-base (for Worker setup) Latest Versions: wrangler@4.50.0, @cloudflare/workers-types@4.20251121.0

| Statement too long | Large INSERT with 1000+ rows | Break into batches of 100-250 using batch() | | Too many requests queued | Individual queries in loop | Use batch() instead of loop | | D1TYPEERROR | Using undefined in bind | Use null for optional values: .bind(email, bio \|\| null) |

| Transaction conflicts | BEGIN TRANSACTION in migration | Remove BEGIN/COMMIT (D1 handles automatically) | | Foreign key violations | Schema changes break constraints | Use PRAGMA deferforeignkeys = true |

在 Cloudflare 的邊緣使用 D1 無服務器 SQLite 數據庫構建。使用場合：創建數據庫、編寫 SQL 遷移、從 Workers 查詢 D1、處理關係數據或排除 D1_ERROR、語句太長、遷移失敗或查詢性能問題。 來源：ovachiever/droid-tings。

查看原文