Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

link shortener Ex. https://api.julianp.xyz/r/9dcf68ce

Is there a way to change the URL to a custom name?

see https://github.com/supabase/supabase/discussions/2925

Is it a dumb idea to make an api to put data in supabase?

What kind of api ? A backend api or a frontend api? (when i'm saying "frontend api" i'm talking about mapping api routes in a simple file with methods)

I started to make an api which has a job of CRUD operation on the db

But I think I wouldn't need this if I use Supabase?

For corner cases an api would be useful since Supabase still does not have serverless functions.  Although with Postgres functions you can solve a lot of use cases as well.

I would like to implement my custom logging via a private logs table (e.g. I can then insert records inside that logs table during the exection of triggers to get visibility into trigger executions).

In addition to a log message, I would like to associate some metadata to the log: some JWT attributes (e.g. the sub), the session id and transaction id. The reason I want a session and/or transaction id is to be able to identify that a set of logs which were generated during for the same logical operation. For example, if a trigger invokes several other functions and each of those functions logs something, I would like to be able to identify that the logs are from the same logical operation.

With all that in mind, I have 4 questions:
 - If we focus on the high-level goal described above, does this approach seem reasonable or is there something I am missing?
 - Do triggers get invoked with the same JWT as the JWT of the operation which invoked the trigger? If NOT, is there any way to link the trigger to the user which started the invoking operation?
 - Given that the supabase client goes through PostgREST - how does PostgREST handle sessions? Is it one session per user or is it more complex than that?
 - If I understand correctly, read-only operataions do NOT have a transaction id (since they don't need a transaction) - is there something similar I can use to identify the sub-operations of such operations?

btw, I plan to use pg_backend_pid() and pg_current_xact_id_if_assigned() in order to retrieve the current session and transaction id

Hi there. There'is going some problem with emails sending service? Im not receiving emails after sign up, but i have the users in my auth table as waiting for confirmation

Seems so. Magic link emails have been arriving in batches many minutes (20-30) after request. Also have not received new account verification emails at all. My best guess is that some emailing pipe is a bit clogged from the earlier reported outage on the status page.

I am getting 500 error during signup

```
{
  code: 500
  error_id: "30ba66b2-57b0-45c7-ba89-bd7f1239e62c"
  msg: "Error sending confirmation mail"
}
```

It seems like their email system is down or something

its been like that past few days for me too. It was working briefly then broken again

Any word from the mods etc on when it might be fixed or what the issue is?

Are there plans to make the database do local/remote sync like firebase does, where I can edit the database locally and the changes will *eventually* propagate to the backend?

I wouldn't expect this short term if ever

better to just start tracking your schema in your repo

and then using some ci pipeline to automate

I mean if I make a change I have to wait for the network request to ensure it completes, but with Firebase it appeared as if it was instant. I can update my html instantly, but I can't be sure the data will persist if the user presses delete in the meantime.