Json update

Hello, as said in the title I want to update my json column, the code for it:

export const linksTable = pgTable("userLinks", {
  id: text("id").primaryKey(), 
  userId: text("user_id").notNull().references(() => userTable.id),
  links_json: json('user_links').$type<{userLinks: {
    link1: string,
    link2: string,
    link3: string
  }}>()
});

export const linksTable = pgTable("userLinks", {
  id: text("id").primaryKey(), 
  userId: text("user_id").notNull().references(() => userTable.id),
  links_json: json('user_links').$type<{userLinks: {
    link1: string,
    link2: string,
    link3: string
  }}>()
});

I want to update only link1, but when i try to do that I get error telling me that i have to update the whole json so link1,link2,link3. Is there any way to update only link1? Do updating all links will hit my db performance at all?

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Json update