Hi all! Quick question: I'm looking into making a Flutter app where couples (preferably anonymous login) can swipe through date ideas to find a 'match', with a free and premium tier (more ideas unlocked) setup via Revenuecat. I'm a novice programmer but I'm really overwhelmed by the many database options out there and was wondering if you guys think this is doable in Supabase? I know all of this is doable in Firebase but I'm scared of the cost ranking up for all the reads and writes this might involve...

Is there a way to make supabase selects accent-insensitive?

Issues with the service?

If I am in my development environment I want supabase to redirect to localhost and on my production website it must redirect to that domain. I have passed

location.origin/auth/login

as my redirectTo parameter in sign in function but it doesnt work and even in my production website it just redirects to localhost

Can Supa base completely replace my Django backend API?

Can anyone help with the local development setup for

studio

app please?

is there some kind of shadow ban or something on authentication? i can't edit any template, or redirect URL or base URL or anything - it always gets reset to the old settings.

Successfully updated settings

-> refresh page -> old settings

Hello, here it's me again. hahaah! I'm building an admin panel, and let's say it's coming in "housing requests" from customers. These requests have a column in their table, called status. It could be like, 'unhandled', 'handeled', 'waiting response' etc. On my front-end I'm making a filter to only show requests with a certain status etc. First question, Should this status column be just a text column? Second. Should I load all request to the react front-side and filter the requests there? Or should I make new requests to the database when the user changes the filter?

I'm running into cors issues, it's working fine on localhost but giving issues on production

Hi, when trying to do

const { data: dataDelete, error: errorDelete } = await supabase
        .from('wa_queue_task')
        .delete()
        .in('id_sec', aIdQueueSent);

It gives me the error: uri too long aIdQueueSent is an array of ids and it's around 500, any alternative? I though about using a RPC but I don't know if I will be in the same problem. How can I know what's the limit of delete?

Hi, Can I get sync data between Bubble and Supabase ? The idea is to have Bubble data into Supabase.

Hi, I can't get realtime and RLS to work together. I'm getting changes when RLS is disabled for the table, but once I enable it, I don't receive any changes

sql
CREATE TABLE realtime_test (
  id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  val varchar
);

-- Set up Realtime!
begin;
  drop publication if exists supabase_realtime;
  create publication supabase_realtime;
commit;
alter publication supabase_realtime
  add table realtime_test;

-- at this point realtime works fine
-- but it stops working when I enable it 
ALTER TABLE realtime_test 
ENABLE ROW LEVEL SECURITY;

create policy "Allow SELECT all" on realtime_test
for select using (true);

js
import { createClient } from '@supabase/supabase-js'
const supabaseUrl = process.env.SUPABASE_URL
const supabaseKey = process.env.ANON_KEY

if (!supabaseKey) {
    throw "ANON_KEY environment variable is missing"
}

const supabase = createClient(supabaseUrl, supabaseKey)
await supabase.auth.signIn({ "email": "...", "password": "..." });
let { data } = await supabase.from("realtime_test").select("*")
console.log(data) // data is fine, meaning RLS rules are correct

const subscription = supabase
    .from('realtime_test')
    .on('*', payload => {
        console.log('Change received!', payload) // It works when RLS is disabled, but not when RLS is enabled
    })
    .subscribe()

Hello ! Is there a way to have a trigger on SignIn ? I would like to show something to users only on their first sign in. For this, I was thinking to add a is_first_sign_in bool to a profile table and change this value with a trigger on sign in

The following upsert code doesn't seem to respect the

onConflict

. It always errors

duplicate key value violates unique constraint "users_pkey"

. I want it to overwrite the existing row with the user's primary key with a new handle. Does anyone see what I'm doing wrong? 🙏

js
await supabase
  .from("users")
  .upsert(
    { 
       handle, 
       id: loggedInUser.id 
     }, 
     { onConflict: "handle" }
   );

it is possible when you send row to a table to get the key who it attributed without fetching the row ?

Anyone ever have the issue where nothing in the Authentication section will save properly? I can't add custom SMTP without it disappearing when I browse away and I can't add OAuth providers, won't hold the information. I am on a Pro plan.

I've come to a problem with dynamic routes in next.js, links to [id].js to show a single request. Is there anyway to pass on the whole id object (like you do in props) with the Link component? Sorry if this is more of a next.js question but, the other solution would be to do two requests to supabase. Because I know the ID, I can get rest of the request object. But then I also want to access another table in supabase, so show housing matches to this request. So, is it possible to do requests to two supabase tables from a single react component?

I'm unable to add a redirect url to my auth settings. Anybody else have trouble with this? For reference, I made a stack overflow question: https://stackoverflow.com/q/73222064/1085736

Does anyone notice stripe cookies

__stripe_mid

and

__stripe_sid

even without using Stripe? I notice it in my Nextjs application as well as in Supabase dev studio (also tried incognito).

So I have been struggling with rls Here is my rls expression

(organization_Id = (select profiles.organization from profiles  where profiles.id = auth.uid()))

This code works for insert but I doesn't work for select. Thanks

I'm getting OAuth errors trying to sign in with Google and Facebook: {"component":"api","error":"400: OAuth state parameter missing","level":"info","method":"GET"} This was working yesterday. Could it be related to the other issue with saving authentication settings? I googled the error and came up with nothing useful... Thanks!

Hello! We're getting a lot of error 524 since today It seems related to cloudflare, does anyone know why this is happening ?

looking for a tutorial or more detailed documentation on querying JSON objects in supabase, specifically JSON arrays. The existing documentation that I found doesn't cover it all and when I try the postgresql documentation I am getting errors like this

Failed to run sql query: function jsonb_array_elements(json) does not exist

Have an issue where I sign up, confirm email, and sign in. Afterwards, in dev console, under Application > Local Storage, I can see the correct access token (I decode it and it contains my email address, etc). When I submit an insert request to Supabase, in the header it only sends the anon token (when I decode it, there's no email address and the role is "anon." Any thoughts/suggestions?

With email/password signup, how long is the confirmation link valid ? AND is there a process for regularly cleaning user entries with out unconfirmed email addresses out of the Users table?

Hi, are supabase edge functions stable? the website says they are experimental until aug 1st

Hi, security wise, when working on local development, it makes more sense to bind the docker ports to 127.0.0.1 rather than 0.0.0.0. Reason being, if one of us are on a public wifi anyone can connect to our supabase,

It would be good if you could give the local development database a different name than the default

postgres

. If I'm working on two projects and I think I have project A docker containers running so I run the migration command but its actually project B that will get blown away because it has the same name

.

helllo, I'm building an admin app that gets requests for housings from a public front-end (through supabase postgres ofc where they are stored). Now I'm thinking, because supabase has realtime. Would it be easy to make an icon glow on the top navigation if there's a new unhandled request? I tested it out a bit yesterday but couldn't really get it working. Can someone please point me in the right direction?