do-sql-drizzle

Sample Workers application using Durable Objects SQL API database with Workery and Drizzle ORM. This template contains a schema.ts file where SQL table schemas are defined and an index.ts file defining CRUD route handlers interacting with the Durable Object interface implemented on databases.ts. The schema.ts file is also used for tracking and generating database migration files.

Extra setup required

After creating an application with this template, manual extra setup is required:

• Generate the migration file with the definitions in schema.ts. The migrations does not need to be applied manually, they automatically attempts to apply on durable object instantiation (see databases.ts).

---

Available script commands:

npm

# Start dev server:
npm run dev

# Deploy application:
npm run deploy

# Detect and generate migrations
npm run migrations:generate

yarn

# Start dev server:
yarn run dev

# Deploy application:
yarn run deploy

# Detect and generate migrations
yarn run migrations:generate

pnpm

# Start dev server:
pnpm run dev

# Deploy application:
pnpm run deploy

# Detect and generate migrations
pnpm run migrations:generate

---

Remember that by default, access to the interactive docs is available at http://127.0.0.1:8787/docs