meow Posts - Answer Overflow

meow

Explore posts from servers

RReactiflux CDCloudflare Developers DDeno SSolidJS TtRPC TTCTheo's Typesafe Cult DTDrizzle Team

•Created by meow on 8/23/2024 in #help

drizzle-kit push connection cleanup

How do I run a cleanup script after drizzle-kit push, such as to kill database connections? Otherwise I noticed that drizzle-kit leaves connections open.

1 replies

DTDrizzle Team

•Created by meow on 8/23/2024 in #help

Maximum call stack for transactions

I've been trying to do a transaction over 100k rows (works at 10k) but I've been getting an error for stack size. How do I handle bigger transactions?

✗ Transaction failed. 13 | }
14 | function mergeQueries(queries) {
15 |   const result = { sql: "", params: [] };
16 |   for (const query of queries) {
17 |     result.sql += query.sql;
18 |     result.params.push(...query.params);
                       ^
RangeError: Maximum call stack size exceeded.
      at mergeQueries (/Users/meow/Projects/psql/node_modules/drizzle-orm/sql/sql.js:18:19)
      at /Users/meow/Projects/psql/node_modules/drizzle-orm/sql/sql.js:52:26
      at /Users/meow/Projects/psql/node_modules/drizzle-orm/pg-core/query-builders/insert.js:133:53
      at /Users/meow/Projects/psql/node_modules/drizzle-orm/pg-core/query-builders/insert.js:141:19
      at /Users/meow/Projects/psql/src/db/seed.ts:124:6

✗ Transaction failed. 13 | }
14 | function mergeQueries(queries) {
15 |   const result = { sql: "", params: [] };
16 |   for (const query of queries) {
17 |     result.sql += query.sql;
18 |     result.params.push(...query.params);
                       ^
RangeError: Maximum call stack size exceeded.
      at mergeQueries (/Users/meow/Projects/psql/node_modules/drizzle-orm/sql/sql.js:18:19)
      at /Users/meow/Projects/psql/node_modules/drizzle-orm/sql/sql.js:52:26
      at /Users/meow/Projects/psql/node_modules/drizzle-orm/pg-core/query-builders/insert.js:133:53
      at /Users/meow/Projects/psql/node_modules/drizzle-orm/pg-core/query-builders/insert.js:141:19
      at /Users/meow/Projects/psql/src/db/seed.ts:124:6

3 replies

DTDrizzle Team

•Created by meow on 8/18/2024 in #help

Postgres Schema (namespace)

Does anyone have a minimal example of a Drizzle postgres schema that uses the Postgres "Schema" (namespace) feature? On drizzle kit push I keep getting error: schema "meow" does not exist.

import { sql } from "drizzle-orm"
import {
  index,
  serial,
  timestamp,
  pgSchema,
  text,
} from "drizzle-orm/pg-core"

const schema = pgSchema("meow")

const time = (name="time") => timestamp(name, { withTimezone: true, mode: "date" }).default(sql`CURRENT_TIMESTAMP`).notNull()
const event = schema.enum("event_type", ["click", "buy", "poll"])

export const User = schema.table("user", {
  id:       text("id").primaryKey(),
  email:    text("email").unique().notNull(),
  hash:     text("hash").notNull(),
  username: text("username").unique().notNull(),
})

import { sql } from "drizzle-orm"
import {
  index,
  serial,
  timestamp,
  pgSchema,
  text,
} from "drizzle-orm/pg-core"

const schema = pgSchema("meow")

const time = (name="time") => timestamp(name, { withTimezone: true, mode: "date" }).default(sql`CURRENT_TIMESTAMP`).notNull()
const event = schema.enum("event_type", ["click", "buy", "poll"])

export const User = schema.table("user", {
  id:       text("id").primaryKey(),
  email:    text("email").unique().notNull(),
  hash:     text("hash").notNull(),
  username: text("username").unique().notNull(),
})

8 replies

DTDrizzle Team

•Created by meow on 6/21/2024 in #help

Raw SQL query (`.execute()` doesn't exist)

I'm trying to run a raw SQL query for sqlite3 with the Bun driver and I'm finding that .execute() doesn't exist. Anyone got any leads?

import Database from "bun:sqlite"
import { drizzle } from "drizzle-orm/bun-sqlite"

/** raw Bun database client */
export const sqlite = new Database("db.sqlite", { strict: true })

/** Drizzle database client */
export const db = drizzle(sqlite)

const email = "hello@example.com"

const query = sql<{exists:boolean}>`select exists(${db.select({ n: sql`1` }).from(User).where(eq(User.email, email))}) as exists`

import Database from "bun:sqlite"
import { drizzle } from "drizzle-orm/bun-sqlite"

/** raw Bun database client */
export const sqlite = new Database("db.sqlite", { strict: true })

/** Drizzle database client */
export const db = drizzle(sqlite)

const email = "hello@example.com"

const query = sql<{exists:boolean}>`select exists(${db.select({ n: sql`1` }).from(User).where(eq(User.email, email))}) as exists`

1 replies

DTDrizzle Team

•Created by meow on 3/14/2024 in #help

Postgres Schema (namespace) + Drizzle

How do I specify a Postgres schema (as in the psql namespace feature) for drizzle.config.ts? A connection string with database?schema=blah hasn't worked for me.

6 replies

Gaming

Programming