since ten hours

seems like everything is back, maybe it's the support who fixed it (not the first time lmao)

to everyone, make backup, not like me lol

Production and development supabase

#ASK How i can use a deeper relationship in Supabase, for example, i have daftar_layanan, sub_bagian, bagian table which daftar_layanan was related with sub_bagian and sub_bagian was related with bagian. So i want to call

bagian.name

column from bagian table with daftar_layanan table which is looks like this :

daftar_layanan.sub_bagian_id:sub_bagian => sub_bagian.bagian_id: bagian => bagian.name

But i got a error :

can't access property "name", layanan_r2.sub_bagian.bagian is undefined

My Query Code :

ts
return defer(() => this.supabase.from<DaftarLayanan>('daftar_layanan').select(
      `id, created_at, nama, deskripsi, cover, link,
      sub_bagian_id, sub_bagian:sub_bagian_id (name, bagian_id, bagian_id:bagian (name))`,
      { count: 'exact' }).range(start, end)

can I transfer supabase project ownership yet?

when I do a query in supabase: let { data: accounts, error } = await supabase .from('accounts') .select('*') .eq('api_key',api_key) when i eq by api_key returns null if not found, and when I do it with email returns empty array if not found, why ??? it should return the same either it is null or an empty array

🙏

looks like email is a varchar and api_key a uuid

the error returns is:

error { message: 'invalid input syntax for type uuid: "c786d178-f426-4320-95f1-1a8bca851e5eZ"', code: '22P02', details: null, hint: null }

ok I was generating the uuid with javascript and inserting it into a supabase uuid4 property, and it looks like it allowed me to do it, but it works wrong when you try to query it

Now a proud owner of some supabase swag 🎉🎉🎉🎉

Anyone have thoughts on Supabase vs. a dedicated backend? I am learning a lot right now. I learned a little supabase and thought: this is the answer! Then I learned about linking cloudflare workers to a database and thought, "this is the answer". I suspect it's some of A and some of B. What do y'all think? When do you go straight from the frontend to Supabase and when do you have a dedicated backend?

Hi folks - Is there a way to login using GitLabs instead of GitHub? Why only one way to login?

Is anyone can see my database contents with an API query with my public key?

Or this thing can be done with SQL Editor policies?

Your account has reached its free project limit Your account can only have a maximum of 2 free projects. You can only choose paid pricing plan. I think these limits should be removed. max 10-20 etc Firebase is my reason for going right now.

Hey folks, if I wish to add some complex business logic that I don't want to expose on the client; then is there any provision supabase to handle that logic on the platform or I need to create my own server and use supabase sdk functions there? Example: I want to calculate result by a secret formula (that I cannot show on client) I take data and perform some operations and update on the Table. To do this, how shall I proceed? Would appreciate help. Thanks

GitLab for logging into Supabase

Project limit

Complex business logic

Hello , I'm a university student working on exam project, I've searched the net and asked my other dev friends about a solution for my necessities, which are : - Having a database containg a simple table with information for a file - An actual storage linked to the database which will serve files to the database user Supabase seems to cover both my needs, I'm new to the postgres DB and it's features since the only experince I had is with Orcale SQL so I'm utterly failing to understand how it works for users. What I'm trying to do is simple: 1) Create a user/role for postgres database with username and password for each new user. 2) Let the user log in via SCRAM url string ( using python ) 3) Let the user read and search the database table for file metadata ( containing AES public keys for decrypt a file) and get the corrisponding path /link to the file in the storage bucket 4) Let authenticated user get the corresponding file from the storage I'm failing at point 1 right now since I cannot grasp how the supabase user system works, for instance I don't need OAuth or even email sign ups, so I've disabled them all. In the tab Roles I can see all roles/user for the database but cannot add one or edit these roles. I'm just needing a working set-up for a proof of concept, nothing too sophisticated. Thanks for those who can point me in the right direction.

Supabase vs Oracle

Hi is there a way on updating password without logging in?

Is Supabase down for anyone else?

I'm getting this when trying to view pages on the backend: Error: [500] connect ECONNREFUSED 54.145.248.113:5432

logs look like this, everything returns a 503

Hi! Just join this server. Where can I ask stuck questions? Can't see the channel...

So quick question, with supabase hosted, how does the whole dedicated instance work on a technical level? Do we get a dedicated AWS EC2 instance, or is it like a docker container on a instance, or something like that?