Firstly, are you receiving any of the logs? Is there a specific reason you're using the realtime-js lib over the supabase-js lib? For example, this

update

example I use in a prod environment without a problem:

js
SupabaseClient.from(`my_table:my_column=eq.some_value`)
  .on("UPDATE", (payload) => {
    console.log("🔥 Received update via subscription from Supabase");
  })
  .subscribe(result => {
    if (result !== "SUBSCRIBED") {
      console.log(`❌ Error subscribing: ${result}.`);
    } else {
      console.log(`🔥 Opened subscription`);
    }
  });

Realtime subscriptions

Just curious, is anyone in production with supabase + sveltekit?

Honestly, I'm not going to use sveltekit for now because it's still in beta

It's so much less code than react which is very appealing lol

Is it possible to just return the row count from a query, without fetching all the records?

EG I need to count all messages whose content contains a string, and is between two dates. Do I need to use an RPC for that?

Nevermind found it in the docs

https://supabase.io/docs/postgrest/client/select. Use head option on select

Thanks 🙏

I'm trying to call an RPC from JS like this:

javascript
supabase
  .rpc("getEmptyStats", {
    guild: guild,
    startDates: startDates,
    endDates: endDates,
    dateCount: startDates.length,
  })
  .then((data, error) => {
    console.log(data);
    console.log(error);
  });

The RPC returns an array of ints for some stats queries, however I'm having troubles calling the function and getting this error:

bash
{
  error: {
    hint: 'No function matches the given name and argument types. You might need to add explicit type casts.',
    details: null,
    code: '42883',
    message: 'function public.getEmptyStats(dateCount => text, endDates => text, guild => text, startDates => text) does not exist'
  },
  data: null,
  count: null,
  status: 404,
  statusText: 'Not Found',
  body: null
}

Is there a way to typecast this in JS? Or do I need to do it in SQL.

Also the

startDates

and

endDates

variables are arrays, but look like they're being interpreted as strings when passed to the RPC function, can I pass arrays to the function? Or do I need to send a CSV string and parse it in SQL or something like that

The RPC is defined like this:

sql
FUNCTION public.getEmptyStats(guild int8, startDates timestamp[], endDates timestamp[], dateCount int)

Hey guys! If you could check out and provide your input would be great! https://www.reddit.com/r/sveltejs/comments/ov4yc3/questions_on_sveltekit_and_supabase/

Hello, I was looking for learning supabase lately, and downloaded the react todo list and I have a question about a line in the code App.js

js
    useEffect(() => {
        const session = supabase.auth.session();
        setUser(session?.user ?? null);

        const { data: authListener } = supabase.auth.onAuthStateChange(
            async (event, session) => {
                const currentUser = session?.user;
                setUser(currentUser ?? null);
            }
        );

        return () => {
            authListener?.unsubscribe();
        };
    }, [user]);

so what does

??

mean in

setUser(session?.user ?? null)

its called nullish coallessing

I will replace

session?.user

with

user

to make it simple for you.

user ?? null

, is equivalent to:

js
if (user == null){
return null;
// Which is redundant because user is already null
// Recommended: return 'user' instead
} else {
return user;
}

The code above doesn't make much sense because it was used wrongly. It should generally be used like this in an example:

total_likes ?? 0

, which can be translated to:

js
if (total_likes == null){
return 0;
} else {
return total_likes;
}

^^

aha so

user ??

=

if (user == null)

and

null

after

??

is to return null if user is equal to null ?

Sorry, I updated my answer to clarify the issue.

yeah I saw it, thanks! thanks for letting me know cause I think I'll be using

??

a lot

It's short-hand for a common use case, so it's perfectly fine to use it instead of the traditional way 😁

Hey everyone. I'm stumbling my way through learning vuex with supabase, and struggling to figure out how to log a user out. I was told I would need some type of clear_state for my store, but I'm not sure how that works. So far I've tried

javascript
  logUserOut() {
      supabase.auth.signOut();
      this.$router.push("/");
    },

This is my current store:

javascript
 state: {
    userInformation: null,
    loggingIn: false,
  },
  mutations: {
    login(state, payload) {
      state.userInformation = payload;
    },
    attemptLogin(state) {
      state.loggingIn = true;
    },
    finishAttemptLogin(state) {
      state.loggingIn = false;
    },
    session(state) {
      state.session = true;
    },
  },

So I'm guessing something like

javascript
 CLEAR_STATE(state) {
      state.session = false;
    },

?

Any help would be appreciated. Thanks!

Have you try with store action:

js
state:{...},
mutations:{...},
actions: {
  async logout({ commit }) {
    const { error } = await supabase.auth.signOut();
    if (!error) {
      commit('clear_user') // clear user/session information

      // import from router
      router.replace('/')
    }
  }
}

as a general rule, in vuex, everything that is a simple state change and is sync you use a mutation, for more complex things, like updating several parts of your store or doing any async work, you use actions

Does the js libs work with deno and typescript?

Haha found it sorry 😄

Wait no this is not what i was searching for