Hi all, I'm trying svelte+capaitor+supabase. So far everything is excellent, however I'm having difficulty with the google provider signin on android. ### successes On my web app, the following code redirects to google and then back again. All is good. ### fails On the Android it opens up a browser tab (left my app) and redirects to the web app still in the browser and my app remain without being signed in. Can anyone point my in the right direction for my app not to open a web browser and instead remain in the capacitor app.

javascript
const { user, session, error } = await supabase.auth.signIn({provider: 'google'});

Kind regards, Joe

I've seen a couple of discussions on it. Most recommend using a webpage for landing and then redirecting with a "deep link" to your app. https://github.com/supabase/supabase/discussions/7093 I have a similar problem with my webapp in that the return opens a new window. I've gone with the otp token approach for confirmation, where they get the email and just copy the code back over to the app.

thanks! I'll take a look

Any examples of what that might look like?

Adding to an array

anyone know any good tutorials or examples to implement Supabase with next.js

Have you looked thru any of these (from a google search) ?

Hi all, I have used a third party provider to log in (@codetrix-studio/capacitor-google-auth). Is it possible to sign the user into supabase using the given response:

json
{
    "email": "my@email.com",
    "familyName": "Surname",
    "givenName": "Firstname",
    "id": "xxxx",
    "imageUrl": "https://lh3.googleusercontent.com/a-/blahblah=s96-c",
    "name": "Full Name",
    "authentication": {
        "accessToken": "xxxx",
        "idToken": "xxxx",
        "refreshToken": ""
    },
    "serverAuthCode": "xxxx"
}

Many thanks in advance!

Hi Guys, I turned on real time updates for my tables but when i make a post request it does not update instantly

You will need to provide more info on your environment, what you have tried, etc. Please start a thread if you reply. Also "does not update instantly" ... does that mean it does update, just you are not happy with the timeframe?

You will need to provide more info on

What would be the best way to sync a countdown via supabase

I am trying to set up a webhook using supabase functions but it does not allow to set

Authorization

headers. Is it possible to trigger a supabase function with out defining it ?

I recommend you add more info in a thread here if a JS question, or move to general/sql depending on what you are asking. SB functions these days is unclear. A Postgres function (maybe called by rpc)? An SB Edge function? Not clear if trigger means a Postgres trigger or just a call. Then how would you use a function without defining it?

Hello... trying to reference the auth users table via a field called 'owner' in the query below..

js
const { data, error } = await supabase
  .from('Comments')
  .select(`id, owner:users(id,email)`)
  .eq('post_id', params.id);

I keep receiving an error

Could not find a relationship between 'Comments' and 'users' in the schema cache

I'm not really sure why as it appears I've setup the foreign key correctly. Any suggestions are appreciated

hello, I'm trying to subscribe to my database changes in realtime. however, it doesn't seem to work. I'm using a useRef hook in my Next app to subscribe to database changes, however, I'm not able to subscribe to the table for some reason. Here's my useEffect hook

javascript
useEffect(() => {
    let gameListener = supabase
      .from("games")
      .on("*", (payload) => {
        console.log("PAYLOAD", payload.new);
      })
      .subscribe();

    const subscriptions = supabase.getSubscriptions();
    console.log("SUBS", subscriptions);

    return () => {
      supabase.removeSubscription(gameListener);
    };
  }, []);

here are some potentially useful screenshots to help

Hi does anyone can help on how can I query using the postgist extension ?

Hi all, I am returning to my signing with provider on android and have reverted back to using the supabase provided signup flow. The android signing with provider:google opens a browser window, that I am now providing a return url of "myApp://user" using deep links which works well. However, it leaves a browser tab open of the google signing page. I guess I could complete the login on the web app and then forward to the android app forwarding a refresh token, however this would still leave a browser tab open. I am wondering if this is a secure method or if there is a better suggestion. I have tried a 3rd party signing which works on both the web app and the android, but I couldn't find how to use the response to sign in to supabase with the details provided, so I abandoned this route. Thanks so much in advance for any pointers. Kind regards, Joe

realtime next

Real Time Subscription Not Working With React

what could be the reason that it logs before user, session, and/or error are defined (the user goes through with the provider sign in)

The process is going to come back to your redirectTo/home page unless signIn returns an error.

then I guess I have some sort of anomaly

No, signIn still returns, the code after will run until the process calls your page again.

so I theoretically should see it logged twice?

once before the auth and once after?

Belated reply to this Gary: yes, this actually worked perfectly. Thanks for the help!

Is it possible to get realtime changes on Views or is that not a thing?

No

Is there any way to call supabase when the page is closing in NextJS?