Skip to main content

Database Standards

Asset360 v3 uses Cloudflare D1 (SQLite) with Drizzle ORM.

Key Principles​

  1. No Transactions: D1 doesn't support transactions - use sequential operations
  2. Statement Limits: Keep SQL statements and parameter counts reasonable
  3. Drizzle Kit for Migrations: Never manually create migration files

Schema Changes​

After modifying schema in worker/db/schema/:

pnpm drizzle-kit generate

This generates migration files in migrations/.

See Also​