3 replies

A way to use the update function with existing value in json blob column?

Hi there. I found this almost exact questions already asked but I don't get how I can do that.
I have the following in SQLite using Turso db

export const someTable = sqliteTable("some", {
id:text("id").primaryKey().notNull(),
images: blob("images", { mode: "json" }).$type<string[]>().notNull(),
prompt: text("prompt"),
others: ...
});

export const someTable = sqliteTable("some", {
id:text("id").primaryKey().notNull(),
images: blob("images", { mode: "json" }).$type<string[]>().notNull(),
prompt: text("prompt"),
others: ...
});

export const someTable = sqliteTable("some", {
id:text("id").primaryKey().notNull(),
images: blob("images", { mode: "json" }).$type<string[]>().notNull(),
prompt: text("prompt"),
others: ...
});

export const someTable = sqliteTable("some", {
id:text("id").primaryKey().notNull(),
images: blob("images", { mode: "json" }).$type<string[]>().notNull(),
prompt: text("prompt"),
others: ...
});

What I would like to do is have a way for putting more images into blob.
so basically an array where i push more inputs but in json I guess or is there a better suited type ?

A way to use the update function with existing value in json blob column?

Similar Threads

Similar Threads

Similar Threads