drizzle

https://drizzle.zhcndoc.com/docs/get-started/postgresql-new

DATABASE_URL=postgresql://qin:1@192.168.1.4:5432/db1

entity demo

const table = pgTable("table", {
  id: integer()
    .notNull()
    .primaryKey()
    .generatedAlwaysAsIdentity({ startWith: 1000 }),

  // 二者一致
  integer1: integer().default(42),
  integer2: integer().default(sql`'42'::integer`),

  // 二者一致
  uuid1: uuid().defaultRandom(),
  uuid2: uuid().default(sql`gen_random_uuid()`),

  updatedAt: timestamp({ mode: "date", precision: 3 }).$onUpdate(
    () => new Date()
  ),
});