joshpachner
joshpachner
PostsComments
DTDrizzle Team
Created by joshpachner on 5/4/2024 in #help
Query View syntax error at or near "$1"
Ok I found the issue, and i will keep my post here for my shame and in hopes it helps someone else. I didnt realize that my drizzle-orm/postgres-js was still on version 0.28.6 (im using Deno so its kinda funky how they do the imports) Anyways, once i upgraded them all to version 0.30.9, it now queries as expected
4 replies
DTDrizzle Team
Created by joshpachner on 5/4/2024 in #help
Query View syntax error at or near "$1"
if i toggle it from a 
pgView("my_view",{...)
pgView("my_view",{...)
to 
pgTable("my_view",{...)
pgTable("my_view",{...)
it works
4 replies
DTDrizzle Team
Created by joshpachner on 5/4/2024 in #help
Query View syntax error at or near "$1"
I should add, normal querying against tables via the 
db.query.<tableName>.findMany(...)
db.query.<tableName>.findMany(...)
does work fine
4 replies
DTDrizzle Team
Created by pax on 4/26/2024 in #help
Querying a materialized view: relation does not exist
hey @pax , I dont have the answer for ya. but you could create the view normally in your database, and then just add the .existing() at the end of your drizzle view declaration. (thats what i do for my views, and so that i have more control over it in writing the raw sql)
4 replies
DTDrizzle Team
Created by benjick on 11/29/2023 in #help
Property '[IsDrizzleTable]' is missing in type
@fanckush there's reported issues all over github about the vscode intelisense for Deno. Which is a bummer because honestly thats the only hiccup i have with Deno. I love the concept of it but just the DX is suffering rn 😢 But in case you're using the denoland drizzle library. I would recommend you dont. and rather just import the version you want via esm (especially if you are using drizzle relations since the denoland drizzle highest version came out prior to the drizzle relations)
12 replies
DTDrizzle Team
Created by untitled. on 10/24/2023 in #help
how to use in deno
ok. i switched from my laptop to my desktop and now everything looks to be running smooth with the intelisense in vscode (no more IsDrizzleTable error). @dêniz im not running drizzle kit in deno. but i can show you the drizzle orm portion that i am running in deno, if you want
34 replies
DTDrizzle Team
Created by benjick on 11/29/2023 in #help
Property '[IsDrizzleTable]' is missing in type
aight well i switched running the vscode from my laptop to my desktop. And now there's no intelisense error. 🤷‍♂️ im an idiot, but lucky at the same time i guess
12 replies
DTDrizzle Team
Created by benjick on 11/29/2023 in #help
Property '[IsDrizzleTable]' is missing in type
The more i look at it, it might be a Deno intelisense issue...
12 replies
DTDrizzle Team
Created by benjick on 11/29/2023 in #help
Property '[IsDrizzleTable]' is missing in type
No description
12 replies
DTDrizzle Team
Created by untitled. on 10/24/2023 in #help
how to use in deno
its drizzle connected to a postgres db though, but that shouldnt be an issue
34 replies
DTDrizzle Team
Created by untitled. on 10/24/2023 in #help
how to use in deno
i almost have drizzle running in Deno. (just one thing blocking it is the IsDrizzleTable error). But once i get it all running smoothly, i'll share what I did to get it working. But im not using drizzle-kit though, since the migrations are handled in a node app.
34 replies
DTDrizzle Team
Created by benjick on 11/29/2023 in #help
Property '[IsDrizzleTable]' is missing in type
Looks like the relations() function expects a pgTable that has been updated its config to have the IsDrizzleTable field. But idk if im suppose to be using a different pgTable() when declaring the table. Or use pgTable() but then add somehow a IsDrizzleTable = true in its config 🤷‍♂️
12 replies
DTDrizzle Team
Created by benjick on 11/29/2023 in #help
Property '[IsDrizzleTable]' is missing in type
No description
12 replies