Maston Comments - Answer Overflow

Topics

Maston

CDCloudflare Developers

•Created by gulluprasad123 on 4/1/2025 in #workers-help

Parsing .EML using workers

i can use mailparser and buffer-dependent libs just fine, do you have a full example?

10 replies

CDCloudflare Developers

•Created by gulluprasad123 on 4/1/2025 in #workers-help

Parsing .EML using workers

Did you enable nodejs-compat flag in wrangler config?

10 replies

•Created by farhan on 3/28/2025 in #help

How do you guys setup drizzle with next 15?

this happens because it doesnt find "node:net" module, youre either importing it in the frontend somewhere or trying to use edge runtime which doesnt support it

3 replies

•Created by farhan on 3/28/2025 in #help

How do you guys setup drizzle with next 15?

where are you getting the error? are you importing db in a "use client" file by accident?

3 replies

•Created by Silvan on 3/26/2025 in #help

Durable Object example weird import

nevermind its not that option don't use it

11 replies

•Created by Silvan on 3/26/2025 in #help

Durable Object example weird import

https://vite.dev/config/shared-options.html#assetsinclude maybe this

11 replies

•Created by Silvan on 3/26/2025 in #help

Durable Object example weird import

im sure theres a more elegant way of doing this by specifying something for it to count .sql files as text in the vite config

11 replies

•Created by Silvan on 3/26/2025 in #help

Durable Object example weird import

this will create that file

11 replies

•Created by Silvan on 3/26/2025 in #help

Durable Object example weird import

yes - you need a drizzle.config.ts that looks like this:

import { defineConfig } from 'drizzle-kit';

export default defineConfig({
    dialect: 'sqlite',
    driver: 'durable-sqlite',
        // change with where your schema is
    schema: './src/db/schema.ts',
});

import { defineConfig } from 'drizzle-kit';

export default defineConfig({
    dialect: 'sqlite',
    driver: 'durable-sqlite',
        // change with where your schema is
    schema: './src/db/schema.ts',
});

then run drizzle-kit generate

11 replies

•Created by JROCBABY on 3/21/2025 in #help

TypeScript Error: Circular Reference in Drizzle ORM Schema

.references((): AnyPgColumn => tableA.id) should work

3 replies

•Created by Aditya Kirad on 3/20/2025 in #help

error while applying the migrations

there is no DATE in sqlite, you could provide a runtime default like this: integer("createdAt", { mode: "timestamp" }).$default(() => new Date())

4 replies

•Created by fluchat on 3/19/2025 in #help

Init Drizzle with cloudflare env variables

I think you pretty much cant have "db" as a top level variable in cloudflare workers, with Hono i do something like this:

import { type NeonHttpDatabase, drizzle } from 'drizzle-orm/neon-http';
import { Hono } from 'hono';

let db: NeonHttpDatabase<typeof schema> | undefined;

const app = new Hono<{
    Bindings: { DATABASE_URL: string };
    Variables: { db: NeonHttpDatabase<typeof schema> };
}>().use(async (ctx, next) => {
    db ??= drizzle(ctx.env.DATABASE_URL, { schema });
    ctx.set('db', db);
    return next();
});

app.get('/', async (ctx) => {
    // now you can use the database in any route, properly typed
    const count = await ctx.var.db.$count(table);
    return ctx.json({ count });
});

export default app;

import { type NeonHttpDatabase, drizzle } from 'drizzle-orm/neon-http';
import { Hono } from 'hono';

let db: NeonHttpDatabase<typeof schema> | undefined;

const app = new Hono<{
    Bindings: { DATABASE_URL: string };
    Variables: { db: NeonHttpDatabase<typeof schema> };
}>().use(async (ctx, next) => {
    db ??= drizzle(ctx.env.DATABASE_URL, { schema });
    ctx.set('db', db);
    return next();
});

app.get('/', async (ctx) => {
    // now you can use the database in any route, properly typed
    const count = await ctx.var.db.$count(table);
    return ctx.json({ count });
});

export default app;

2 replies

•Created by dinhanhthi on 1/25/2025 in #help

Cannot run Studio with IndexedDB setup for PGlite

Also, this error is not from drizzle-kit, its the error pglite gives when you try to use new Pglite("idb://...") in node

6 replies

•Created by dinhanhthi on 1/25/2025 in #help

Cannot run Studio with IndexedDB setup for PGlite

https://github.com/mastondzn/drizzle-kit-pglite-browser i came up with this

6 replies

•Created by dinhanhthi on 1/25/2025 in #help

Cannot run Studio with IndexedDB setup for PGlite

I don't understand the expected behaviour here? Only errors this way when trying to use pglite's indexeddb persistance... I think you're simply not supposed to use drizzle-kit when using pglite in the browser, how is drizzle-kit going to run migrations when the db is in your browser? You can use drizzle-kit to generate the migrations, but to run them on the browser you need to implement some other logic, for example include them in your public folder, then import them on the frontend and run them there Gonna make a example repo maybe it is useful for people

6 replies

•Created by reaper on 3/19/2025 in #help

How do I seed my Cloudflare D1 db?

i wrote a proof of concept script you can use for both remote (when you specify --remote via args) and local. You can base your seed script on this: https://gist.github.com/mastondzn/76f42e77bf469a87b5dae76f7292ff2c i ended up using libsql client instead of better-sqlite3 but you can do whatever you want @reaper

6 replies

•Created by reaper on 3/19/2025 in #help

How do I seed my Cloudflare D1 db?

If you want a workaround, you can connect to remote d1 in a node script using d1 http api requests, just like they did in the drizzle-kit source using drizzle-orm/sqlite-proxy You can do the same for your local d1 .sqlite file with drizzle-orm/better-sqlite3 and a Database instance from better-sqlite3 Or, you can run your worker and add a seed endpoint, request it after running wrangler dev for local d1 or wrangler dev --remote for remote d1, then just delete it, or keep it and add some logic to make sure it only seeds when you want it to.

6 replies