Is there a simple way to copy a database and table data from one project to another? Such as, for dev and production environment projects?

Hey there, what payment options are available for paid & enterprise plans?

Hey all, I'm trying to understand RLS, and feel like I must be running into something obvious, but can't figure it out. After the user signs up, using

supabase.auth.signUp

I attempt to insert a row into a

users

table I created. I get a 401 if I have this policy enabled:

Enable insert for authenticated users only

. I assume that since the user just signed up, that they are authenticated, but still the 401. Works fine when the policy is removed. I've also tried adding:

{ returning: 'minimal' }

since I've read it could be related to the return (select) policy, but no luck. Any ideas? Thanks

Hey so a very basic question, but in the SQL Editor, why does this query not work?

select * from admins where admins.id = "somevaluehere"

It repeatedly tells me "column 'somevaluehere' does not exist". In the PostGres tutorials, this syntax looks valid, so not sure what I'm missing.

How do I determine what schema (public, graphql, storage, etc.) my table should be under? I can't seem to find any definitions in the guide. @User

Hello guys, can i get some help on graphql querry on my db ?

Is there anyway (or plans to) create function hooks from the CLI? I am trying to have a development flow that lives entirely in the codebase and doesnt rely on the Supabase gui/studio. I am leaning towards function hooks that fire a supabase function (via http but hopefully soon just by calling the supabase function) so that way I can write plain typescript and import shared packages to write the function logic that will fire from the hook. Right now it doesnt seem possible beyond activating a function hook in prod whose function is basically a no-op and then pulling that DB down locally to develop the function, and then redeploy. If anyone has any tips on a flow like that (or an approach that I didnt consider) id appreciate it!

Hi All. I'm loving Supabase. I've been working hard on a project based on it for the last 3 months, and we are upgrading our plan, and getting ready to invite in beta users by the end of the month. Once we are live, as I add new features, I want to be able to not effect the production database...in other words, I need a staging db to work with until the feature is approved and we are ready to go live... What is the recipe for doing this with supabase? I'm getting concerned because I'm not finding mentions of how to do this in the documentation. I have so much invested in supabase at this point.

I've been using the example of the sveltekit auth helper (https://github.com/supabase-community/auth-helpers/tree/main/examples/sveltekit-email-password), which works really well. But i am having issues getting a POST request in the endpoint to work. Should i use supabaseClient or supabaseServerClient, and do i need withApiAuth() ? The example doesn't include a post request that uses .from to insert or update data

hey guys, my storage bucket is set to public and it has universal read, write access in policy but when i get the public url with from.getPublicUrl is says permission denied

So I want to add for simplicity for example a list of colors for a user in a join table user_colors. If I insert/upsert this part is from front end so js list ["red","green","blue"] or whatever and then I want the user_colors to remove the ones that I dont send and keep/add ones I do so if on front end toggle off blue and maybe add purple so new list is ["red","green","purple"] I was trying

supabase.from('user_colors').match({user_id: some_user_id}).delete() and supabase.from('user_colors').insert([{user_id: some_user_id, color_id: "red"},{user_id: some_user_id, color_id: "green"},{user_id: some_user_id, color_id: "purple"}])

however I get error that I cannot do two operations on same row aka deleting red and adding red. perhaps I need to not that red and green are maintained and use .not on the delete for those? In which case how can I chain methods of nots in a loop

supabase.from('user_colors').match({user_id: some_user_id}).delete().not('color_id', 'eq', 'red').not('color_id', 'eq', 'green')

I assume is how i do then just upsert. But I have js list so how can i do for color in colors loop to add .nots in chain. And if better way lmk thanks!

Anyone here try to use .hcl file in supabase postgres to self-host db?

I cant change my email after signing up

Hello @reemwn! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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.

Hi, repeatedly getting a "Database connection error" message when trying to access my Supabase storage

Hello, I have a question, that may be trivial, but I want to be a 100% sure about it. So, is Supabase free when I host in on my own infrastructure and not on their Cloud?

hey, the free limit includes two projects per org right?

How to get a particular row via curl API, say I want record Id '4' from the table. Till now I am only able to fetch the entire rows but can't filter according to needs, I was wondering if it was possible in Supabase. Thanks

Thoughts on building a tiktok-clone with supabase as a backend... I am planning to build a tiktok-clone and I would like to use supabase as a backend. Suppose the app has 100k active users, and there are 10k short videos uploaded per day. Specifically, my concern is: W.r.t. overall performance, what could be some limitations of using supabase vs. custom backend (e.g. nodejs) for this type of app? P.S: Having a third party service (in this case google) is not much of a concern. Also CDN for videos will be used with another cheaper provider.

Hello! Is it possible to host a supabase instance not on app.supabase.com ? It's super super expensive.

Hello guys was trying to connect to my database hosted on supabases cloud platform and I get this "pg_dump: error: connection to server at "db.auhyzrrxpfclurkokwpj.supabase.co" (54.163.105.38), port 5432 failed: Connection timed out (0x0000274C/10060)"

Hey team, I have create a csv importer to insert rows in the DB. I have a few issues with it, I tried to bulk insert 100 then 50 then 20 rows at a time which always crash. Doing with 10 rows at a time works fine until you reach the 140-150 rows which crashes. I'm using Nextjs api route to do so. I wanted to check Supabase Postgres logs to see if it was the issue or my actual API route but always have a error code 400... Questions: What's Supabase limitation with bulk import and how to handle them?

Is it possible for supabase api joins to infer a relationship between two tables without explicit foreign key relationship? Or is there a way to annotate that? For example I have a shop_id row on shop and person table but I get

Could not find a relationship between 'shop' and 'person' in the schema cache

.

@silentworks (sorry to ping you, but I think you mostly manage the auth-helpers repo?) I wanted to poke around and maybe contribute to the library to improve the next.js integration. One question I had was, is it possible to use the SSR version of the access token to establish a connection with supabase subscriptions? What I noticed was this: 1.

getServerSideProps

has a token and fetches the user, with a certain token 2. Calling

supabaseClient.from().on()

does not work unless I do

useUser()

and wait for that user to resolve which uses another token. I was hoping to look into the

<UserProvider user={}

prop to see if I can maybe pass in the user and token and fix #2 above

Hi everyone! Someone knows how to scale supabase? I just have 100k users and everytime my supabase instance is down. I am supabase pro.

hey! so while updating data in supabase, is it possible to update elements in an array? like updating array elements inside an object with specific key. supabase-js specific

Is there a roadmap for graphql features?

I set up supabase db as a subscriber to another postgresdb using logical duplication. It works on my local supabase instance and another VM I was testing it on. Is there any reason the prod supabase db wouldn't work as a subscriber for logical duplication?

Hi Guys, I turned on real time updates for my tables but when i make a post request it does not update instantly

Is there a way to delete from the auth.users table? We want to add the ability for a user to delete their account so I tried writing a PostgreSQL function which works from the query console, but calling it from the client side using rpc gives a permission error. We also have a users table in the public schema separate from auth.users, but if we only delete from the public users table you can still sign in so we don't want that behaviour.