목록PostgreSQL (2)

ReasonJun

postgresql (Supabase) : security definer set search_path = '' (Security Problem)

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..
Backend/Supabase 2024. 8. 6. 15:53
Drizzle ORM - SQL Types

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..
카테고리 없음 2024. 2. 5. 14:27
이전 Prev 1 Next 다음