https://supabase.com/ logo
Join Discord
Powered by
# help
  • e

    erik_flywheel

    09/17/2021, 11:02 PM
    Hi everyone, I'm trying to connect Supabase with Bubble (no code web app builder). We need the sql db connection, it should look something like this: mysql://username:password@my-db-instance.endpoint.us-east 1.rds.amazonaws.com:PORT/db_name Any idea what this would be for supabase and if it's possible?
  • e

    erik_flywheel

    09/17/2021, 11:03 PM
    nvm... found it myself!
  • s

    siduck

    09/18/2021, 1:20 AM
    hi guys im trying to add github auth , I get this error
    s
    • 2
    • 49
  • s

    s u s h i

    09/18/2021, 9:20 AM
    hi guys, im just wondering is there a way to query user's auth password?
    s
    • 2
    • 1
  • s

    silentworks

    09/18/2021, 10:01 AM
    Querying user’s auth password
  • s

    silentworks

    09/18/2021, 10:02 AM
    GitHub auth
  • p

    paolotiu

    09/18/2021, 2:42 PM
    Hey! I'm using supabase in a sveltekit app and everything works well, but when doing a query inside a serverless function it suddenly becomes slow (around 7s using
    console.time
    ).
  • p

    paolotiu

    09/18/2021, 2:58 PM
    Nvm I'm stupid, I was selecting all the rows making it return large strings (blog post size).
  • j

    joshcawthorne

    09/18/2021, 5:26 PM
    Am I missing something, or is there no way to update user email through the js lib right now? Tried the following but doesn't seem to work:
    Copy code
    await supabase.auth.update({
      data: {
        email: 'update@email.com'
      },
    });
    s
    • 2
    • 8
  • r

    regisin

    09/18/2021, 5:54 PM
    I'm creating an api (python) that manipulates the tables, but I'm wondering if I can access the auth table as well. More specifically, I'm using FastAPI and SQLAlchemy, but I need an FK to the user in one of the tables. Is that possible or do I need to create using the dashboard?
  • j

    jon.m

    09/18/2021, 8:09 PM
    Has anyone had issues with subscriptions not updating consistently when using something like this
    Copy code
    const messageNotificationsSub = supabase
          .from(`participants:user_id=eq.${user.id}`)
          .on("*", (payload) => {
            console.log(new Date());
            console.log("payload", payload);
    ...
  • j

    jon.m

    09/18/2021, 8:10 PM
    The subscription doesn't catch all updates. If I swap it to
    .from(participants)
    - i get every update. So the issue seems to be the row level filter.
  • e

    eshlox

    09/18/2021, 8:37 PM
    How can I generate a magic link on the backend side? (I would like to use my custom -e-mail template.) Should I use
    supabase.auth.api.generateLink("magiclink", email)
    ? It returns
    { data: null, error: { message: 'User not allowed', status: 401 } }
    🤔
  • m

    murphy

    09/18/2021, 8:52 PM
    Hi, friends! In the documentation for
    upload
    it appears that I should be able to pass an ArrayBuffer , or many other formats to the
    upload
    function. But the typescript types show only an implementation for passing in a
    File
    object. When I pass in an ArrayBuffer, I get an internal server error at runtime:
    {"statusCode":500,"error":"Internal Server Error","message":"Cannot read property 'fields' of undefined"}
  • m

    murphy

    09/18/2021, 8:52 PM
    I'm guessing it couldn't construct a
    FormData
    object or something.
  • m

    murphy

    09/18/2021, 8:53 PM
    (This is React Native, BTW). I've got an ArrayBuffer in memory, and annoyingly, I can't convert it to a File object without writing it back to disk, it seems, because React Native's implementation of Blob can't be constructed from an array buffer 🤦‍♂️
  • m

    murphy

    09/18/2021, 8:54 PM
    I may just do a write/ready from disk for right now, but I'm curious to know if anyone has had experience with this error, or with uploading an ArrayBuffer instead of a File object.
    j
    • 2
    • 12
  • m

    murphy

    09/18/2021, 9:07 PM
    Problems with uploading
  • r

    regisin

    09/18/2021, 10:23 PM
    I'm trying to insert a row in a table using the dashboard. The table has a PK referencing
    auth.users
    , just like the examples. I did not configure any RLS yet (not sure I will!). But I can't figure out how to insert a new row in the DB. It's not like the user.id is anywhere in the dashboard to be seen, is it?
  • j

    jbergius

    09/18/2021, 10:26 PM
    I have a table called subscriptions, which has a column called price_id which is a reference to a id of a price, in a different table called prices. Question: Is it possible to have the price_id column to be an array of price_id's, and still hold a reference but to multiple prices in the price table?
  • t

    tinjaw

    09/18/2021, 11:35 PM
    RE: https://pastebin.com/iTGgd3DA I think this is just a React.js issue, and not specific to Supabase. But I am new-ish to both. When I browse to this page, it renders the
    formation
    object correctly. If I use lodash and grab the first entry, it displays properly. Then the problem occurs. I can change the page in dev mode and reference
    .choiceFlag
    or
    .choice
    if the page in the browser is not refreshed. But if I refresh the page, I cannot reference either. I don't know where to start. My guess is finding out from you folks, how to add config stuff to get absolutely no caching going on here first.
  • t

    tinjaw

    09/18/2021, 11:39 PM
    Here is what I get with that code, as is
  • t

    tinjaw

    09/18/2021, 11:52 PM
    Changing the code to https://pastebin.com/QBBJyrsA results in
    Copy code
    [{"id":1,"choice":"Linear Formation","result":"The linear formation ensured simple coordination between units and a uniform advance. However, the pace proved slow, allowing the maximum effects from German fires, and decoupling our infantry from our barrage.","penetration_effectd":0,"casualties_effect":4,"choiceFlag":"linearFormation"},{"id":2,"choice":"Column Formation","result":"Your assault columns proved easily controlled and made fast progress across No-Man's Land, taking advantage of gaps in wire obstacles. However, in many cases the narrow advance sectors were easily stopped by single machine guns and proved vulnerable to flanking fires from German troops and artillery.","penetration_effectd":1,"casualties_effect":3,"choiceFlag":"columnFormation"},{"id":3,"choice":"Rushes (Fire and Movement)","result":"Utilizing rushes minimized casualties and enabled units to take advantage of local suppressing fires. However, your newly-formed units were not sufficiently trained to be able to make good use of this technique, causing the attack to break down.","penetration_effectd":-4,"casualties_effect":-6,"choiceFlag":"rushes"}]
  • j

    jon.m

    09/19/2021, 1:13 AM
    What are you trying to accomplish
  • d

    Daniel

    09/19/2021, 4:55 AM
    Do you guys know what is the different between
    single
    and
    maybeSingle
    ? for example:
  • d

    Daniel

    09/19/2021, 4:56 AM
    Copy code
    final response = await Supabase.instance.client
              .from('customer')
              .select('*')
              .eq('account_id',accountId)
              .maybeSingle()
              .execute();
  • d

    Daniel

    09/19/2021, 4:56 AM
    and
  • d

    Daniel

    09/19/2021, 4:56 AM
    ``final response = await Supabase.instance.client .from('customer') .select('*') .eq('account_id',accountId) .single() .execute();`
  • d

    Daniel

    09/19/2021, 4:56 AM
    i am getting the same result but not sure what is the real different ? Thank you.
  • j

    jbergius

    09/19/2021, 5:33 AM
    I started building an app with next, supabase and stripe from the official starter. But that doesn’t support a subscription having multiple prices connected to them. Which is what I want. And I was hoping to find an easy way there that didn’t include having to restructure so much.
1...909192...316Latest