TTC
Theo's Typesafe Cult•2mo ago
jessequartey

select vs query? (Drizzle)

I am building my first production application with Drizzle and I am loving it. But one thing that is not clear to is when to use query vs select. Are there performance implications and I want to know the differences in behavior.
5 Replies
Neto
Neto•2mo ago
query is a nicer way to do queries
Matvey
Matvey•2mo ago
is you select the exactly the same thing the performace is the same
Neto
Neto•2mo ago
akin to prisma queries 
const users = await prisma.user.findMany({
  relationLoadStrategy: 'join', // or 'query'
  include: {
    posts: true,
  },
})
const users = await prisma.user.findMany({
  relationLoadStrategy: 'join', // or 'query'
  include: {
    posts: true,
  },
})
Matvey
Matvey•2mo ago
with select you can do queries that aren't possible with query
Neto
Neto•2mo ago
query is the general usage of querying the db with select with get a more granular and hand-written sql, but you need to "change the shape" of data later
Want results from more Discord servers?
Add your server
More Posts
T3 trpc depdent query is failing ?I have this code , my third question `getQuestion` `useQuery` is failing not sure why, I read abouUploadthing multiple upload filesI have 1 feature, where users can upload as many files as they want, how can I upload as many files generateUploadButton button is disabled or somethingI made a temp react app to test uploadthing, I just did ``` const UploadButton = generateUploadButPings videocall built some thing like webrtc?Hello guys, i was wondering the videocall of ping wqs built with something like webrtc. If yes how aCan you store refs in an object in React?In a component we need 9 different refs (don't ask 🙂 ). If we put the refs in an object like this wAdvices for an electron appHello guys, I have some conceptions issues with electron, Sometimes, my app will be on non connecteduploadthing cant use generateReactHelpers to get the uploadFiles functionidk seems off. when calling upload file like in the code i get the error in the screenshot. also thWhy am i unable to upload it?```ts import { generateUploadButton, generateUploadDropzone, } from "@uploadthing/react"; imporNext Auth - Apple sign in - Pages routerSomeone here that has done apple auth sign in for next auth with next.js pages router? 🤔 Not sureWriting to a variable defined outside a component or hook is not allowed. Consider using an effectWith the new react compiler, I have a few `Writing to a variable defined outside a component or hook