15 replies

Transaction help

Hi, we've been using neon serverless with drizzle driver (

@neondatabase/serverless

@neondatabase/serverless

drizzle-orm/neon-http

drizzle-orm/neon-http

) successfully for a while. I wanted to know if drizzle has syntax which supports this "non-iteractive" style of transaction mentioned here in neons serverless docs. https://github.com/neondatabase/serverless?tab=readme-ov-file#transaction

import { neon } from '@neondatabase/serverless';
const sql = neon(process.env.DATABASE_URL);
const showLatestN = 10;

const [posts, tags] = await sql.transaction([
  sql`SELECT * FROM posts ORDER BY posted_at DESC LIMIT ${showLatestN}`,
  sql`SELECT * FROM tags`,
]);

import { neon } from '@neondatabase/serverless';
const sql = neon(process.env.DATABASE_URL);
const showLatestN = 10;

const [posts, tags] = await sql.transaction([
  sql`SELECT * FROM posts ORDER BY posted_at DESC LIMIT ${showLatestN}`,
  sql`SELECT * FROM tags`,
]);

Forgive my ignorance I can't see this in drizzle docs and from playing out with the transaction method it doesn't seem possible? I ask as from what I understand, when using neon-serverless with drizzle via neon-http the only way to use interactive transactions with nextjs on vercel is with Pool or Client usage, which seems like we’re limited to usage only in our API routes if we wanted interactive

GitHub

GitHub - neondatabase/serverless: Connect to Neon PostgreSQL from s...

Connect to Neon PostgreSQL from serverless/worker/edge functions - neondatabase/serverless

Drizzle Team•7mo ago•

15 replies

willem

Transaction help

Hi, we've been using neon serverless with drizzle driver (

@neondatabase/serverless

@neondatabase/serverless

drizzle-orm/neon-http

drizzle-orm/neon-http

import { neon } from '@neondatabase/serverless';
const sql = neon(process.env.DATABASE_URL);
const showLatestN = 10;

const [posts, tags] = await sql.transaction([
  sql`SELECT * FROM posts ORDER BY posted_at DESC LIMIT ${showLatestN}`,
  sql`SELECT * FROM tags`,
]);

import { neon } from '@neondatabase/serverless';
const sql = neon(process.env.DATABASE_URL);
const showLatestN = 10;

const [posts, tags] = await sql.transaction([
  sql`SELECT * FROM posts ORDER BY posted_at DESC LIMIT ${showLatestN}`,
  sql`SELECT * FROM tags`,
]);

GitHub

GitHub - neondatabase/serverless: Connect to Neon PostgreSQL from s...

Connect to Neon PostgreSQL from serverless/worker/edge functions - neondatabase/serverless

Transaction help

Transaction help

Similar Threads

Similar Threads

Similar Threads