https://supabase.com/ logo
Join Discord
Powered by
# help
  • j
    Getting mixed results when creating foreign keys
    d
    • 2
    • 21
  • e
    Whenever a tab is clicked on my project the whole site "jumps" a bit, you can see what I mean, it is hosted here: https://www.goodvids.so If you click around a bit you can see everything jump every time, I think due to the offset from the scrollbar. Does anyone know how to fix this?
    n
    s
    • 3
    • 3
  • g
    Hi! I am suddenly unable to send magic links - trying to manually trigger a magic link via the dashboard gives me "Failed to send magic link: An error has occured: NetworkError when attempting to fetch resource." Is there something I can do to fix this?
    n
    s
    j
    • 4
    • 5
  • h
    Hello I am using supabase and trying to push some video on bucket storage but it is showing me the error code 401 . I attached picture for reference . Any leads to solution?
    n
    s
    • 3
    • 4
  • t
    Hello, I contacted support but I didn't receive any answer, so I'll post my question here. Can someone explain me how Pay as you go plan works? Is it the same as firebase ("unlimited resources" and pay for bandwidth) or do I need to reserve a new instance (50$+/month) based on load?
    n
    o
    c
    • 4
    • 10
  • l
    Hello, How to automatically save new user to the database? I followed this guide - https://daily-dev-tips.com/posts/supabase-automatically-create-user-profiles-on-sign-up/ It's not working, just getting 500 errors. Need help. Also, triggers and functions are not available for production, what is the alternative?
    n
    g
    • 3
    • 4
  • n
    Hello @Voko2255! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the 
    /title
    command! We have solved your problem? Click the button below to archive it.
    g
    d
    • 3
    • 3
  • v
    Any help about this error
    n
    • 2
    • 1
  • r
    Hi! Could someone help me figure out what the best way of protecting a table such that it can only be written to by my applications server?
    n
    g
    +2
    • 5
    • 7
  • n
    Hey, is there an easy way to change a function hook webhook url?
    n
    g
    • 3
    • 3
  • i
    Hey, I was curious if anyone has run into any issues generating types in an NPM script? I'm following the "Generating Types" guide and the 
    openapi-typescript
    command works if I run it directly but when I run it as an NPM script I get an error:
    Copy code
    Error: ✘  version missing from schema; specify whether this is OpenAPI v3 or v2 https://swagger.io/specification
    Anyone encountered this before? The guide: https://supabase.com/docs/reference/javascript/generating-types
    n
    • 2
    • 1
  • n
    Is there any plans to expose an endpoint to programatically create a new Postgres Database? I have a use case where every customer needs their own DB and supabase would fit our use-case perfectly if we could programatically create the databases when needed.
    n
    d
    a
    • 4
    • 11
  • b
    What is the correct (and secure) way to implement a security definer function that isn't callable via rpc (or other ways from outside) and can only be called by other functions?
    n
    s
    g
    • 4
    • 18
  • a
    Hi, anyone know how to implement the function in the link below by using Functions and Triggers pages from the database dashboard (Alpha Preview section)? https://supabase-sql.vercel.app/youtube-like-short-id
    n
    g
    • 3
    • 4
  • a
    Copy code
    ts
async function updateUserFinances(currentUserID: string, updatedExpenses: Object) {
  const { data, error } = await supabase
    .from("UserFinanceData")
    .update({ Expenses, updatedExpenses: JSON });
    .match({ UserID: currentUserID} )
    n
    • 2
    • 3
  • a
    what's wrong with my function that i'm trying to make? keeps saying "syntax error at or near "if""
    Copy code
    sql
create function commands_inc (x int, row_id text) 
returns void as
$$
  if exists (select 1 from bot_analytics where id = row_id) then
  begin
    update bot_analytics 
    set commands = commands + x
    where id = row_id
    end
  else
  begin
    insert into bot_analytics (id, commands)
    values (row_id, x)
  end if
$$ 
language plpgsql volatile;
    n
    a
    • 3
    • 6
  • l
    Is there a simple way to make a column have a default value of now() + 3 days?
    n
    d
    g
    • 4
    • 10
  • h
    Hello Guys ! Any one of you have an idea of correct implementation of bucket storage through python ?
    n
    • 2
    • 1
  • f
    __JS experts, need some help.__ How do I make asynchronous api calls which are saved in an array. I want to call these endpoints in a loop, get the data and assign it to a new array. You can find a starting point example for what I am trying to achieve here. https://stackblitz.com/edit/node-hy2gvg?file=index.js
    n
    • 2
    • 1
  • b
    Is there a way to call a select and turn it into a stream? Or altenative: Is it possible to join realtime databases in queries?
    n
    g
    • 3
    • 7
  • a
    I'm reading through supabase-auth-helpers and seeing that it stores the access token in cookie. I'm not sure why that's needed. The version of supabase I am using puts some auth data in localstorage and essentially persists the session that way.
    n
    g
    • 3
    • 4
  • a
    Is there a way to add column level security within supabase? (without using something like a graphql middleware)
    n
    s
    • 3
    • 4
  • p
    is it possible to insert into foreign tables via relation?
    n
    g
    • 3
    • 7
  • v
    Does anyone know how to solve my auth container erroring with
    Copy code
    running db migrations: Migrator: problem creating schema migrations: couldn't start a new transaction: could not create new transaction: failed to connect to `host=db user=postgres database=postgres`: server error (FATAL: no pg_hba.conf entry for host \"172.19.0.7\", user \"postgres\", database \"postgres\",
    every time? I could just put 172.19.0.7 in pg_hba.conf, but I'm trying to package a single docker-compose and .env config people can use to self-host without having to edit their pg_hba.conf files.
    n
    • 2
    • 1
  • m
    hey guys, I am running a function to clean my database by deleting all rows in all tables like so 
    await supabase.from(table).delete();
    . works perfectly on my dev instance but somehow nothing deleted on my testing instance. am I missing some config on this one? what could cause this?
    n
    s
    • 3
    • 3
  • j
    Hi, I am using twilio auth (passwordless) and Next.js. After supabase.auth.verifyOTP I can see the login content on the page and see session object returned correctly. However, when I refresh the page, the page goes back to the un-authenticated content and the supabase.auth.session() returns null. Do I need to call any other method to make the session persist across page (i.e. the definition of session). My code is 1) on the index page {!session ? : } 2)In the Auth component I called await supabase.auth.verifyOTP({ phone: number, token: code, })
    n
    s
    o
    • 4
    • 5
  • n
    Hello @joshwo! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the 
    /title
    command! We have solved your problem? Click the button below to archive it.
  • l
    Is it possible to access bytea columns with Dart Supabase SDK?
    • 1
    • 1
  • b
    When you create a new table via the UI what is called in SQL? Just CREATE TABLE or also other statements like for example GRANT... ?
    n
    g
    • 3
    • 10
  • f
    hello everyone! I worried about a problem that happened with me using supabase.. I have 180k objects in my bucket.. but on dashboard just show me 1000
    n
    g
    • 3
    • 38
1...244245246...316Latest