RayDay
RayDay
PostsComments
DTDrizzle Team
Created by RayDay on 2/27/2024 in #help
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: ...
});
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 ?
4 replies