OYΞD
Explore posts from serversDTDrizzle Team
•Created by OYΞD on 3/8/2024 in #help
Struggling to work with JSONB `where`
Seems to work if I use
sql.raw() instead 🤷♀️3 replies
DTDrizzle Team
•Created by OYΞD on 3/8/2024 in #help
Struggling to work with JSONB `where`
I checked and the query does work in raw SQL, so is there something funky perhaps going on with
sql prepared statements?3 replies
DTDrizzle Team
•Created by OYΞD on 4/23/2023 in #help
ERR_PACKAGE_PATH_NOT_EXPORTED on 0.25.1
Yep, migration generation works fine now 🙂 Thanks again!
12 replies
DTDrizzle Team
•Created by OYΞD on 4/23/2023 in #help
ERR_PACKAGE_PATH_NOT_EXPORTED on 0.25.1
Awesome, thanks dude
12 replies
DTDrizzle Team
•Created by OYΞD on 4/11/2023 in #help
Selecting multiple relating rows
(Galaxy generation is somewhat accurate; types of stars, planets/moons/asteroids in those systems, resources on those orbitals themselves)
22 replies
DTDrizzle Team
•Created by OYΞD on 4/11/2023 in #help
Selecting multiple relating rows
The schema I gave in the initial post isn't the full schema, part of the galaxy generation I wrote involves a post-process of figuring out connections between systems in 2D space, they're stored in the DB as
json('connections').$type<string[]>().notNull().default([])22 replies
DTDrizzle Team
•Created by OYΞD on 4/11/2023 in #help
Selecting multiple relating rows
Yeah caching should be fine, just didn't want to be dumb about how I was going about filling the cache
I think it's best I just separate to at least fetch systems and stars separately and then aggregate like you said - definitely better than a single roundtrip
22 replies
DTDrizzle Team
•Created by OYΞD on 4/11/2023 in #help
Selecting multiple relating rows
Approximately 1 per system, but that's not a rule (star systems can have two or more stars)
22 replies
DTDrizzle Team
•Created by OYΞD on 4/11/2023 in #help
Selecting multiple relating rows
Awesome, that tripped me up haha - thanks dude
RE: pagination, it's like ~50k rows I'm background caching, since they have to all be loaded to render a WebGL Galaxy Map in the browser 😅
22 replies
DTDrizzle Team
•Created by OYΞD on 4/11/2023 in #help
Selecting multiple relating rows
Ah, ok, I was using a leftJoin already, but it was coming back as an object with the row instead of an array - if there was only a single row, would it negate the array and just return that one row?
22 replies
DTDrizzle Team
•Created by OYΞD on 3/29/2023 in #help
Randomly stopped being able to generate migrations (MySQL)
Seems @alexblokh found the issue - I was using
drizzle-orm/expressions in a few different services in the monorepo, and installed drizzle-orm in to all of them to have access to that, which caused the issue
After exporting the expressions from the same package that I store the schema & migrations in, removing the drizzle-orm dependency from every other package and (for good measure) re-generating the lockfile, it generates migrations perfectly fine!
Thanks again @alexblokh 🙂10 replies
DTDrizzle Team
•Created by OYΞD on 3/29/2023 in #help
Randomly stopped being able to generate migrations (MySQL)
Awesome, thanks 🙂
10 replies
DTDrizzle Team
•Created by OYΞD on 3/29/2023 in #help
Randomly stopped being able to generate migrations (MySQL)
Sure thing - do you guys have a voice channel here or?
10 replies
DTDrizzle Team
•Created by OYΞD on 3/29/2023 in #help
Randomly stopped being able to generate migrations (MySQL)
v0.17.110 replies