Hey, I'm looking to set up a following / followers system in Supabase and I was wondering what would be the best way to set up my data. Is the answer in the Stack Overflow still the best approach using Supabase? Thank you! https://stackoverflow.com/questions/19734154/followers-following-database-structure

Creating a following follower system

Does anyone know how to create an infinite scroll component based on Supabase

I mean, what modifier should I use

https://supabase.io/docs/reference/javascript/range 🙂

I'm so stupid

Thanks

😓 I honestly don't understand how the range helps create an infinite scroll... I'm probably missing lots of context here

Infinite scroll, paging

How can I query public urls from storage objects?

I need a way to delete objects whose public urls are not in my profiles table

I don't think this way is workable

There are just too many rows

I am trying to run cypress for e2e tests, but I am struggling with resetting the supabase db. How can I delete all users. Do I have to use the api? The best case scenario would be that I could use db-migrate, write a simple SQL statement "DELETE FROM auth.users", but I get an "not owner of relationship" error, which makes sense since I am using the normal postgress user account. Does anybody knows a way around that?

Hello, trying to select 1k records with node and failing, but can get from UI. How to debug??

You maybe reached the maximum rows. You can change the setting in Settings -> API -> Max Rows

I can get 518 rows, but the limit with 519 meets timeout... Limit in settings 10k

I didn't change anything. Just noticed CPU isn't loading as before

Deleting users using a migration script

Hi guys, I'm looking to use supabase hook but from the blog it says that it is available on new projects. My project was made around march, is there a plan/a way to make the supabase hook available on old projects? or do i have to create a new one

What is the correct way to delete storage objects with a trigger? I need to delete files "attached" to a note when the note is deleted and would prefer not to do it from the client as someday will need to delete a user, then auto delete all notes in a function. Is just deleting the row in the storage.object table sufficient or will that leave the file stored on the "s3" bucket? edit: Adding my own research... this is not possible currently (very sad). This Github discussion has more info: https://github.com/supabase/supabase/discussions/3124 make sure to read entire thread as the original solution (delete the entry from the storage/object table does not work. You have to do calls to the storage api.

Supabase hooks

Answering my own question: you can join the storage.objects table to profiles by the unique key and then delete nulls to remove any objects not in use.

I have a question regarding authentification with supabase goTrue. I need to support a third party provider which offers oAuth2 and OpenID connect. Unfortunately it is not yet directly supported by supabase. What do I need to do to integrate an unsupported auth provider in my supabase project? Firebase does support a general oAuth2 authentication flow but I would prefer not to go back to Firebase. Related github issue (not by me): https://github.com/supabase/gotrue/issues/159 If I create a PR (with tests 😉 ) to add a rather niche third party auth provider ORCID (big in research community), will it get merged?

does supabase select have support for pagination?

Pagination with Supabase

Yes, have a look here: https://supabase.io/docs/guides/auth/auth-twilio

What is the easiest way to get an RSS feed based on changes in a supabase DB? (Zappier and Integromat only support Firebase atm).

How do you write integration tests for a supabase project? Is there a guide somewhere? Do you replicate the same project and run tests against the replicated project?

Hi all, First of all, sorry if it's not the proper channel. I've been learning how to use supabase and React, and I'm facing a problem. Currently, I'm building a react app, and I want to develop the following flow: 1) a supabase admin invites a user through email (using the dashboard); 2) the user clicks on the link to accept the invitation and logs in; 3) if it's the first time, the user will be asked to insert a username and a password. Otherwise, he is redirected to his homepage. To achieve that, I developed a

PrivateRoute

, and I'm using React Context API for listening authentication events (

supabase.onAuthStateChanged(event, session)

). So, I'm facing some issues with properly redirect the user. The invite URL has the ``/`` path ("http://localhost:3000"), and I'm redirecting ``/`` to ``/home`` with the latter being a PrivateRoute. And the PrivateRoute behaves this way: ``if(user){ return } else { return }``. But for some reason (almost certainly my fault), it's not working properly because the user is logged in, but he keeps on the login page. I think that the listener has some sort of delay, and there's no user on the PrivateRoute, so the user sees the login page, and only after that is logged in. I tried to explain my problem as best as I can, and I know it's a bit confusing, but I appreciate your help. Thank you!