Hello, I'm new to supabase. I'm trying to find out the following. Can the client create a new table in my database? A link would be helpful. I use Ionic and Angular

There is a difference between postgress functions and stored procedures, functions cannot have transactions which is a pretty big limitation see response here https://github.com/supabase/supabase/pull/2897#issuecomment-902006193

Hello new to using supabase and wanted to know if there is a method for

GROUP BY

. I came across

containedBy

but I don't think that's what I'm looking for.

Hello, are there any operation limits for supabase? I tested an app with some load this morning for some seconds, and it appears that my IP is blocked now. At least I can no longer connect to a project. I'm getting a timeout there.

How can I do something like this in supabase-js?

‘SELECT t.id from trucks t where t.id not in (SELECT b.truck from bookings b where not (b.end < end_datetime or b.start > start_datetime))’

don’t know how to do nested queries

Can anyone point me in the right direction to installing pg_cron in my local supabase docker container?

Anyone else try Storage - Upsert and have issues? Inserts work, but I get the following error when trying to replace existing image... "duplicate key value violates unique constraint"

I just used RPC instead ☺️

anyone use the array of json columb for a table? or is it just better to make a new table entirely with a foreign key

i have a table that i keep my lists, and each list has an array of shows (objects) . hope this enough context to help thanks

👋 , I'm trying to encrypt a field when using a trigger, but I get an error when saving, any help? This works

create or replace function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id, email)
  values (new.id, new.email);
  return new;
end;
$$ language plpgsql security definer;

This doesn't work - I get this error

{ message: 'Database error saving new user', status: 500 }

create or replace function public.handle_new_user() 
returns trigger as $$
begin
  insert into public.users (id, email)
  values (new.id, pgp_sym_encrypt(new.email, 'KEY'));
  return new;
end;
$$ language plpgsql security definer;

The only difference is

pgp_sym_encrypt(new.email, 'KEY')

Hello! I'm trying to use the

inviteUserByEmail

method and I'm getting this error:

{
  "message": "User not allowed",
  "status": 401,
}

Any ideas would be appreciated!

User not allowed invite by email

Operarations limit

bytea

upsert

Does anyone know how to install extensions on supabase locally in the docker containerr? I am looking to add pg_cron to test a cron job

Hello! How can I fetch 1000+ rows from a table?

I’m sure this has already been asked but is there any support for using an external auth system?

Anyone run into "Network Request Failed" seems to happen every so often when making calls

Hello friends, has anyone had any luck setting up custom SMTP server, with AMAZON SES? https://github.com/supabase/supabase/discussions/2767

Try changing the Max Rows setting in Settings > API > Settings

Hi all, new to online databases here. is it safe to store the api key in my project publicly?

and the api config url

How to implement custom user roles in JWT, and auth.users ? To write policies like that:

create policy "Only CUSTOM_ROLE can create posts" on posts for
    select using (auth.role() = 'CUSTOM_ROLE');

How to change role column in auth.users ?

is there any roblox to supabase yet?

yes, only your public key [and the url] the other key has admin access so that one you need to keep a secret and use it on a backend service like node etc You need to set up row level policies to setup various custom restrictions i.e allow only the authenticated user to update their own information. Theres lots of info on this in the docs