FILE Columns & Uploads

1const avatarFile = fileInput.files?.[0];2if (!avatarFile) throw new Error('No file selected');3 4await client.queryWithFiles(5  'INSERT INTO app.users (id, avatar) VALUES ($1, FILE("avatar"))',6  { avatar: avatarFile },7  ['user_123']8);

1// 1) Insert a FILE via multipart upload2await client.queryWithFiles(3  'INSERT INTO app.users (id, avatar) VALUES ($1, FILE("avatar"))',4  { avatar: avatarFile },5  ['user_123'],6);7 8// 2) Read rows with FILE-aware wrappers9const rows = await client.queryRows<{ id: string; avatar: unknown }>(10  'SELECT id, avatar FROM app.users WHERE id = $1',11  'app.users',12  ['user_123'],13);14 15const avatar = rows[0]?.file('avatar');16if (avatar) {17  console.log(avatar.name, avatar.formatSize());18  console.log(avatar.downloadUrl());19}

1await client.queryWithFiles(sql, files, params, (progress) => {2  console.log(progress.file_name, progress.percent);3});

1import { FileRef, parseFileRef, parseFileRefs } from '@kalamdb/client';

1const ref = parseFileRef(row.attachment);2if (ref) {3  console.log(ref.name, ref.size, ref.mime);4  console.log(ref.formatSize());5  console.log(ref.relativePath());6}

1const row = await client.queryOne('SELECT avatar FROM app.users WHERE id = $1', ['user_123']);2const ref = row?.avatar.asFile();3if (ref) {4  console.log(ref.getDownloadUrl('http://localhost:2900', 'app', 'users'));5}

1const url = ref.getDownloadUrl('http://localhost:2900', 'app', 'users');

1ref.isImage();2ref.isVideo();3ref.isAudio();4ref.isPdf();5ref.getTypeDescription();