Tag archive
Complete guide to Postgres functions and triggers in Supabase. Learn PL/pgSQL, automated workflows, business logic, and database-level validation patterns.
Photo by Josh Campbell on DEV.to
Buy Me a Coffee☕ DO statement: can have zero or more queries with BEGIN ... END...
Buy Me a Coffee☕ A trigger: can run the PL/pgSQL trigger function in the database. *A SQL trigger...
Unveiling the Disparity: Understanding the Divide Between Direct Driver and ORM...
A database can perform at best if it's processing has the lowest possible latency for execution of...
In this blog post I'll show that static SQL within PL/pgSQL blocks are automatically prepared but...