export default {  async fetch(request, env) {    // Create a table    await env.DB.exec(`CREATE TABLE IF NOT EXISTS users (      id INTEGER PRIMARY KEY,      name TEXT NOT NULL,      email TEXT UNIQUE NOT NULL,      created_at DATETIME DEFAULT CURRENT_TIMESTAMP    )`);
    // Insert data    const { results } = await env.DB.prepare(      `INSERT INTO users (name, email) VALUES (?, ?)`,    )      .bind('John Doe', 'john@example.com')      .run();
    // Query data    const { results: users } = await env.DB.prepare(      `SELECT * FROM users WHERE email = ?`,    )      .bind('john@example.com')      .all();
    return new Response(JSON.stringify(users), {      headers: { 'Content-Type': 'application/json' },    });  },};

// schema.prismagenerator client {  provider = "prisma-client-js"}
datasource db {  provider = "sqlite"  url      = env("DATABASE_URL")}
model User {  id        Int      @id @default(autoincrement())  name      String  email     String   @unique  createdAt DateTime @default(now())  posts     Post[]}
model Post {  id        Int      @id @default(autoincrement())  title     String  content   String  authorId  Int  author    User     @relation(fields: [authorId], references: [id])  createdAt DateTime @default(now())}
// worker.tsimport { PrismaClient } from '@prisma/client';
export default {  async fetch(request, env) {    const prisma = new PrismaClient({      datasources: {        db: {          url: env.DATABASE_URL        }      }    });
    // Create a user with posts    const user = await prisma.user.create({      data: {        name: 'Jane Doe',        email: 'jane@example.com',        posts: {          create: [            { title: 'Hello World', content: 'My first post!' },            { title: 'D1 is Great', content: 'I love using D1 with Prisma!' }          ]        }      },      include: {        posts: true      }    });
    return new Response(JSON.stringify(user), {      headers: { 'Content-Type': 'application/json' }    });  }};

export default {  async fetch(request, env) {    const { searchParams } = new URL(request.url);    const userId = searchParams.get('userId');
    if (!userId) {      return new Response('Missing userId parameter', { status: 400 });    }
    // Use read replica for better performance    const dbSession = env.DB.withSession();    const { results } = await dbSession      .prepare(        `SELECT u.*, COUNT(p.id) as post_count          FROM users u          LEFT JOIN posts p ON u.id = p.authorId          WHERE u.id = ?         GROUP BY u.id`,      )      .bind(userId)      .all();
    return new Response(JSON.stringify(results), {      headers: { 'Content-Type': 'application/json' },    });  },};

wrangler d1 time-travel restore YOUR_DATABASE --timestamp=UNIX_TIMESTAMP
🚧 Restoring database YOUR_DATABASE from bookmark 00000080-ffffffff-00004c60-390376cb1c4dd679b74a19d19f5ca5be
⚠️ This will overwrite all data in database YOUR_DATABASE.In-flight queries and transactions will be cancelled.
✔ OK to proceed (y/N) … yes⚡️ Time travel in progress...✅ Database YOUR_DATABASE restored back to bookmark 00000080-ffffffff-00004c60-390376cb1c4dd679b74a19d19f5ca5be
↩️ To undo this operation, you can restore to the previous bookmark: 00000085-ffffffff-00004c6d-2510c8b03a2eb2c48b2422bb3b33fad5