2 replies

Storing Uint8Array in D1

drizzle orm

Hey folks, I'm trying to make a custom type to store a Uint8Array in D1. What I've got so far:

export const uint8Array = (name: string) =>
  customType<{ data: Uint8Array<ArrayBuffer>; driverData: ArrayBuffer }>({
    dataType: () => "blob",
    toDriver: (value) => value.buffer,
    fromDriver: (value) => new Uint8Array(value),
  })(name)

export const uint8Array = (name: string) =>
  customType<{ data: Uint8Array<ArrayBuffer>; driverData: ArrayBuffer }>({
    dataType: () => "blob",
    toDriver: (value) => value.buffer,
    fromDriver: (value) => new Uint8Array(value),
  })(name)

This inserts fine, but on select returns

Error: JSON cannot hold BLOB values: SQLITE_ERROR

Error: JSON cannot hold BLOB values: SQLITE_ERROR

Any tricks?

Drizzle Team•5w ago•

2 replies

xeon06

Storing Uint8Array in D1

drizzle orm

Hey folks, I'm trying to make a custom type to store a Uint8Array in D1. What I've got so far:

export const uint8Array = (name: string) =>
  customType<{ data: Uint8Array<ArrayBuffer>; driverData: ArrayBuffer }>({
    dataType: () => "blob",
    toDriver: (value) => value.buffer,
    fromDriver: (value) => new Uint8Array(value),
  })(name)

export const uint8Array = (name: string) =>
  customType<{ data: Uint8Array<ArrayBuffer>; driverData: ArrayBuffer }>({
    dataType: () => "blob",
    toDriver: (value) => value.buffer,
    fromDriver: (value) => new Uint8Array(value),
  })(name)

This inserts fine, but on select returns

Error: JSON cannot hold BLOB values: SQLITE_ERROR

Error: JSON cannot hold BLOB values: SQLITE_ERROR

Any tricks?

Storing Uint8Array in D1

Similar Threads

Storing Uint8Array in D1

Similar Threads

Similar Threads

Similar Threads