DT
Drizzle Team•5mo ago
mwjt42.

Is it possible to select 1 row?

Seems an annoying oversight that I have to implement variable[0] everytime, even though I'm matching unique IDs
2 Replies
Mykhailo
Mykhailo•5mo ago
Hello, @mwjt42. It is how sql works, but you can try relational queries and findFirst method and get only 1 record. https://orm.drizzle.team/docs/rqb https://orm.drizzle.team/docs/rqb#find-first
Drizzle ORM - Query
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
chocolate
chocolate•5mo ago
Just do const [variable] = drizzle... when it returns an array with 1 data
Want results from more Discord servers?
Add your server
More Posts
get table's CREATE sql with DrizzleHello, does anyone know if it's possible to get a table's create sql with Drizzle? Would like to makCreate index in DESC orderConsider this schema: ```ts export const contactFormSubmission = pgTable( 'contact_form_submissioThe optimise likes tableI am beginner, i have lealearned about social media design pattern, i created posts, likes, commentsWhy fields with default value is nullableConsider this schema: ```ts export const blogMetadata = pgTable('blog_metadata', { id: varchar('id[SQLite Expo driver] Error code : no such table: task_to_tags``` Error: Call to function 'NativeDatabase.prepareSync' has been rejected. → Caused by: Error code Missing module "pg-core" when attempting to push?Title says most of it. I can provide details, but I'm following the example pretty closely.