https://supabase.com/ logo
Join Discord
Powered by
# help
  • s
    when filtering with the rest api, do you enclose the values in quotes or something if they have spaces in them?
  • s
    e.g. right now im trying to delete a row that has a value in the 
    hi
    column that is 
    hello world
    , how would i filter it properly?
  • s
    replace the spaces with dashes?
  • o
    Hi folks, first time supabase user here. I'm just getting started, and trying to setup sendgrid as the mail provider. However, I think I've misconfigured my JWT or something, because I see: "Failed to invite user: Invalid token: signature is invlalid"
  • f
    is there an undocumented way to use user access token with supabase/realtime
  • f
    i tried providing it in params as apikey but it returns 401 and works only with anon key
  • p
    Copy code
    sql
create function increment (x int, row_id int) 
returns void as
$$
  update table_name 
  set field_name = field_name + x
  where id = row_id
$$ 
language sql volatile;
    Copy code
    js
const { data, error } = await supabase
  .rpc('increment', { x: 1, row_id: 2 })
    hey, ik i can increment a field like this but is there a way i can dynamically increment a field? like provide the column name through the rpc?
    t
    • 2
    • 13
  • p
    i dont want to write the exact same rpc for every column i want to increment in
  • b
    It’s the project id
  • p
    Hey, I migrated laptops. When I sign in using my github i get a prompt to reauthorize a new app. In the list of my gh apps there is already Supabase Auth0. Was there any recent change? Is it safe?
    s
    b
    • 3
    • 2
  • h
    @User for self hosting how does storage api connect to aws, i cant see anywhere to add access keys, and this project id is which project ID? thanks
  • t
    postgres return query execute format
  • b
    I think it connects thru the FILE_STORAGE_BACKEND_PATH=./data variable
  • h
    that means we can only use local storage
  • p
    users Table

    https://cdn.discordapp.com/attachments/722720878932262952/932571227418144788/unknown.png▾

    user_cards Table

    https://cdn.discordapp.com/attachments/722720878932262952/932571299186896917/unknown.png▾

    https://cdn.discordapp.com/attachments/722720878932262952/932571436244148274/unknown.png▾

    https://cdn.discordapp.com/attachments/722720878932262952/932571385476296704/unknown.png▾

    https://cdn.discordapp.com/attachments/722720878932262952/932571558348742676/unknown.png▾

    my foreign table queries aren't working anymore. they were working before. the only significant change i can think of that ive made between then is enabling replication for inserts on my user_cards table. is this a glitch or am i misunderstanding something about related tables?
  • b
    No that’s were the s3 configuration is supposed to go
  • h
    oh
  • h
    i see
  • h
    hello guys, I need a bit of help. Running 
    npx openapi-typescript .....
    gives me 
    no matches found: https://<myproject>.supabase.co/rest/v1/?apikey=<my-anon-key>
    even though I got the json when visiting the link directly. nvm, I must escape 
    ?
    in 
    ../?apikey
  • p
    actually, selecting any columns from the users table doesnt work. im going to open an issue on github
  • t
    Is it 
    auth.users
    as you need to include the schema when not default? All the tables you create will be by default in the 
    public
    schema and you can leave it out.
  • p
    no, i wanted public.users
  • g
    hi! someone was ever able to locally develop with supabase?
  • g
    i mean, i could not create a user locally
  • g
    someone with the same issue?
  • p
    when i restore my dbs from being paused, theyre completely wiped. is this intentional? the email says they keep the data.
    s
    • 2
    • 1
  • g
    its supposed to use migrations + seed.sql
  • g
    as far as i went
  • g
    into docs
  • g
    everytime you supabase run, it runs the migrations and inserts dummy data
1...196197198...316Latest