Hey all 🙂 I'm trying to migrate my supbase DB from cloud to my on-premise environment with no success does anyone have good tutrial for it?

Is there a way to redirect to a specific route on login? Like, for dev it's http://localhost:3000 but could you make it http://localhost:3000/dashboard. The authorised redirect urls don't seem to do anything with routes?

can someone please help me in #894719731133722644? Really just want to solve my problem and get on with it lol

I'm having trouble with migrations too

hey guys, is there any way that i can add different scopes to discord oauth?

Ah of course. Thank you so much!

hey, when upserting data using the js client - can i specify multiple colums for the onConflict event? 2 fields for example, 1x primary key and 1x a unique constraint

I just upgraded from supabase-js v1.21.0 to v1.24.0, and am now receiving a breaking error on page load:

./node_modules/@supabase/supabase-js/src/lib/helpers.ts
Module parse failed: Unexpected token (11:38)
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file. See https://webpack.js.org/concepts#loaders
| }
| 
> export function stripTrailingSlash(url: string) {
|   return url.replace(/\/$/, '')
| }

Is this a bug I should open with the repo? Edit: I downgraded to v1.23.0 - right before that function was introduced - and the error is gone now. I'll leave it here for the time being.

Hi!!👋👋 Anyone know a way to search through multiple column? I tried this below but has not worked haha 😅

Hi everyone, how are you? I have a problem calling rpc function "If a new function was created in the database with this name and arguments, try reloading the schema cache" How can I reload the schema cache?

Hi! I'm developing an application using Supabase and I love it. Coming close to a production release and was thinking now would be a good time to set up a local environment for me to keep developing things when we go live. I've managed to set up a local development of the postgres database using the Supabase CLI and Docker. Is there a simple way to migrate over my tables from the Postgres databas that Supabase hosts to my local Postgres-db? ANSWER: Answering my own question if someone else is interested: I used pg_dump to take a dump of my postgres database that runs on Supabase with the following command:

pg_dump \
  -h db.REF.supabase.co \
  -p 6543 \
  -U postgres --schema-only \
  --clean --if-exists --schema=public \
  > supabase_schema.sql

The problem I had was that I had to specify port 6543, even thou my Supabase UI presented a different port.

maybe you can use a front end for the database? like beaverdb, pgadmin or datagrip for dumping your db

js
const image = useRef()

const file = image.current.files[0];
const { data, error } = await supabase.storage.from("image-posts").upload(file, {
  cacheControl: "3600",
  upsert: false,
  });
if (error) alert(error);

I cant seem to upload an image to a storage bucket, i get the error "[object Object]".

And the image reference is being used on a

input type="file"

.

From what i know, you can login the user on the server, and send back the token to the frontend and store it in localstorage. The , with every request, you need to use the jwt secret to decode the token and check if it is still valid, then make the query to the db to send that specific data

Question. I’m a fairly new developer trying to wrap my head around things. I have a table with many items. For each item, I need to schedule a cron job. It needs to be@by item since this cron takes about 4-5 seconds per item. As it uses Puppeteer to scrape a value. Stack: Nuxt SSR with Supabase. Deployed on Vercel What would be the best way to go around this? I know it’s not directly Supabase related, but there are some smart folks in here :). Thx in advance.

how do i run a query like

SELECT DISTINCT name FROM users

using supabase-js?

as in I want to avoid any repetition of data

might be wrong, but i dont think that's possible from supabase-js. you could create a postgres function that does that and call it with RPC

They should really add a way to send a query, it seems that we can only do the most basics things right now

doing that would probably make the database susceptible to SQL injection

It could be by an opt in basis

ah alright, thanks

don't schedule the cron job for each item, set it to run in an interval, do whatever it is in concurrent batches or batches or just one after the other, depends on your resources and your expectation of how performant you want it to be. I didn't get what you meant by be@by item, but if you mean that each item has a very specific time when you should process it, then depending on whether or not you can control that time you could make sure that all your items follow a pattern ex: they'd only require processing every 5 mins. If you can't control it at all, try to find the lowest time gap between when the processing should happen and set the interval of the cron job to that period of time aka try to keep it at 1 cron job at best.

Cron questions

The GUI database tool feels very beta to me right now. For example, I have a simple table. I get a warning that no primary key is selected. I edit table, make the uid column the primary key. Operation completes successfully. I open the table again, for some reason changes not saved?

Hello! Is it possible to enable RLS and only let authenticated users insert in your db without giving permission to get? I tried to add that, but if i don't add a read policy, it throws me

new row violates row-level security policy for table "contact

You need to set the returning option to 'minimal' to stop the insert from also doing a select to send data back.

Oh, i missed that in the documentation. Thanks a lot!

Hey, I'm using phone signin OTP without password to sign in on our app and I noticed that the max JWT expiry is 1 week. Is there a way to let a user keep making requests without having to verify their number every week?