https://supabase.com/ logo
Join Discord
Powered by
# help
  • s
    More info on why Supabase is slow
  • e
    Hi there, I have a question around PostgreSQL constraints. I want to have something like * when 
    projects.plan
    is "Basic", * number of 
    pages
    of the project should be <= 10 I'm googling and seeing quite intimidating functions. Do I happen to miss some neat way?
  • k
    Hey all, I can't find anywhere how to sort data by date, for example i want to sort upcoming events, or get past events... Does anyone have that resolved or know the solution?
  • m
    Hello, is it possible to programmatically log someone in, when having the user uid?
  • k
    Copy code
    create or replace function searchByKeyword(keyword text) returns table (events)
as $func$ 

  SELECT * FROM events
  WHERE to_tsvector(description || ' ' || title)
  @@ to_tsquery(keyword)

$func$
language sql;
  • k
    i am getting error here "syntax error at or near ")"
  • k
    in this line 
    returns table (events)
  • k
    any help?
  • s
    Hey! Has anyone used supabase python library to execute rpcs? Not much documentation on it (or postgrest python library), and seeing an error in calling a basic rpc. This is how I have it. 
    data = supabase.rpc("recent_user_activity", { 'user_id': 'xyz312', 'start_time': '2021-01-19', 'end_time': '2021-11-04'}).execute()
  • s
    You should either specify the column names and data type of each:
    Copy code
    RETURNS TABLE (event_name text, event_time timestamp)
    Or return a 
    setof
    a table:
    Copy code
    RETURNS SETOF events
  • d
    +1 to this
  • d
    I see that my Supabase subdomain is now returning a CloudFlare server header; is this a new change?
  • e
    I have associations in this 
    cartItem
    like 
    product
    . But when i go to the api, the json only shows the product_id, but not the full product object. How can i make it show the full associated object?
    s
    • 2
    • 1
  • l
    any idea why a request would return a CORS error when I sent a lot of IDs to a query, but works fine with just a couple?
    g
    • 2
    • 5
  • z
    i used the library code of 
    storage_client
    (dart) to try to get download progress from supabase storage files using the 
    Content-Length
    header (to get total file size) but i noticed that the header doesnt exist in the response. is there an extra parameter i need to add to the request or is it impossible to get the size of my file?
  • s
    Related data is not showing when using the api
  • y
    Since yesterday I am getting this error when trying to visualize the images uploaded to the storage, why is this? https://xrcvldvpazufasqpqolt.supabase.co/storage/v1/object/public/test/pages/8f770971-da30-49fa-99d0-d9f8e0546056/performance_2_w584-42.png#
  • g
    CORS error with lot of IDs
  • r
    Are there resources for securing web applications as well as passing cookies/tokens/header auth between services with Supabase? Would something 'BFF-like' work? May have drank to much BFF/OAuth 2.1 juice, but when I look at stuff like: or this blog or heck, the standard itself , I keep thinking that supabase could act as the gateway itself
  • d
    Is there a supabase support that can be contacted?
    s
    • 2
    • 1
  • s
    Supabase support
  • d
    I have been charged by supabase by my plan is still free tier
  • d
    Anyone know if supabase has support?
  • d
    I know they are loud with meme, but no one is helping me
  • m

    https://media.discordapp.net/attachments/577192344533598472/906382874108915762/Screenshot_20211106-112027.png▾

    Do you think my database is bad? Basic representation of it 🤔
  • d
    I get this error 
    ReferenceError: Cannot access uninitialized variable.
    with this 
    const { createClient } = supabase;
    .
  • m
    You didn't initialize variable
  • m
  • d
    How do I do that?
  • m
    I'm not sure sorry but you can google tho
1...126127128...316Latest