Join tables query

With Supabase Realtime I noticed that the object reflecting the change has all of the fields available under the "new" property, but under the "old" property it only shows the primary key. Is it possible to configure the "old" property to return more fields? This would be good to be able to compare old and new fields without having to do another lookup.

I was able to find that the table must have replica identity full to return all the rows.

is anyone using

react-supabase

or

use-supabase

?

Hi all i was wondering if there is a way on react/react-native to check when the jwt token/session expires and if there is an event supabase may raise?

hello, i removed import but im not sure why it still isn't working? could you please take a look

Hi Scott, this only handles token refresh but doesn't listen to Token Expired specifically. I have to do really weird logic in order sign out

cdn supabase

Hi all. New to Supabase, and working in a Svelte site. Maybe a silly question, but I can't find much online. I have a database table with 1 row in it. When I use the client as they explain in the documentation, I can see the hit to the API, and it returns a 200, but it is an empty array. I've tried just returning all rows, i.e. no user_id filter or anything, and I get the same. The code is below if that helps.

let { data: parameters, error, status } = await supabase
        .from('parameters')
        .select(`*`)
        .eq('user_id', user.id);

Any help as to what I am missing here? Hitting the API directly via Postman does not return the single record either. Thanks.

200 with no data on select

did you solve your problem? having the same issue

can anyone help? trying to use subscription in vanilla nodejs, status is subscribed and replication is enabled for all tables, subscription status is subscribed but i don't get any updates

supabase
    .from("*")
    .on("*", (payload) => {
      console.log("change", payload)
    })
    .subscribe(console.log)
    .onError((e) => console.log("error", e))

realtime node.js

I just gave up and spun up a local redis instance 😦 I was also using prisma and ran all the generated migrations manually.

Hi guys, Given the following select

select(
`
    *,
    votesCount:votes(count)
  `)

where i get the count of a relational table

votes

. Do you know if it is possible to order my result based on

votesCount

? something like this

order('votesCount', { ascending: false })

(not working) I have also tried

order('count', { ascending: false, foreignTable: 'votesCount' })

(the query is working but northing is ordered)

Hey there I'm having issues where I query the db and the data is coming back as an anonymous array

Not sure what you are saying is the issue. data is an array back from Supabase select whether 0,1 or more items.

Query returning anonymous array

Hey all! I'm looking for a way to run a search against a jsonb column, anyone know how to do this? My code so far:

await supabase.from("posts").select("*").textSearch("title, description, info", searchValues)

The issue is that

info

is a jsonb column and the returned results do not match on any of the strings in that column, anyone know how I can achieve this? Specifically, I want to match on the values, not the keys. So for example, info might have an object like:

{ topic: "postgres" }

and I'd like for this row to be returned if the provided

searchValues

string contains

"postgres"

I've been reading about how to create another column on the table that is a concatenation of other columns to run text search against that column, but so far haven't been able to figure out the syntax to do this with a jsonb column, but I was able to create one from other column types be it text or enum, for example, open to a solution like that as well. Thanks in advance!

Hi everyone, does anyone know if it is possible to send data to the invite email template when using inviteUserByEmail (https://supabase.com/docs/reference/javascript/auth-api-inviteuserbyemail)? If so how do I access the variables in the template on supabase? Already tried to pass it via the options/data, but can't get it to work. Thanks!

Sending data in invite email

Is there anyway that when a user clicks on their verify link, to either open or redirect back into the same tab, thats already open on a page?

Redirect to existing tab when verify link is clicked

gm

would anyone around have any insight into grabbing web3 wallet address and pushing it to supabase user account (essentially creating login/validate login with web3/metamask)? trying to do a simple web3 login capturing the walletaddress for each user and storing them in supabase rather than say email address. building in react-app

Not sure this is the level you are thinking about but some work in that area going on (if you mean a true web3 login process): https://github.com/supabase/gotrue/pull/282

sick! im thinking of the full monty level. using web3 wallets for "oauth" type logins.. and then validating off of the wallet addresses.. then making things "signable" for different actions on a page (signing with wallet to validate a form or to update a database) such that the signing is both written to the wallet and also stored maybe as a timestamped key in the base. Nice. i will take a look. thank you so much, I thought maybe I was talking to a crowd who hadn

t really thought about this

is there anything I should know as fundamental baselines when looking to build on this plugin? Haven't really done anything like this before. I assume it will be a plugin / addon and hopefully integrated into the app in the future. since web3 is the future