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

    thestepafter

    06/28/2022, 12:14 AM
    I am considering switching my project to use Supabase but I need to be able to connect from PostgreSQL to remote database to query for data. For example, MySQL. Do Supabase PostgreSQL databases support the extension(s) for doing so?
    n
    g
    • 3
    • 11
  • j

    jvocodes

    06/28/2022, 12:56 AM
    Is there a way to get session info after a signup using
    Copy code
    supabase.auth.api.createUser()
    n
    g
    +2
    • 5
    • 40
  • m

    mattdeere

    06/28/2022, 4:40 AM
    Is there a way to read a random line with the supabase API?
    n
    j
    • 3
    • 20
  • i

    imousart

    06/28/2022, 4:41 AM
    did any one know why i cant acsses objects inside array ?
    n
    j
    • 3
    • 5
  • n

    Nilu

    06/28/2022, 7:11 AM
    Can't seem to edit or delete rows via UI anymore, was able to yesterday
    n
    j
    • 3
    • 19
  • c

    ChrisPBacon

    06/28/2022, 8:36 AM
    Hoping someone can confirm what I'm experiencing is working as intended: 1) User clicks on reset password which uses the email recovery function
    Copy code
    let { data, error } = await supabase.auth.api.resetPasswordForEmail(email)
    2) After the link in the email is clicked I should be redirecting the user to an update password form (yet to be implemented) 3) At this point though, without updating the password, I can still sign in with the old password. Will the old password still function since the old one hasn't been changed despite the user clicking the reset password link from the email?
    n
    s
    • 3
    • 3
  • l

    LEGEND

    06/28/2022, 9:42 AM
    any one know how to add array foreinkeys in supabase
    n
    o
    • 3
    • 4
  • r

    Revxrsal

    06/28/2022, 9:50 AM
    o/ question is there any way to run code when a row in a table is created?
    n
    s
    j
    • 4
    • 9
  • e

    Evostance

    06/28/2022, 10:13 AM
    Hey. If I have a jsonb field in my table, is it possible to do an
    update
    on it that will only update existing fields or add new ones? I want it to act as a PATCH rather than a PUT
    n
    j
    • 3
    • 9
  • j

    jacasch

    06/28/2022, 10:25 AM
    How can I add more custom External Authentication Providers? im intrested in Steam, Nintendo, Epic, Play Station Network and Xbox
    n
    j
    • 3
    • 5
  • j

    jaitaiwan

    06/28/2022, 10:31 AM
    Hey folks, does the supabase-js have a way to call edge functions built-in?
    n
    s
    • 3
    • 3
  • s

    Sneha Singh

    06/28/2022, 10:54 AM
    How to add Supabase database into Google Data Studio's data source?
    n
    s
    • 3
    • 8
  • d

    Dembe

    06/28/2022, 12:52 PM
    Hi, how can i prevent so only I can login? With email magic link? I tried with my other email and it got an email aswell. I will go into authentication where I have my user already, and if that matches or something with the email then send magic link otherwise you will not be able to login, or signup. defenitly not signup.
    n
    s
    • 3
    • 2
  • c

    ChrisPBacon

    06/28/2022, 1:02 PM
    When I click on forgot password, the recovery token is populated in the auth.users table for the respective row. And then when you click the email link, that token ID is the refresh token found in the URL of the redirect and is also removed from the auth.users row. My logic is that I verify the access token against my JWT secret and then that the type=recovery and also check whether the user types the same password twice. But what use is the refresh token? I've been trying to research what it's for and how I use it but I'm not finding many answers. Any leads on where I can learn more?
    n
    g
    • 3
    • 5
  • n

    NARCISO

    06/28/2022, 1:03 PM
    Hi everyone, is there a way to execute
    supabase db reset
    BUT on the Remote DB?
    n
    j
    • 3
    • 10
  • j

    jackjackk

    06/28/2022, 3:23 PM
    is it possible/suggested/safer to change SERVICE_KEY and ANON_KEY in the supabase/cli? if so, how can one generate new ones? they seem to be hardcoded in the go source code
    n
    s
    • 3
    • 2
  • k

    Kelaos

    06/28/2022, 3:54 PM
    Is there a guide somewhere on taking a Supabase Platform project and "exporting" all the stuff there to your local filesystem so you can either run it locally or push to another Project? I'm looking at running my first project and want devs to have a shared environment but also be able to push it to a separate Production environment later. Or have the option to pull it down and run their Functions locally while working on changes
    n
    s
    • 3
    • 8
  • g

    gerry

    06/28/2022, 4:32 PM
    is there a guide to migrate Authentication out of firebase and into supabase / stytch ?
    n
    b
    • 3
    • 5
  • j

    jarcher

    06/28/2022, 7:10 PM
    Hi all! I'm working on the tech stack at arketa.co (YC S20 batch mates 😄 ) -- I'd love to give supabase a shot and finally think I found something worthy! We're building some analytics tools for our customers, and compound queries in firestore are becoming impossible (mutliple "IN" filters in a single query) where having a sql queryable db would work well. I'd like to keep firestore for application data, but replicate some collections in supabse for querying abilities. What's the best way to do this? I'm thinking of having a simple document trigger on firestore that then updates a row in supabase. what do you all think?
    n
    • 2
    • 1
  • d

    da newb

    06/28/2022, 9:10 PM
    I'm running Supabase CLI 0.26.0, with Docker images:
    Copy code
    supabase/studio:latest
    supabase/postgres-meta:v0.33.2
    supabase/pgadmin-schema-diff:cli-0.0.4
    supabase/storage-api:v0.15.0
    postgrest/postgrest:v9.0.0.20220211
    supabase/realtime:v0.22.4
    inbucket/inbucket:stable
    supabase/gotrue:v2.6.18
    kong:2.1
    supabase/postgres:14.1.0.21
    I have a table
    discovery.nfts
    and a table in
    public.likes
    that has a foreign key to
    discovery.nfts
    . I am running a DDL migration that alters the schema, and now I'm getting warnings for PostgREST that the relation between
    public.likes
    and
    discovery.nfts
    cannot be found. I tried both
    docker kill -s SIGUSR1 <postgrest container id>
    NOTIFY pgrst, 'reload schema';
    I confirmed that PostgREST said the schema was reloaded, but I still get the error
    n
    • 2
    • 7
  • s

    stijn

    06/28/2022, 10:06 PM
    Hey! Does something like a
    unique_together
    constraint exist in Supabase? I'm working with a
    habit-entries
    table that has a habit, date, and user row. It stores which habits a user did on which date. To avoid duplicate entries I'd like to add a
    unique_together
    constraint for like in Django: https://docs.djangoproject.com/en/4.0/ref/models/options/#unique-together (in this case it would be
    unique_together = ['user_id', 'habit_id', 'date']
    ) Is this possible and if so can someone redirect me to the resource/tutorial? I couldn't find anything😅
    n
    s
    • 3
    • 4
  • g

    gerry

    06/28/2022, 11:55 PM
    anyone know what the expected format is here? using something like '2022-06-16T16:25:39.000Z' does not seem to work
    n
    • 2
    • 1
  • j

    jar

    06/29/2022, 12:19 AM
    Is there a plpgsql equivalent to js toPrecision()? https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/toPrecision
    n
    g
    • 3
    • 6
  • m

    MasterBetty

    06/29/2022, 1:04 AM
    Hi everyone, I am just getting started with Supabase and having some difficulties setting up my local environment. I initially followed the instructions on the documentation, got local changes migrating to remote, but when I tried to add changes to the online version through the dashboard, I can't find a way to bring those onto my local machine. During playing around with the various commands, I got an error message that told me the migrations on remote was out of sync and to delete the rows on that schema and try again. I did that and no luck. I then tried to remove all files from the local system and start again, but I now get this error when even following the local development instructions: $ supabase remote set 'xyz' $ supabase db remote commit $ supabase db reset Error: Error resetting database: ERROR: cannot drop function graphql.build_delete(jsonb,jsonb,jsonb,text,text) because extension pg_graphql requires it HINT: You can drop extension pg_graphql instead. Any ideas on what I can do to fix this? Thanks
    n
    j
    m
    • 4
    • 26
  • t

    thestepafter

    06/29/2022, 1:52 AM
    Hello everyone! I have setup cron jobs and calls to an external API following the approach on this page: https://supabase.com/blog/2021/03/05/postgres-as-a-cron-server. With that being said I am concerned about the security of my API token. Especially if I decide to go multi-tenant and store an API key for each user so they can connect to an API and access data specific to them. What is the recommended approach for ensuring that the API key is encrypted and can then still be used to do the API calls when the cron job executes?
    n
    • 2
    • 2
  • h

    hmean

    06/29/2022, 1:59 AM
    Unable to receive results from real-time subscription
    g
    • 2
    • 5
  • i

    ItsPolder

    06/29/2022, 11:07 AM
    Hi, is there a way to access the query parameters from the client on row level security? For example: I want to deny queries, that select every record in the table, but I want to allow queries, that select a specific record with an id.
    n
    g
    • 3
    • 3
  • s

    Sajad

    06/29/2022, 11:23 AM
    Hey, is there a way to create sync authentication between two different react apps with Supabase? Like when I (log in /log out) of one app, it (log in / log out) of the other app.
    n
    o
    • 3
    • 18
  • r

    Relisora

    06/29/2022, 11:58 AM
    Hi! I am using a
    count
    and noticed that it is
    "exact"
    in the docs. I was wondering if there were other options, like
    "estimate"
    that could make my request faster. Example:
    Copy code
    js
    .select('*', { count: 'exact', head: true })
    n
    g
    s
    • 4
    • 6
  • m

    Murkrage

    06/29/2022, 12:54 PM
    Is there a way to disable magic link sign ups / sign ins?
    n
    o
    s
    • 4
    • 18
1...292293294...316Latest