Function blob

blob(): SQLiteBlobJsonBuilderInitial<"">
It's recommended to use text('...', { mode: 'json' }) instead of blob in JSON mode, because it supports JSON functions:

All JSON functions currently throw an error if any of their arguments are BLOBs because BLOBs are reserved for a future enhancement in which BLOBs will store the binary encoding for JSON.

https://www.sqlite.org/json1.html

Returns SQLiteBlobJsonBuilderInitial<"">
- Defined in node_modules/.pnpm/[email protected]_@[email protected]_@[email protected]_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/columns/blob.d.ts:69
blob<TMode extends BlobMode = BlobMode>(
    config?: BlobConfig<TMode>,
): Equal<TMode, "bigint"> extends true
    ? SQLiteBigIntBuilderInitial<"">
    : Equal<TMode, "buffer"> extends true
        ? SQLiteBlobBufferBuilderInitial<"">
        : SQLiteBlobJsonBuilderInitial<"">
It's recommended to use text('...', { mode: 'json' }) instead of blob in JSON mode, because it supports JSON functions:

All JSON functions currently throw an error if any of their arguments are BLOBs because BLOBs are reserved for a future enhancement in which BLOBs will store the binary encoding for JSON.

https://www.sqlite.org/json1.html
Type Parameters
- TMode extends BlobMode = BlobMode
Parameters
- Optionalconfig: BlobConfig<TMode>
Returns Equal<TMode, "bigint"> extends true
    ? SQLiteBigIntBuilderInitial<"">
    : Equal<TMode, "buffer"> extends true
        ? SQLiteBlobBufferBuilderInitial<"">
        : SQLiteBlobJsonBuilderInitial<"">
- Defined in node_modules/.pnpm/[email protected]_@[email protected]_@[email protected]_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/columns/blob.d.ts:70
blob<TName extends string, TMode extends BlobMode = BlobMode>(
    name: TName,
    config?: BlobConfig<TMode>,
): Equal<TMode, "bigint"> extends true
    ? SQLiteBigIntBuilderInitial<TName>
    : Equal<TMode, "buffer"> extends true
        ? SQLiteBlobBufferBuilderInitial<TName>
        : SQLiteBlobJsonBuilderInitial<TName>
It's recommended to use text('...', { mode: 'json' }) instead of blob in JSON mode, because it supports JSON functions:

All JSON functions currently throw an error if any of their arguments are BLOBs because BLOBs are reserved for a future enhancement in which BLOBs will store the binary encoding for JSON.

https://www.sqlite.org/json1.html
Type Parameters
- TName extends string
- TMode extends BlobMode = BlobMode
Parameters
- name: TName
- Optionalconfig: BlobConfig<TMode>
Returns Equal<TMode, "bigint"> extends true
    ? SQLiteBigIntBuilderInitial<TName>
    : Equal<TMode, "buffer"> extends true
        ? SQLiteBlobBufferBuilderInitial<TName>
        : SQLiteBlobJsonBuilderInitial<TName>
- Defined in node_modules/.pnpm/[email protected]_@[email protected]_@[email protected]_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/columns/blob.d.ts:71

Function blob

Returns SQLiteBlobJsonBuilderInitial<"">

Type Parameters

Parameters

Returns Equal<TMode, "bigint"> extends true ? SQLiteBigIntBuilderInitial<""> : Equal<TMode, "buffer"> extends true ? SQLiteBlobBufferBuilderInitial<""> : SQLiteBlobJsonBuilderInitial<"">

Type Parameters

Parameters

Returns Equal<TMode, "bigint"> extends true ? SQLiteBigIntBuilderInitial<TName> : Equal<TMode, "buffer"> extends true ? SQLiteBlobBufferBuilderInitial<TName> : SQLiteBlobJsonBuilderInitial<TName>

Settings

Returns Equal<TMode, "bigint"> extends true
? SQLiteBigIntBuilderInitial<"">
: Equal<TMode, "buffer"> extends true
? SQLiteBlobBufferBuilderInitial<"">
: SQLiteBlobJsonBuilderInitial<"">

Returns Equal<TMode, "bigint"> extends true
? SQLiteBigIntBuilderInitial<TName>
: Equal<TMode, "buffer"> extends true
? SQLiteBlobBufferBuilderInitial<TName>
: SQLiteBlobJsonBuilderInitial<TName>