ReasonJun

Securing PostgreSQL Functions in Supabase: Addressing Search Path VulnerabilitiesIn the world of database management and application development, security is paramount. Recently, while working on a Supabase project utilizing PostgreSQL functions, I encountered a security warning that led us down a path of discovery and improvement. This blog post will walk you through our journey from identifyin..

Integer Signed 4 Bytes => export const testTable = pgTable("testTable", { qty: integer("qty") }) Signed 2 Bytes => export const testTable = pgTable("testTable", { qty: smallint("qty") }) Signed 8 Bytes => export const testTable = pgTable("testTable", { qty: bigint("qty", {mode: "number"}) // {mode: "number"} : 2^31 < number < 2^53 // {mode: "bigint"} : 2^63 < number < 2^63 }) serial serial / ser..