Drizzle ORM + Hyperdrive

import { neon } from '@neondatabase/serverless';
import { drizzle, NeonHttpDatabase } from 'drizzle-orm/neon-http';
import { Env } from "@/index";
import * as schema from "@/db/schema"

let dbInstance: NeonHttpDatabase<typeof schema>;

export const initDb = (env: Env) => {
  const sql = neon(env.HYPERDRIVE.connectionString);
  dbInstance = drizzle(sql, { schema, logger: true });
}

export { dbInstance as db };

import { neon } from '@neondatabase/serverless';
import { drizzle, NeonHttpDatabase } from 'drizzle-orm/neon-http';
import { Env } from "@/index";
import * as schema from "@/db/schema"

let dbInstance: NeonHttpDatabase<typeof schema>;

export const initDb = (env: Env) => {
  const sql = neon(env.HYPERDRIVE.connectionString);
  dbInstance = drizzle(sql, { schema, logger: true });
}

export { dbInstance as db };

The Neon serverless driver uses WebSockets — because most serverless providers don't have something like Hyperdrive —  so they aren't compatible and can't be.

WebSocket-per-request is still slower than using Hyperdrive's connection pooling (by a fair bit, as the blog lays out) 

The Neon serverless driver uses WebSockets — because most serverless providers don't have something like Hyperdrive —  so they aren't compatible and can't be.

WebSocket-per-request is still slower than using Hyperdrive's connection pooling (by a fair bit, as the blog lays out)