do you get not authorized or an error about it not existing
do you get not authorized or an error about it not existing
BLOB (initially generated with (randomblob(16))), this works:not authorized to use function: sqlite_version3.41.0base64() too...plzzzzzz update to 3.41.0+cloudflare/workers-sdk
This is a beta-only limitation. The maximum storage per-database, storage per-account and number of databases will automatically increase for paid plans during the course of D1’s public beta.

BLOB(randomblob(16))not authorized to use function: sqlite_version(lower(format('%s-%s-%s-%s-%s', substr(hex(t_id),1,8), substr(hex(t_id),9,4), substr(hex(t_id),13,4), substr(hex(t_id),17,4), substr(hex(t_id),21)))){
result: [],
success: false,
errors: [ { code: 7500, message: 'no such function: unhex' } ],
messages: []
}import { randomUUID } from 'node:crypto';
export class Helpers {
public static get generateUuid() {
const uuid = randomUUID();
const uuidHex = uuid.replaceAll('-', '');
return {
utf8: uuid,
forBlob: uuidHex,
};
}
}query: {
params: [Helpers.generateUuid.forBlob],
sql: `INSERT INTO some_table (uuid) VALUES (unhex(?))`,
}