database.ts
For the full content of this gist, refer to https://gist.github.com/CodingAbdullah/41606afdf73da6c95244ca22464e2c3f
McMaster. Software Engineer with a keen interest in blockchain and web3.
import { drizzle } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';
import * as schema from './schema/User';
// Database connection string to establish connection to Supabase
// Database connection using an ORM is slightly different
// We use the database URL to connect directly to Supabase
const connectionString = process.env.DATABASE_URL!;
// Disable prefetch as it is not supported for "Transaction" pool mode
const client = postgres(connectionString, { prepare: false });
// Export the database instance using drizzle
export const db = drizzle(client, { schema });