课程: Supabase Essential Training

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

PGSQL functions

PGSQL functions

课程: Supabase Essential Training

开始一个月试用 购买团队方案

PGSQL functions

“

- [Instructor] Supabase supports custom PostgreSQL database functions. These functions are a powerful way of centralizing business logic in your database. Let's take a look at some of the benefits and options available. First, functions are performant. They can be run as remote procedure calls or RPCs directly on the Supabase instance without a separate trip to an app server. Functions are also composable. Functions can call other functions, making it easy to keep similar logic together. They are always run in transactions. If part of the function fails, everything is rolled back. Functions are type-safe. Both the function arguments and the return value have predefined types. If you attempt to call a function with the wrong type, it will fail. Deploying functions is flexible. You can go right to the SQL console and update them immediately, or you can use migrations as a part of a more traditional deployment strategy. There are multiple options for function languages. The most common…

内容