https://supabase.com/ logo
Join Discord
Powered by
# help
  • l
    I'm trying to create a new Supabase table by importing a large CSV (70,000 rows), in order to access the CSV via an api. After the create table process and the confirmation that the table will be created with 70,000 rows, the table is created with 0 rows. Is what I'm trying to do possible? Is there a better approach? I would like to query the large CSV (20 MB) without having to include it in my website build, as sessions would probably only query a few rows at a time
  • t
    Hi Guys! I have created a self-hosted supabase on an Intel NUC here in my home environment and when I try to run a sample app seems that I am receiving a "CORS" error. After the first setup do I need to authorize anything on Kong?
  • t
    Copy code
    OPTIONS
    http://192.168.1.12/auth/v1/signup
Status
403
Forbidden
VersionHTTP/1.1
Transferred123 B (0 B size)
Referrer Policystrict-origin-when-cross-origin
  • t
    solved, I needed to add :8000 for kong
  • j
    Could you open a support ticket through the dashboard? https://app.supabase.io/support/new
  • b
    there is an option to save session in supabase?
    s
    • 2
    • 2
  • s
    Save session in Supabase
  • h
    Hey! My realtime dosen't ream to work with views. Is this intended? or is It supposed to be sending realtime data for views?
  • h
    Also another question, can you do case-insensitive queries with the SDK?
  • g
    You can use ilike, use the CITEXT extension to create a ci column or a computed column to lower case as some options
  • h
    I found a solution in the end 🙂 but thanks anyways
  • b
    hey, there is an option so save ur jwt in cookie and not in local storage?
  • l
    When using the subscribe for realtime data, is it possible to retrieve not only the updates, but the current documents that match the subscription as well?
  • y
    Views are not tables, replication doesn't affect them. When there is a change in the view, the db just executes the query that was used to create the view.
  • h
    Oh! Is there no way to use realtime on a view then?
  • y
    Nope, what are you trying to do though?
  • y
    Not exactly clear what you mean by "current documents that match the subscription". If you mean is it possible to get some data based on the updated data then not as part of the payload returned by the subscription, you'll have to query the database a second time. If you mean is it possible to get the entire row of data that the updated occurred on, that's default behavior afaik
  • l
    thanks! So im just looking for a method similar to Firebase's onSnapshot where you can have a query that returns the initial rows that meet the query and listen to changes to those specific rows
  • y
    When you register a subscription it doesn't return a set of initial data, you have to fetch it separately, and the subscriber will stream changes from the point you registered the subscriber
  • s
    Which client caching solution do guys use for your project (since all the backend is stored in the cloud). Right now I am using the localStorage for the userprofile data, but I have a feeling it should not be like that.
  • g
    I'm using js localForage (which for the most part uses indexedDB). I have to support minimal offline activity (write notes) and use this to also cache read notes and store any file/image data waiting to be written if offline.
  • w
    Hi so I am currently working on authentication through Magic Link with Supabase and something weird is happening. The project is built with Next JS This is the login function
    Copy code
    javascript
async function signIn() {
    const { error, data } = await supabase.auth.signIn(
      {
        email,
      },
      {
        redirectTo: "http://localhost:3000/verify",
      }
    );
    if (error) {
      console.log({ error });
    } else {
      setSubmitted(true);
    }
}
    The email is sent out successfully but I have a problem with the redirect link, somehow supabase is adding a 
    #
    to the url, so am getting 
    http://localhost:3000/verify#access_token=<ACCESS_TOKEN>&expires_in=3600&refresh_token=<REFRESH_TOKEN>&token_type=bearer&type=magiclink
    instead of 
    http://localhost:3000/verify?access_token=<ACCESS_TOKEN>&expires_in=3600&refresh_token=<REFRESH_TOKEN>&token_type=bearer&type=magiclink
    s
    p
    • 3
    • 15
  • s
    Supabase Magic Link
  • p
    in the Authentication settings page, in the site URL field, is it okay to enter more than 1 URL (using a comma-separated list)? (screenshot attached)...
  • h
    Hey! I have this plpsql function but when it gets run it stops the insert with this message:
    Copy code
    sql
CREATE OR REPLACE FUNCTION
    public.message_insert_bot_trigger_fnc()
    RETURNS TRIGGER AS
$$
DECLARE
    bot               bot_members%rowtype;
    bot_http_response http_response;
BEGIN
    FOR bot IN
        SELECT *
        FROM bot_members as member
        WHERE member.chat_id = NEW.chat_id
          AND member.interactions_url IS NOT NULL
    LOOP
        SELECT *
        INTO bot_http_response
        FROM http((
                   'POST',
                   bot.interactions_url,
                   ARRAY [http_header('X-Version'::varchar, 'v1'::varchar), http_header('X-Bot-ID'::varchar, bot.id::varchar)],
                   '{"type": 1,"data": {"id": "' || NEW.id::varchar || '","content": "' || NEW.content || '","user_id": "' || NEW.user_id::varchar || '","chat_id": "' || NEW.chat_id::varchar || '"}}',
                   'application/json'
            )::http_request);
        -- Do something with returned data!
    END LOOP;
    RETURN NEW;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;
  • h
    Copy code
    {
  "hint": null,
  "message": "control reached end of trigger procedure without RETURN",
  "code": "2F005",
  "details": null
}
  • h
    Any help would be apreciated. I've probably just done somthing stupid haha Edit: Fixed 🙂
  • v
    Hello, I just take a look at this discussion here: https://github.com/supabase/supabase/discussions/710#discussioncomment-362651 Let say I have 
    movies
    table, if I want to have a column that has an array of other movies foreign key, I have to create another table, I'll name it 
    relations
    . Now, If I want to query a movie from 
    movies
    table, also all it's relations. What should I do? I assume I have to make two calls
    Copy code
    js
let { data: movie, error } = await supabase
  .from('anime')
  .select('*')

let {data: relation, error } = await supabase
  .from("relations")
  .eq("movie_id", movie.id)
  .select("*")

// Is this a right way to do it?
    Thank you
  • k
    Hey, does anyone know how to filter data per dates, for example i want to filter past events or future events from today...
  • k
    Has anyone added Instagram as a oauth provider curious how one could do it ?
1...114115116...316Latest