I'm creating an application where admins will be able to upload csv files. I wanted to use storage bucket and then upload the files there. After the file is uploaded, a trigger function will be called and every line from the file will be added to a specific column in a table in my database. I can't do it. help

Hello, I'm following the example given here for sending emails with the http extension via MailerSend here: https://github.com/burggraf/supabase-mailer/blob/main/02E_send_email_mailersend.sql The response returned into

retval

contains headers as type

http_header[]

which is a tuple as described by the documentation https://github.com/pramsey/pgsql-http: > The headers field for requests and response is a PostgreSQL array of type http_header which is just a simple tuple. The MailerSend API request to send an email returns an empty response with a 202 status and a response header with key

x-message-id

containing a uuid of the message in MailerSend's API. I need to get this from the headers stored in retval, but I can't seem to figure out how without getting type interchangeability errors?

sql

-- this is executed by a trigger after insert on public.emails

select into retval * from http(...);

update public.emails set message_id = ... where id = new.id;

I'm trying to effectively get the value of

retval->'headers'->>['x-message-id']

. Thanks for any help!

Basically, I have a project similar to Reddit and the is_approved field is in the same table, I don't want people to spam stuff and send a api request and change it to is_approved: true so Is there a way I can set a policy where users can update all fields except is_approved field Thanks big help.

Users on my client are submitting match results for a tennis game they have played. They only enter the names of the 2 players of each team (4 players in total), the score of each team, and where they played the match. To store this data in a normalized matter, I have 5 different tables that each needs some part of this data. Since the client only provides the before mentioned data, I don't have the necessary details at hand to do all the table inserts without first having to look up the users id's etc. etc. I would prefer to not chain a bunch of API calls from the FE (ie. retrieve each players ID by their username, finding the id of the play location by the play locations name etc), but instead just make 1 request with the data submitted by the user, and then have the BE chain these requests. Is this an appropriate case of RPC? Can I make one stored function (procedure?) invoke another one? I suspect I would use triggers for most of these -- but ideally I can forward along data between the functions, instead of having to do similar lookups in multiple of the functions. for context, my db schema in next comment: I need to make inserts into matches, match_results, player_matches, and finally player_elo_history. A problem I am foreseeing: The insert into the matches table would be the first action to perform. Setting up a trigger to perform the "next step" as a reaction to the insert in the matches table seems insufficient, as the new row in the matches table does not contain the information that the next table insert requires.

Are python edge functions on the roadmap?

Hello! I have an after trigger on row insertion that should generate one of the row's fields. Ideally, the trigger is run asynchronously, requests an HTTP POST endpoint hosted locally, and modifies that row. But when I use http_post, it tells me that the connection is refused. I am guessing it comes from the docker-compose rules which I should modify to open the specific port I am using locally. But I can't find information on customizing the docker container started by supabase start anywhere. I found a

supabase eject

function online, but it was apparently scrapped. How can I proceed? Thanks!

Hi! I would like to ask about best practices in terms of setting up a fullstack, monolithic Nuxt 3 project with Supabase into multiple environments, particularly a dev environment, staging environment, and production environment. how do i set all of it up together? i just need guidance on setting up supabase with multiple environments in a fullstack codebase.

js
    const { data, error } = await supabaseAdmin
        .from('jobs')
        .select(`*,
            job_filters!jobs_job_filters(*)
           `)
        .eq('job_filters.slug', 'freelance')
        .eq('job_status', 'LIVE')

This is what I am trying to achieve but seem like the

.eq('job_filters.slug', 'freelance')

part doesn't' work. Any ideas?

I spent 80MB of 500MB free tier database space but I only used realtime actions. Never persisted any data. How actually realtime events consume database size?

Hi Everyone, I am brand new to Supabase and I was wondering if I could make an API call within a database. I have a list of Products with ProductIDs and the Price of each Product changes by the minute/hour/day. I was wondering if I could keep the Products and ProductIDs static but call an API endpoint to get the most recent price. If this is a thing I would love to know how to implement that! Thanks so much!

Hey guys, I’m fetching a description paragraph from db, but it comes in bulk and I can’t seem to format it on front end, as I’m adding line breaks, making a bit of it bold? Can anyone advise a work around? Thank you. Screenshots attached.

Is it possible to generate magic link via code and send via modes other than email?

im getting this error with Nuxt3 supabase module and wondering how i can work around it

Hi! I’ma exploring a project built with Supabase that needs to call a precompiled binary from a function. In Lambda, I’m providing the dependency using a layer. What’s the equivalent with a Supabase Function? I could probably host it in my Storgae bucket and download on every invocation but this seems clunky. Excited to get going with this! Supabase looks fantastic and if this works out, it’ll simplify my project and life tremendously.

I'm following this documentation here https://supabase.com/docs/reference/javascript/subscribe but I'm not receiving any insert events, when I turned off the RLS I'm getting the events, is there any to make it work without turning off the RLS?

How do I make every request received from this user to bypass all RLS policies

I currently have a prod database which has a bunch of data tables etc and I wanted to import that locally so that I can, going forward, make changes to the local db to test everything works before making those changes to the prod one. I have been following https://supabase.com/docs/guides/cli/local-development and gotten past

npx supabase start

so I can see my container running and can access a local DB however that local DB doesn't have any tables which I wanted to get from my prod db.

Hello! I am not able to make http requests to localhost when developing locally. My Supabase Function uses http_post but can't connect to localhost, even if I use host.docker.internal. Is there a way to use localhost in plpgsql functions?

Hi! When running the

supabase db remote commit

command in a project which I just initialised (it was an existing project but I deleted the supabase folder and ran everything agains starting from

supabase init

), I expect the 7 remote changes to be applied to my local development environment. Instead I get the following error:

Error: The remote database's migration history is not in sync with the contents of supabase/migrations. Resolve this by:
- Updating the project from version control to get the latest supabase/migrations,
- Pushing unapplied migrations with supabase db push,
- Or failing that, manually editing supabase_migrations.schema_migrations table with supabase migration repair.
I was under te impression that when you have an empty /migrations folder (or no migrations folder), the remote migrations will be applied.

Running the supabase migration list command shows the expected migrations:

LOCAL │     REMOTE     │     TIME (UTC)
  ────────┼────────────────┼──────────────────────
          │ 20221015154708 │ 2022-10-15 15:47:08
          │ 20221018164830 │ 2022-10-18 16:48:30
          │ 20230105123901 │ 2023-01-05 12:39:01
          │ 20230105125254 │ 2023-01-05 12:52:54
          │ 20230107120832 │ 2023-01-07 12:08:32
          │ 20230107124039 │ 2023-01-07 12:40:39
          │ 20230211161612 │ 2023-02-11 16:16:12

Is there an extra step needed in order to get my (empty) local development environment back in sync with my remote one? I tried the suggested commands in the error message but no luck so far. Thanks!

I have two free tier projects - I am getting "Something went wrong" error messages on both and my tables are not showing.

I'm on the pro plan with XL tier add-on. Our queries still give us a 400 error timeout every single time we query data. We're trying to do pagination and sending query requests in batches of just 10 rows... but it still gives us a timeout error. We're strictly specifying the number of columns (10-15) but that still gives us an error. My logs dont tell me anything about why the query failed. This keeps happening every single time. What am I doing wrong? Is there a better way to write queries so that it doesn't fail? I doubt that more compute power is the only answer...

Hey yall! I'm quite new to supabase, and am currently in the process of following the supabase tutorial (https://supabase.com/docs/guides/functions/examples/stripe-webhooks) to integrate Stripe into a Supabase edge function. I'm at the point where I'm ready to deploy the edge function, but I'm getting the following error, and can't seem to find anything online for it.

js
Error: Error bundling function: exit status 1
file:///src/import_map.json
file:///src/index.ts
error: Uncaught (in promise) Error: NotFound: The system cannot find the path specified. (os error 3)
      const ret = new Error(getStringFromWasm0(arg0, arg1));
                  ^
    at __wbg_new_8d2af00bc1e329ee (https://deno.land/x/eszip@v0.30.0/eszip_wasm.generated.js:312:19)
    at <anonymous> (https://deno.land/x/eszip@v0.30.0/eszip_wasm_bg.wasm:1:79439)
    at <anonymous> (https://deno.land/x/eszip@v0.30.0/eszip_wasm_bg.wasm:1:1388039)
    at <anonymous> (https://deno.land/x/eszip@v0.30.0/eszip_wasm_bg.wasm:1:1862894)
    at __wbg_adapter_18 (https://deno.land/x/eszip@v0.30.0/eszip_wasm.generated.js:146:6)
    at real (https://deno.land/x/eszip@v0.30.0/eszip_wasm.generated.js:130:14)

I'm running getSession() at the beginning of page load. However, my console logs an error:

Uncaught (in promise) TypeError: supabase.auth.getSession is not a function

This is after pulling a project from github that worked on another machine. Here's a screenshot of the supabase.auth object I'm calling

getSession()

on: Here are my dependencies:

"dependencies": {
    "@mdi/font": "5.9.55",
    "@supabase/supabase-js": "^2.7.1",
    "pinia": "^2.0.30",
    "roboto-fontface": "*",
    "vue": "^3.2.45",
    "vue-router": "4",
    "vue-supabase": "^2.3.0",
    "vuetify": "^3.0.0-beta.0",
    "webfontloader": "^1.0.0"
  },

Here's my import.

import { createClient } from '@supabase/supabase-js'

const supabase = createClient(
  "-------------------------",
  "-------------------------"
);

export default supabase;

Thank you in advance!

it was missing as of earlier this week right? thought we only had

jsonb

available from the dashboard

I'm updating upgrading my workflow and started using a local instance of supabase for development. Following the documentation (https://supabase.com/docs/guides/cli/local-development) , I got everything setup properly and by running

supabase db remote commit

my initial migration script was automatically generated. After I started supabase with

supabase start

everything was created except my triggers. Is this normal ? (the trigger function was created, but not the trigger itself)

I installed MailerSend as Custom SMTP but email still in spam box? How can I fix this issue?

Hey yall! I'm quite new to supabase, and am currently in the process of following the supabase tutorial (https://supabase.com/docs/guides/functions/examples/stripe-webhooks) to integrate Stripe into a Supabase edge function. I'm at the point where I'm ready to deploy the edge function, but I'm getting the following error, and can't seem to find anything online for it.

js
Error: Error bundling function: exit status 1
file:///src/import_map.json
file:///src/index.ts
error: Uncaught (in promise) Error: NotFound: The system cannot find the path specified. (os error 3)
      const ret = new Error(getStringFromWasm0(arg0, arg1));
                  ^
    at __wbg_new_8d2af00bc1e329ee (https://deno.land/x/eszip@v0.30.0/eszip_wasm.generated.js:312:19)
    at <anonymous> (https://deno.land/x/eszip@v0.30.0/eszip_wasm_bg.wasm:1:79439)
    at <anonymous> (https://deno.land/x/eszip@v0.30.0/eszip_wasm_bg.wasm:1:1388039)
    at <anonymous> (https://deno.land/x/eszip@v0.30.0/eszip_wasm_bg.wasm:1:1862894)
    at __wbg_adapter_18 (https://deno.land/x/eszip@v0.30.0/eszip_wasm.generated.js:146:6)
    at real (https://deno.land/x/eszip@v0.30.0/eszip_wasm.generated.js:130:14)

How long should I expect a query like this to take:

select id from table
where property1 >= 5
and property2 = 'arbitrary string'
and property3_date <= <ARBITRARY DATE>
limit 30000

There are 1,000,000 rows in my DB. This query returns 26,000 rows. I have indices on property1, property2 and property3 Currently, it takes up to 90 seconds sometimes (median latency is ~30 seconds). I pay for the small add-on (2 GB memory)

We only want to log in via the Slack provider.

Apparently whatever docs or videos I refer to are using the previous v1 of supabase and when I use them it results in an error. There doesn't seem to be a good resource available for the new v2. Guide me to a resource so I can make this sh*t happen for my app.