DT
Drizzle Teamhirefrank
SQL many statements?
Any ideas on how to debug this?
The generate SQL its trying to run is
Using sqlite/turso and deno. Thanks!
H
hirefrank•14d ago
I've upgraded to the last versions of libsql, drizzle-kit and drizzle-orm but keep getting the same error
any ideas folks?
S
ShaneCodes•7d ago
Running into the same issue.
AS
Andrii Sherman•7d ago
Looking into it
S
ShaneCodes•7d ago
here is snippets/error from general.
https://discord.com/channels/1043890932593987624/1043890932593987627/1238160624647798797
A
Angelelz•6d ago
Isn't that the purpose of the breakpoints?
AS
Andrii Sherman•6d ago
yes, strange it didn't work
--> statement-breakpoint
should do the trickThe official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
7.3KMembers
View on DiscordWant results from more Discord servers?
More PostsQuerying a materialized view: relation does not existI define a materialized view as such:
```
export const usersMv = pgMaterializedView("users_mv").as(
default to empty object for sqlite text field with JSON modeHow can I default a `mode: 'json'` text type to an empty object in sqlite?
The following in a `sqliConverting a field from X type to Serial causes errorsI'm attempting to convert a field from type `text` to type `serial`.
Here's the error I'm seeing:
`Return type is only "with" types, ignores "columns" typesNot sure if I'm using it wrong but the return type of a relational query is just the columns from thonUpdateupdatedAt: timestamp('updated_at', { mode: 'date', precision: 3 })
.defaultNow()
.$onUpdate(Struggling with subqueriesI want to basically do this query in drizzle:
SELECT o.id, o.date, t.currency
FROM "Operations" o
LENot clear what happens during migrateI have a sandbox project and have properly created a migrate that created the initial schema, and apmax connections time out```typescript
import { Injectable, Scope } from '@nestjs/common';
import { Pool, PoolConfig } from 'CI/CD check if schema matches databaseHi, is there a way use drizzle-kit or drizzle itself to check if the database structure matches the 'drizzle-kit introspect:pg' generates invalid Typerscript syntax ("::character varying", "NULL")When I use , it generates my schema.ts file, but includes syntax that is invalid, such as:
```
expoCan I create a one to one relationship that would actually fetch the last item?The relationship is actually a one to many but only want to retrieve the last one.
goal: one(goalclasses to access dbIs this code possible? Copilot says it's valid but I cannot find it in the documentation
```
importQuery "with" not populatedI have a collection relation and a file relation. I want to query a collection and all their files. Duplicate parentHey, I have a large schema with many tables and many relations. I would like to duplicate a parent rDynamic read replicasI have a use case that read replicas are dynamically located using Service Discovery and I need to sSQLite functions not being calledI think I might've found a bug. At least in Studio, maybe in orm as well. Could someone please verif