hugo Comments - Answer Overflow

hugo

Posts Comments

DTDrizzle Team

•Created by lolmaus (Andrey Mikhaylov) on 10/27/2023 in #help

Acceptance testing practices? In-memory Postgres mock for high-speed acceptance testing?

this is awesome! Do you think this approach could replace testcontainers?

13 replies

DTDrizzle Team

•Created by hugo on 6/29/2024 in #help

Anyone had luck with copilot?

not a big deal but it's getting tiresome, every-single-time I have to manually type where: eq...

2 replies

DTDrizzle Team

•Created by Amur on 2/22/2024 in #help

Postgrest inserting json array results in stringified array

yeah that works or use jsonb objects instead if arrays

5 replies

DTDrizzle Team

•Created by Amur on 2/22/2024 in #help

Postgrest inserting json array results in stringified array

seems like known issue https://github.com/drizzle-team/drizzle-orm/issues/724

5 replies

DTDrizzle Team

•Created by Amur on 2/22/2024 in #help

Postgrest inserting json array results in stringified array

hey! I noticed the same issue, having a jsonb doesn't save the array, but just a string instead. I have my column defined like this:

readByJson: jsonb('read_by').$type<string[]>(),

readByJson: jsonb('read_by').$type<string[]>(),

any way to make it save an actual array instead of the string?

5 replies

DTDrizzle Team

•Created by omar on 1/13/2024 in #help

How to create a variable with the same name as the table name?

I like to name my drizzle table variables in NameCap: export const Users = pgTable(‘users’)…

12 replies

DTDrizzle Team

•Created by Screw on 1/6/2024 in #help

data is malformed on drizzle-kit V 0.20.10

was this in a release not as a breaking change or something?

13 replies

DTDrizzle Team

•Created by Dudeguy on 1/8/2024 in #help

drizzle migration shows 0 indexes

FKs don’t create indexes btw (not a drizzle issue, just how dbs work)

4 replies

DTDrizzle Team

•Created by hugo on 11/16/2023 in #help

Unable to generate migration for sqlite

Update 2: I'm on a turborepo and for some reason drizzle-orm was installed in a package's node_module instead of the repo's node_module. It works if I add drizzle-orm as a root dependency but seems weird to do that

7 replies

DTDrizzle Team

•Created by hugo on 11/16/2023 in #help

Unable to generate migration for sqlite

Update: seems like a build error. I can see drizzle-orm/pg-core in my node_modules

7 replies

DTDrizzle Team

•Created by hugo on 10/31/2023 in #help

[SOLVED] How to add new column?

Thanks @Angelelz ! Removing --> statement-breakpoint made it possible to be applied. Wondering why is this the default behavior since adding a column is the most basic use case for a migration...

5 replies

DTDrizzle Team

•Created by janat08 on 9/22/2023 in #help

Execute is not exist on a type LibSQLDatabase

I believe it's just an issue on the docs here https://orm.drizzle.team/docs/sql#sql-template

11 replies

DTDrizzle Team

•Created by janat08 on 9/22/2023 in #help

Execute is not exist on a type LibSQLDatabase

import { createClient } from '@libsql/client'
import { drizzle } from 'drizzle-orm/libsql'

const db = drizzle(createClient({ url: String(process.env.DATABASE_URL) }))

import { createClient } from '@libsql/client'
import { drizzle } from 'drizzle-orm/libsql'

const db = drizzle(createClient({ url: String(process.env.DATABASE_URL) }))

11 replies

DTDrizzle Team

•Created by janat08 on 9/22/2023 in #help

Execute is not exist on a type LibSQLDatabase