Sithu Khant Posts - Answer Overflow

Sithu Khant

Explore posts from servers

CDCloudflare Developers TtRPC DTDrizzle Team BABetter Auth

•Created by Sithu Khant on 2/13/2025 in #workers-help

Svelte, Hono, and D1 database

This is my middleware:

import { drizzle, type DrizzleD1Database } from "drizzle-orm/d1";
import { createMiddleware } from "hono/factory";

type Env = {
  Bindings: {
    DB: D1Database;
  };
  Variables: {
    db: DrizzleD1Database;
  };
};

export const middleware = createMiddleware<Env>(async (c, next) => {
  const db = drizzle(c.env.DB);

  c.set("db", db);

  await next();
});

import { drizzle, type DrizzleD1Database } from "drizzle-orm/d1";
import { createMiddleware } from "hono/factory";

type Env = {
  Bindings: {
    DB: D1Database;
  };
  Variables: {
    db: DrizzleD1Database;
  };
};

export const middleware = createMiddleware<Env>(async (c, next) => {
  const db = drizzle(c.env.DB);

  c.set("db", db);

  await next();
});

This is how I used:

.get("/getAll", middleware, async (c) => {
    const db = c.get("db");

    try {
      const subscriptions = await db.select().from(SubscriptionTable);

      return c.json({ data: subscriptions });
    } catch (error) {
      const message = handleError(error);
      return c.json({ message }, 500);
    }
  })

.get("/getAll", middleware, async (c) => {
    const db = c.get("db");

    try {
      const subscriptions = await db.select().from(SubscriptionTable);

      return c.json({ data: subscriptions });
    } catch (error) {
      const message = handleError(error);
      return c.json({ message }, 500);
    }
  })

I also set like this in my wrangler.json file:

"d1_databases": [
    {
      "binding": "DB",
      "database_name": "*****",
      "database_id": "*****"
    }
  ]

"d1_databases": [
    {
      "binding": "DB",
      "database_name": "*****",
      "database_id": "*****"
    }
  ]

Why I am getting this error in my svlete project?

TypeError: Cannot read properties of undefined (reading 'DB')
    at eval (/Users/sithu/ht-saas/recurrify/src/lib/features/subscriptions/route.ts:32:40)

TypeError: Cannot read properties of undefined (reading 'DB')
    at eval (/Users/sithu/ht-saas/recurrify/src/lib/features/subscriptions/route.ts:32:40)

3 replies

CDCloudflare Developers

•Created by Sithu Khant on 2/11/2025 in #workers-help

How D1 work with Drizzle ORM?

I created a svelte repo using create cloudflare cli. I found

import { defineConfig } from 'drizzle-kit';
if (!process.env.DATABASE_URL) throw new Error('DATABASE_URL is not set');

export default defineConfig({
    schema: './src/lib/server/db/schema.ts',

    dbCredentials: {
        url: process.env.DATABASE_URL
    },

    verbose: true,
    strict: true,
    dialect: 'sqlite'
});

import { defineConfig } from 'drizzle-kit';
if (!process.env.DATABASE_URL) throw new Error('DATABASE_URL is not set');

export default defineConfig({
    schema: './src/lib/server/db/schema.ts',

    dbCredentials: {
        url: process.env.DATABASE_URL
    },

    verbose: true,
    strict: true,
    dialect: 'sqlite'
});

for the drizzle config. Isn't only for local sqlite db, isn't? How can I config for production D1 database? I know I have to configure D1 in wrangler file. But there is no need to configure d1 database inside drizzle config file? How about generate and migrate?

12 replies

DTDrizzle Team

•Created by Sithu Khant on 2/11/2025 in #help

Drizzle and Cloudflare D1

I created a svelte repo using create cloudflare cli. I found

import { defineConfig } from 'drizzle-kit';
if (!process.env.DATABASE_URL) throw new Error('DATABASE_URL is not set');

export default defineConfig({
    schema: './src/lib/server/db/schema.ts',

    dbCredentials: {
        url: process.env.DATABASE_URL
    },

    verbose: true,
    strict: true,
    dialect: 'sqlite'
});

import { defineConfig } from 'drizzle-kit';
if (!process.env.DATABASE_URL) throw new Error('DATABASE_URL is not set');

export default defineConfig({
    schema: './src/lib/server/db/schema.ts',

    dbCredentials: {
        url: process.env.DATABASE_URL
    },

    verbose: true,
    strict: true,
    dialect: 'sqlite'
});

1 replies

CDCloudflare Developers

•Created by Sithu Khant on 2/6/2025 in #workers-help

I deployed my Svelte site to Cloudflare Workers successfully, But...

But when I open my site on localhost it is just loading. I have been waiting for a long time, it is just loading. How can I fix that?

2 replies

CDCloudflare Developers

•Created by Sithu Khant on 2/2/2025 in #workers-help

How can I add cron job to `wrangler.json` file?

I used svelitekit framework template and hosted to workers. I see this in my wrangler.json file:

"main": ".svelte-kit/cloudflare/_worker.js"

"main": ".svelte-kit/cloudflare/_worker.js"

How can I add cron job to that file? How can I extand that file to cron job?

21 replies

TtRPC

•Created by Sithu Khant on 1/29/2025 in #❓-help

react router v7 framework and trpc

How can I use trpc inside react router v7 framework project?

20 replies

Gaming

Programming