SKDown
SKDown
PostsComments
DTDrizzle Team
Created by SKDown on 7/30/2024 in #help
Dropping tables using Drizzle studio extension on planet scale
Can I drop tables by accident on production branches on PlanetScale while using the studio extension? I am afraid to test it.. for obvious reasons 😄 - https://chromewebstore.google.com/detail/mjkojjodijpaneehkgmeckeljgkimnmd
3 replies
DTDrizzle Team
Created by SKDown on 4/28/2024 in #help
SQLite update at column
How do you guys would write the created and updated at column schemas when using sqlite? 
  createdAt: text("createdAt")
    .notNull()
    .default(sql`(CURRENT_TIMESTAMP)`),
  updatedAt: text('updatedAt')
    .notNull()
    .default(sql`(CURRENT_TIMESTAMP)`)
    .$onUpdate(() => sql`(CURRENT_TIMESTAMP)`),
  createdAt: text("createdAt")
    .notNull()
    .default(sql`(CURRENT_TIMESTAMP)`),
  updatedAt: text('updatedAt')
    .notNull()
    .default(sql`(CURRENT_TIMESTAMP)`)
    .$onUpdate(() => sql`(CURRENT_TIMESTAMP)`),
1 replies