Mike J
Mike J
Explore posts from servers
CDCloudflare DevelopersDTDrizzle Team
PostsComments
DTDrizzle Team
Created by Mike J on 10/26/2024 in #help
How would you write this SQL query using Drizzle?
I realise I have made this more complicated than it needs to be. Because I expect select to return something most of the time, it's far simpler to just do a select and if I get null do a second query to insert. The COALESCE didn't do what I thought it doesn't stop the CTE being executed
2 replies
DTDrizzle Team
Created by DragonCoder99 on 10/18/2024 in #help
Using UUID v7 with Drizzle?
Hey @DragonCoder99 This has been fine for me in my schema.ts: 
export const clients = pgTable("clients", {
    id: uuid("id").primaryKey().default(sql`uuid_generate_v7()`)
});
export const clients = pgTable("clients", {
    id: uuid("id").primaryKey().default(sql`uuid_generate_v7()`)
});
Don't forget to add the extension first e.g. 
CREATE extension pg_uuidv7;
CREATE extension pg_uuidv7;
3 replies