How do I express this query with the JS SDK?

SELECT * FROM test_products_2 WHERE main_sku = sku

You can't. https://github.com/PostgREST/postgrest/issues/1105 recommendation is a computed column with that condition or view. RPC would also work.

Thanks

how is possible run a LEFT JOIN query with supabase-js?

Im using right now this.supabase.from('channel_messages').select('*,channel_files(*)').eq('channel_id', this.data.channelID) but return me data only if the record is in both tables

Is it possible to select data order by random() ?

I found my answer here https://github.com/supabase/supabase/discussions/2299

any idea why im getting thi

nvm

got it

does anyone knows how do i insert a new worker inside the worker column?

the table name of project there's an worker list does anyone knows how do i add a new worker inside it?

Inserting into a column

I don't think left joins can be done via just JS (yet). You could move your query to a view and then call the view?

When I do a select with the JavaScript library it returns a

data

and a

body

property with exactly the same values in it. What's the reason for this?

I'm trying to drop a row from the Supabase database. Luckily, I was doing this on my local environment because it dropped my whole table 😅

js
rejectEntry: async function(item) {
    let index = this.items.indexOf(item);
    this.items.splice(index, 1);
    const deleteEntry = await supabase
      .from('submissions')
      .delete()
      .match(item.id)
    if (deleteEntry.error) throw deleteEntry.error;
  },

Can anyone suggest what was wrong? I assumed that .match would match the item ID from the table and remove that.

Nevermind, figured it out;

js
const deleteEntry = await supabase
      .from('submissions')
      .delete()
      .eq('id', item.id)

Why did my entire get dropped?

Hi. How can I retrieve data using a JSON key? i try:

const {data, error} = await supabase.from('Cards').select('*').eq('device:device->brand',this.searchDBValue)

or

const {data, error} = await supabase.from('Cards').select('*').eq('device.brand',this.searchDBValue)

My

Cards
.. 
device:{
 brand..
}
..

@Haba Looks like you're pretty close, have a look here: https://supabase.com/docs/reference/javascript/select#querying-json-data Assuming your table looks like this:

sh
# Cards Table

| id      | device                   |
|---------|--------------------------|
| 1       | {"brand":"visa"}         |   
| 2       | {"brand":"mastercard"}   |

Then your data query should look like this

js
// this.searchDBValue = "visa"

const { data, error } = await supabase.from('Cards').select('*').eq("device->brand", this.searchDBValue);

// data = { id : 1, device: "{\"brand\":\"visa\"}" }

Give that a try maybe?

Hello there, I'm looking for example on how to implement ssr auth with nuxt - I couldn't find really helpful doc on SSR auth (agree with @User on this ) @User had the issue some time ago too - dunno if things got a bit clearer ? Do you guy have good ressources / repo example to see how to implement this right ? Thanks !

Hi ! Hi have only one resource to share: https://github.com/supabase/supabase/tree/master/examples/nextjs-with-supabase-auth to understand how it works. But I remember a few things about a working implementation: 1. You can't use the

nuxt-supabase

module or equivalent since you need a server middleware, and nuxt context is not available in it (but you can still inject a supabase client instance from yours) 2. You need a server middleware that works like https://github.com/supabase/supabase/blob/master/examples/nextjs-with-supabase-auth/pages/api/auth.js 3. You need to listen to auth state change using

supabase.auth.onAuthStateChange

I don't remember anything else but this should help you to get started

I think we should write some documentation for ssr auth, or add a working ssr nuxt example

Thanks for the ressources! Gonna give it a try and see if I can make something work out off it. And you are true, at least kind of the same repo example with nuxt should be available - and the documentation should be expended on this!

Hi there. I am new to supabase and i started integrating with my new Next App. I am having a Public table(named X) with auth_id(foreign key connecting with auth users table). I need to retrive the data from both table X and auth users using relation. Anyone can help on it ?

Retrieving data from tables

does anyone know how you would push json into an array in a column while keeping the old json that's already in there? having some trouble with this

Is there a way to run multiple selects on multiple tables with one request? I don't mean related data, completely separate tables

Multiple selects in a single request

I am try to check , if email exists in the data base send magic link to this email. For some reason code not working and i am very new to Supabase, any tips?

// check if email is valid and exists in database (if not, show error) otherwise send magic link

  const [email, setEmail] = React.useState('');

  async function handleSubmit(event) {
    event.preventDefault();
   
    if (email.length > 0 && supabase.auth.user()?.email === email) {
      console.log('send magic link');
      return await supabase.auth.signIn({ email });
    } else {
      console.log('invalid email');
      throw new Error('Email not verified');
    }
  }