https://supabase.com/ logo
Join DiscordCommunities
Powered by
# javascript
  • h
    and here is my profiles table if it ever is useful in any way
  • h
    here is the code I use to fetch the data :
    Copy code
    javascript
async function queryDatabase(){
        const { data, error } = await supabase
              .from('posts')
              .select()

        console.log(data)
    }
  • h
    And the only posts logged are the public ones.
  • h
    I get the exact same result when trying on a session where the user is not logged in.
  • i
    my app is at https://windows99dev.vercel.app/experiments/login, and for some reason it says that createClient is not an export. Do you know why this is?
  • g
    I looked at your code, and had already answered on github to your question.... you don't import, you do var supabase = supabase.createClient(SUPABASE_URL, SUPABASE_KEY) with the cdn download.
  • n
    anyone else experiencing realtime updates running twice?
  • n
    Like its running twice when something is added to the table
  • u
    Hi I am trying to modify the next.js stripe subscription example to work with single payments to create a more traditional ecommerce site. I was able to get each stripe checkout session into supabase, but am having trouble getting the individual items within each checkout session. From reading the api docs I need to make an API call in the webhook handle to retrieve the Checkout Session object, passing the expand parameter to include the line_items field. I am stuck here and would appreciate any help I can get. Thanks! Webhook:
    Copy code
    case 'checkout.session.completed':
            const checkoutSession = event.data
              .object as Stripe.Checkout.Session;
            await upsertOrderRecord(event.data.object as Stripe.Checkout.Session, checkoutSession.customer as string,);
            break;
    useDatabase `const upsertOrderRecord = async (session: Stripe.Checkout.Session, customerId: string) => { const { data: customerData, error: noCustomerError } = await supabaseAdmin .from('customers') .select('id') .eq('stripe_customer_id', customerId) .single(); if (noCustomerError) throw noCustomerError; const { id: uuid } = customerData || {}; const sessionData: Session = { id: session.id, amount_total: session.amount_total ?? undefined, user_id: uuid ?? undefined }; const { error } = await supabaseAdmin.from('orders').insert([sessionData], { upsert: true }); if (error) throw error; console.log(
    Product inserted/updated: ${session.id}
    ); };`
  • r
    Hey guys, struggling with something hope to find some help here. I want to update my table with a key-value pair object which I have got as input from the user. I'm matching it with the original values that are there in the Table. I keep getting 404 Error. Is this happening cause supabase doesn't support it yet? (RLS is disabled for now)
    Copy code
    const { data, error } = await supabase
      .from("company")
      .update([inputFields.values])
      .match([originalFields.values]);
  };
    This is what inputFields.values / originalFields.values look like
    Copy code
    {
  "name": "Piramal Glassed",
  "email": "piramal@glass.com",
  "contact": "98203"
}
    g
    • 2
    • 57
  • m
    Question: When doing a bulk insert https://supabase.com/docs/reference/javascript/insert#bulk-create is it guaranteed that the response array in 
    data
    will always be in the same order as the original insert data? Eg:
    Copy code
    const { data, error } = await supabase.from("table").insert([{name: 'a'}, {name: 'b'}, {name: 'c'}])
console.log(data)
// data: {data: [{id: 1, name: 'a'}, {id: 2, name: 'b'}, {id: 3, name: 'c'}]}
    s
    • 2
    • 2
  • r
    i'm not trying to do a bulk insert. I'm trying to insert only one row in the table. The row itself has around 10 columns, which are in the same order yes because I am reading them from supabase itself.
  • g
    404 error on match update
  • u
    hey all, looking for some help on auth stuff. I'm following a relatively standard flow for signups that uses google, FB, or magic link.
  • u
    s
    • 2
    • 19
  • u
    my issue -- when a user signs up, I take them to a new page where they can then configure some of these details
  • u
    leading to a race condition -- sometimes the profile i'm fetching 401s as the DB trigger hasn't completed yet
  • u
    Copy code
    ts
    const { error } = await supabase.auth.signIn(
      { provider: 'google', },
      { redirectTo: `${REDIRECT_URL_BASE}/next-steps`,}
    )
  • u
    and then 
    /next-steps
    fetches profile
  • u
    i suppose i could implement polling on 
    /next-steps
    but that's a heck of a hack
  • s
    Trigger not completed before signup is done
  • v
    Hey, to get any of the subscribers from the current eventm would this query work? I am getting 0 responses even though there should be 1
    Copy code
    js
      const allSubscriptions = await this.supabase
        .from<DiscordChannelSubscription>("discordChannelEventSubscriptions")
        .select("*")
        .or(`worldIdFilter.is.null,worldIdFilter.eq.${event.new.locationId}`)
        .or(`teamIdFilter.is.null,teamIdFilter.eq.${event.new.organizerId}`)
  • r
    I'm trying to use the realtime subscription in a node program and can't seem to get events for one of my tables. The switch is on for all of my tables. I see subscriptions for all of my tables in the realtime 
    subscription
    table, but getting nothing when I do inserts to one of them.
    Copy code
    ts
  supabase
    .from("*")
    .on("*", (payload) => {
      console.log("Change received!", payload);
    })
    .subscribe();
  • r
    RLS is enabled for all my tables, I'm using the 
    service_role
    to connect
  • d
    error while using function
  • d
    can anyone help me from this issue?
  • s
    bulk insert order
  • y
    Hey all, quick Q about joins and such. I have 3 tables: 
    users
    , 
    groups
    and 
    groups_users
    . The last one is a table containing `userId`/`groupId` links, to join between them. What would be the ideal queries to get "All users of group `i`" and "All groups of user `j`"?
    s
    • 2
    • 8
  • j
    Hey guys, I have a table 
    posts
    with a 
    user_id
    foreign key to 
    auth.users.id
    and I'm trying to query the user info like this :
    Copy code
    js
supabase.from('posts').select('*, users(*)')
    but I'm getting this error "Could not find a relationship between 'posts' and 'users' in the schema cache"
    s
    • 2
    • 15
  • p
    Hi everyone, I played around with remix and supabase. I had an issue with updating data when using RLS. The 
    superbase.auth.session
    was always 
    null
    so the anon key was used on requests and updates where not applied (response 
    404
    ). For now, I use a workaround: set 
    access_token
    with the result of 
    strategy.checkSession
    (https://github.com/mint-vernetzt/remix-supabase-test/commit/ae4eb834fcd10ca9aa5d3863fa3846fd4126e05a). I don't know, if it's the best solution, but maybe it helps others.
1...484950...81Latest