Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Using the Supabase dashboard, I created a function using the following configuration:

**return type:** record

**Arguments**
email - text
password - text
acctkey - text
updatedat int8

**Definition**

`begin
insert into public.Users(email, password, acctKey, updatedAt)
values (email, crypt(password, gen_salt('bf')), acctkey, updatedat) returning id, password;
end;`

**Advanced Settings**
Language: ** plpgsql**

Type of security: **Security Definer**

Calling the function:

`let {data, error } = await supabaseClient.rpc('function_one', {
'email': 'john@example.com',
'password': 'mypass',
'acctkey':'key1',
'updatedat': Date.now()
});`

I enabled `PLPGSQL`, `AUTOINC`, and  `PGCRYPTO` on Extensions page.