did you check twilio.com ? They are strong in SMS and messaging in general

Hmm, I didn’t think to use them for chat. My mind just goes to SMS or Email

Good point though

Quick question: is it possible to send back custom error messages to the client if rls prevents an action?

off the top ideas: what status code does RLS deny access return? can you use a client side hook attached to this status code to show a custom message? do you need different error messages for each role / specific role / deny pairings? would developing "middleware" query / functions using supabase functions (either db or edge) provide the specificity you need to send custom error messages?

It's passing a 500 code. Honestly I'm just catching the error client-side and if someone really wants to try and send requests without it they can deal with the non-descriptive error lol

hey know your needs / use cases. sounds legit

thanks 🙂

Signal

will edge function available for nodejs?

Hi all, just picked up Supabase for a project and I have a noob question ––  I have a table

conversations

with column

participants

of type JSONB (originally JSON but I think it needs to be JSONB) where the structure is something like:

[
  "Emily",
  "Renee",
  "Martina"
]

I'm trying to return an array of all

conversations

where

participants

includes the current user, e.g. "Emily". This is what I've tried, but I'm certain this is wrong:

let { data, error, status } = await supabase
    .from('conversations')
    .select('id, name, participants')
    .contains('participants', ['Emily']);

Any pointers? Or should my data be structured differently? (Future state,

participants

might be more like

[ { name: 'Emily', id: 123 } ]

but for right now I'm just trying to sorta learn the basics The error I'm getting with this is "invalid input syntax for type json"

@here can we merge this PR https://github.com/supabase/supabase-js/pull/415 ?

hey anyone has any idea i long it takes to hear back from supabase store purchase?

i had this purchase from supabase store (29 Mar) of tee and i got a message in my mobile about it but that view order page redirects me to 404 page at supabase

When user has previously signed-in. and tries to signs in again. There is no error reported. Just success! How do we handle this scenario?

store time frame

✋ Is there a way to link a database row directly to a storage bucket.. so I can select the files from a list. Right now, I'm using a

text

field and copying and pasting the file paths to the database.

Anyone having problems logging into platform? Non functional for me.

Is it possible to make an user

and not auto login

Does anyone have a table plus license? The description confuses me... Like is this -2 devices -4 TablePlus for iOS supposed to mean I can use it on 4 ios devices and 2 devices of my own choice?

Is it possible to generate a service key that only has access to say only the storage service and also only with insert (no update/delete) permissions? Posting here, because this is more of a question regarding a feature than it is about help

Hey all, we're evaluating Supabase at my work and I really want it to be the thing we use, but I have a couple questions: 1. Can we turn on social login for a subset of users? 2. How hard is it to add a custom IDP. I love the support for all the existing ones, but many of our customers want to do SSO from their systems. Thanks!

Oh wait, I see on two that you support SAML. Okay, plz ignore that question, sorry!

When do the new gotrue relases propagate to hosted supabase instances?

Hey all we re evaluating Supabase at my

Hi all. I was wondering if there is any way to do database migrations with supabase? I’m not sure if that’s the proper term, but I’d really like to be able to define my database schemas in some sort of text format, and then apply it to the database in a controlled way.

I would like it to be able to be run automatically from a CI/CD pipeline. I’m new to Postgres and none of the tools I’m used to seem to work here

So any input would be greatly appreciated!

I am very new to supabase I have primarily worked with firebase and I’m tired of having to connect my card for everything so I searched around and I was looking at appwrite and then in comments I was suggested supabase and I actually find it cool and the fixed monthly fee is so good the pay as you go model for firebase I hated it because one bug could ruin everything I have few questions but I’ll start with Does supabase have read write costs or how does it work and what data types can you put