Drizzle

Installation

Make sure you have installed and configured Drizzle ORM before using this adapter.

Install adapter package for PostgreSQL and dataloader


npm i @uplo/adapter-drizzle-pg dataloader


pnpm add @uplo/adapter-drizzle-pg dataloader


yarn add @uplo/adapter-drizzle-pg dataloader


bun add @uplo/adapter-drizzle-pg dataloader

Add Drizzle adapter to Uplo


import DrizzleAdapter from '@uplo/adapter-drizzle';
 
const uplo = Uplo({
  adapter: Drizzle({ db, schema }),
})

Example schema


const id = serial('id').primaryKey().$type<Blob['id']>();
 
const createdAt = timestamp('created_at', {
  precision: 6,
  withTimezone: true,
})
  .defaultNow()
  .notNull();
 
export const fileAttachments = pgTable('file_attachments', {
  id,
  blobId: integer('blob_id').notNull().$type<Blob['id']>(),
  name: varchar('name').notNull(),
  recordType: varchar('record_type').notNull(),
  recordId: integer('record_id').notNull(),
  createdAt,
});
 
export const fileBlobs = pgTable('file_blobs', {
  id,
  serviceName: varchar('service_name').notNull(),
  key: varchar('key').notNull(),
  fileName: varchar('file_name').notNull(),
  contentType: varchar('content_type').notNull(),
  size: bigint('size', { mode: 'bigint' }).notNull(),
  checksum: varchar('checksum').notNull(),
  metadata: jsonb('metadata').default({}).$type<Blob['metadata']>().notNull(),
  createdAt,
});