ja it is

that is why i asked

@User See https://supabase.com/docs/reference/javascript/supabase-client, there is a c# client

ok thanks for sharing that with me, I did not know about that

one

but when i use

useState()

i can console log my data but then get a object error

I am randomly getting cloudflare error when accessing supabase postgrest api. I simple table with 30 columns text and int, 50000 rows total, set to return max 600 rows. No useful error logs in Logs section on supabase dashboard

Hey everyone, I am a noob on backend and I am in the process of learning it. I have a following usecase and I am looking for some guidance how should I approach it. I have a third party API URL that stores on backend. It should run for every 1 hour and results from the API should store on backend. API in table A-> Periodically Run -> Store results in table B For me storing the api url on the db is straightforward, I am having hard how to approach the next step. Any help is appreciated 🙏

You can use GitHub Actions or Netlify Scheduled Functions to periodically run a webhook, which would make the required supabase calls to move data from Table A to Table B https://docs.github.com/en/actions/using-workflows/events-that-trigger-workflows#schedule https://github.com/netlify/labs/tree/main/features/scheduled-functions/documentation

Thank you @User 🙏

@User were you able to resolve this? I seem to be running in to the same issue

I've also been running in to a 522 error the last day or so but the logs don't really indicate why it's happening I've tried restarting the server, but no dice. Anyone run in to this and have any idea how to fix or where to start looking?

Cloudflare error

So as previously stated, I'm a noob in databases (here to learn ^^). I have a query with an inner join to grab some data from my supabase db. The table has "a lot" of rows (but not really, around 10k) . The query takes A LONG time to execute. What would be the best way to debug that. Details in thread

no body know this?

I mean: at the login of the user, the user get an access_token generated automatically from supabase, is possible disabled an specific access_token forcing the user to login again?

I don't think so? Isn't that the magic of JWTs? I haven't tried but you can add a disabled column and check in RLS ?

@User I'm pretty sure you can invalidate tokens. How exactly, I don't know 😅

On supabase only refresh_tokens are saved on DB

you can revoke an refresh_token of a specific user, this will force him to login again at expire of access_token

in my case I need revoke che access_token and refresh_token to force him to login again

Note: One downside of JWTs is that they are not easily voidable, like session tokens. If a JWT is leaked to a malicious actor, they will be able to redeem it anywhere until the expiry date is reached – unless of course the system owner updates the jwt_secret (which will of course invalidate everyone's existing tokens).

Yeah exactly, unless you have a blacklist somewhere the JWT is valid until it expires

exactly

but on supabase we don't have the AT stored on DB

so... this is the issue ehehe

or... if is stored on DB, Im not founding it xD

What's AT ?

access token

Ah ok