Firebase versus Supabase realtime

Hello everyone, I have a table called

sources

which has a column

sourceAddresses

of type

jsonb[]

of the following structure:

[
  {
    "address": "0xsomething1",
    "type": "SOME_PROPERTY_1"
  },
  {
    "address": "0xsomething2",
    "type": "SOME_PROPERTY_2"
  }
]

I want to check for a row in which the array in the column sourcesAddresses contains a certain source, identified by the

address

property. I tried to implement the code:

const { data, error } = await supabase
        .from("sources")
        .select("*")
        .contains("address:sourceContractAddresses->>address", contractAddress);

Unfortunately it returns

null

Can someone please guide me?

@copple can you please help? We are stuck on this basic thing for a while, must be missing something obvious. Appreciate the help in the time-sensitive issue.

Hi! I'm using

@supbase/supabase-js

and trying to use the

redirectTo

on

signUp

and it's not working. I'm not sure I understand why:

const {
          error: e,
          user,
          session,
        } = await supabase.auth.signUp(
          { email, password },
          { redirectTo: 'http://localhost:3000/access' }
        );

I have this URL added in my Auth settings as well.

Query against a jsonb array

I think the redirectTo URL has be defined in the supabase settings as well - I had the same question a couple of weeks ago, but I can't remember 🙈

Is it possible that postgres uses

snake_case

and from postgrest onwards I can receive

camelCase

? I'm migrating a huge website/app and we are coming from firestore / firebase and everything is based on

camelCase

but as far as I know, postgres works best with snake case due to various reasons

If i am inserting/upserting with a default primary key

do I want to leave it out of the object, or assign it to null

Using supabase-js

Default value on a column = the value that will be set if not provided when updating or inserting a record

appreciate it

Thanks, i’ve defined it there as well, and no luck 😩

how do I do a text search in JS like this:

How would I concat the columns in the textSearch function?

I don’t understand how to use the real-time subscription in react. I copied the examples from the docs into a function that gets called in useEffect. It doesn’t seem to be using the callback.

React realtime

hey team, just want to ask if anyone has any good learning material for implementing google oauth with supabase on reactjs? i have no idea where to start. would love to find an example that has something end to end. thank you

Help with real-time subscription in React

Real-time and react

Hello, what's a good way to way to implement realtime subscriber with React ? I'm using on the useEffect with cleanup once the component is removed from the dom, sometimes it works sometimes it fails to change the state. Any docs & tips ? I can see the payload coming in on the websocket from the [network] tab, but the code isn't updating nor do something..

Realtime cold start?

I'm wondering how I can apply filters to a subscription? For example, I'd like to subscribe to the users profile and not to all profiles at once

Are subscriptions all or nothing?

ok, I missed the last part - thank you! // edit: works perfectly 👌

How do you authenticate a user on your server via the auth token? Couldnt find this in the docs.

There is the doc : https://supabase.com/docs/reference/javascript/auth-api-getuser

Is there a way to redirect on the index page when you're not logged in? (using Next.js and getServerSideProps). I can manage to make it work for any page apart from the index page. When I reach getServerSideProps the token is not there yet causing the a redirect back to /login and thus breaking my login flow.