Is there an equivalent REST API for await supabase.auth.getUser()?

Hi, I was considering making an issue on the gotrue github, but it might be a small issue so I'll ask here first. I was following along with the contributing guide here: https://github.com/supabase/gotrue/blob/master/CONTRIBUTING.md And I got to this step:

To setup the database schema via Soda, run:
make migrate_test

And I'm running into this error:

{"level":"warning","msg":"WARNING: SAML is an incomplete feature and should not be enabled for production use!","time":"2023-01-05T12:15:07-05:00"}
{"level":"fatal","msg":"running db migrations: Migrator: problem creating schema migrations: couldn't start a new transaction: could not create new transaction: failed to connect to `host=localhost user=supabase_auth_admin database=postgres`: failed SASL auth (FATAL: password authentication failed for user \"supabase_auth_admin\" (SQLSTATE 28P01))","time":"2023-01-05T12:15:07-05:00"}
exit status 1
make: *** [Makefile:28: migrate_test] Error 1

Which makes me think that I need to change the database URL to something other than the default, but I don't know what I'm supposed to use:

c
GOTRUE_DB_DRIVER="postgres"
NAMESPACE="auth"
DATABASE_URL="postgres://supabase_auth_admin:root@localhost:5432/postgres"
API_EXTERNAL_URL="http://localhost:9999"
GOTRUE_API_HOST="localhost"
PORT="9999"

Any ideas?

I have a

forgot.svelte

page where users can, if they forget their password, ask for a password reset email (MagicLink) in order to sign in and update their password. (I'm use Supabase Auth Helpers.) I've got the email part working—Supabase signs them in when they click the link. But I'm not sure where and how to, in this case, redirect the browser to the

reset.svelte

page... Like, in what file would I potentially add a

throw redirect(303, '/reset');

? THANKS!

I’m trying to connect prisma to the DB. I set

DATABASE_URL=connection string

.

prisma migrate dev

timed out. I tried

psql <connection string>

, while following the supabase prisma guide. I get

psql: error: could not translate host name "pswd@db.bloop.supabase.co" to address: nodename nor servname provided, or not known

I tried with a different service, not supabase, and the migration worked. I wanted to use supabase for as much as possible, not just auth, but am I understanding correctly from all the posts here that prisma & supabase is not presently the simplest combo around? Any clues?

When I press Save, it duplicates the table just fine with the correct row headers, but zero data is being transferred. Does anyone know a fix to it?

Is it ok to use supabase-js on clients like React Native or it's better to have an API as a bridge where supabase-js is used to query the DB?

This is a general question about best practices: What are the pro's and con's of using the Supabase SDK in api routes which then connect to Supabase vs using the SDK directly client side?

Currently trying to get all events based on start and long_event_end. Haven't found a way to do this. Before I separate and make it into another function I wanted to ask if there is a way to make it work

So, I before this I had have no errors trying to make this relations (i am using prisma btw).

Hello , I am having trouble deleting from storage with bucket name files. I believe its a RLS policy issue. I have tried adding the policy below after snooping around online but am getting pg.policies error. the file currently resides at public/files/uid() Do I need to target it as public/files? If so what is correct syntax

-- Make sure the policy applies to the files bucket only
bucket_id = 'files' AND
--  Make sure they can only access their own folder within that bucket
(storage.foldername(name))[1] = public::text AND
-- Check the file name of the file and only allow delete if it matches the name below
storage.filename(name) = auth.uid()

Thank you

Hey y'all, I'm a little confused as how best to store percentages, I have 2 use-cases: 1. Storing global tax rate percentages, from this link https://pgsql-general.postgresql.narkive.com/WxnWlSls/best-data-type-to-use-for-sales-tax-percent (where they also mentioned Los Angeles is 9.75%, so 0.0975) I figured

numeric(5,5)

seemed reasonable, which from what I understand couldn't be

>=1

right? 2. "General" percent in the sense that I want to be able to for example have 3 rows with each storing 1/3 which should add up to 100%. 0.3333.. wouldn't really work right, so either one has to be more like 0.34 so it add up to 100 or I store it differently? 1/3 is just an example, could be 1/2, 1/5, 3/5 etc.

I am using the "import from URL" option in Tableplus, so all the details should be correct, but I receive this error when I try to connect.

Hi there, I was curious about why I'm seeing differences in responses from API calls depending on WHERE the API is being called from. I have a very simple API call that is run BOTH on the client AND server:

ts
import { client } from "$lib/util/supabase";

export const load = (async ({ url }) => {
    const { data: user, error: err } = await client.from('athletes').select();
    console.log(client, user, err);
    if(err !== null) throw error(parseInt(err.code), err.message);
    return { user };
}) satisfies LayoutServerLoad;

The log on the server shows exactly what I expect:

[
  {
    created_at: '2023-01-05T21:11:27.669346+00:00',
    avatar: '***',
    first_name: '***',
    last_name: '***',
    id: 18611857
  }
] null

But on the client I get something completely different:

[] null

I printed the client on both sides to see that I got the same thing, but it seems that one of the clients doesn't have an Authorization header?

ts
createClient(PUBLIC_SUPABASE_URL, PUBLIC_SUPABASE_ANON_KEY, {
                global: {
                    headers: {
                        Authorization: `Bearer ${token}`
                    }
                }
            })

headers: {
      Authorization: '***',
      'X-Client-Info': '@supabase/auth-helpers-sveltekit@0.8.6'
    }

vs

headers: {
      'X-Client-Info': '@supabase/auth-helpers-sveltekit@0.8.6'
    }

I have a

clients

table, and an

on_auth_user_created

trigger to copy some of the data over to a public

user_profiles

table. For simplicity, the

user_profiles

table has an

id

, a

user_id

, and a

client_id

. A user should only be able to access the client that their

user_profile

links them to. The following policy will not let me query any clients. Currently,

clients

is the only table that I have RLS enabled for. What am I missing?

pgsql
create policy "Users can access the Client they are assigned to"
  on clients
  for all using (
    auth.uid() in (
      select user_profiles.id from user_profiles
      where client_id = clients.id
    )
  );

I am having issues connecting to my DB via PgAdmin. I am getting the error message:

INTERNAL_SERVER ERROR: 'ServerManager' object has no attribute 'user_info'

What can I do about this?

Was working on Deno with Twilio to send a sms message while the message went through but the res was 502 from Supabase edge function… not sure what went wrong…. I didn’t use the ‘serve’ method so is it a must to use like the sample here: https://github.com/supabase/supabase/blob/master/examples/edge-functions/supabase/functions/restful-tasks/index.ts?

Hi folks! I'm unable to delete the user 🤔 Have you an hint?

Hi, is there any way to modify user sessions, either through the auth/sessions table or through a function in the supabase library? I would like to create a feature where a user can manage their sessions and sign out of certain sessions they do not recognize (or all sessions if they please) but I am not sure if this is possible through supabase auth.

When creating a policy from the template to delete, the condition is auth.uid() = user_id. When saving the policy and then editing it again, the "auth." part is stripped out, and it shows (uid() = user_id). First I thought maybe it is just converting old api to new api or something, but when I inspected the table in database directly, it show the rule (auth.uid() = user_id), with the "auth." part still there. Is this inconsistency intended, and why is it so?

Hey guys, i want to populate user_id in my messages table, this is the realtime subscription i have:

React.useEffect(() => {
    const messagesSubscription = supabase
      .channel('message-channel')
      .on(
        'postgres_changes',
        { event: 'INSERT', schema: 'public', table: 'groups_message' },
        (payload) => {
          setMessagesData((oldMessages) => [...oldMessages, payload.new]);
        }
      )
      .subscribe();

    return () => {
      messagesSubscription.unsubscribe();
    };
  }, []);

Specifically, it shows a relay error in invoking the function. Any clue why this might be happening?

Hello everyone, Supabase looks interesting for my app but I'm wondering what would happen if my free tier has exceeded? Would they send me a mail to upgrade to next tier of €25 a month? Do they also have some kind of DDOS protection?

Hello 🙂 i use my google account to authorize my supabase account and create databases account . Yesterday my google account has been desactivated . My supabase is ok . But , for more security i want to change my supabase account to another google account ; How can i do that ?

Hi Community, I just did the Flutter tutorial (https://supabase.com/docs/guides/getting-started/tutorials/with-flutter) and I quite enjoyed working with Supabase. I encountered on issue: If I login with the magic link, then log out and then make a hot reload from the IDE, the deep link workflow seems to run again (the link seems to be cached somehow) and I am logged in again. It does not seem to be a production problem: If I log out, then quit the application and start it again, it does not happen. I also could not reproduce it on the web application, only on the MacOS variant (I did not yet try out the iOS / Android variants). I am not sure if I am doing something wrong or this is some unexpected behavior, maybe even a bug in Supabase or the underlying AppLinks package? Kind regards, Alfred

Hey I'm wondering whether entries from

audit_log_entries

can safely be deleted to regain disk space. At the moment its taking up over 60% of our disk which is not really favorable imo. Thank you!

So ive setup login and session refresh within our iOS app, but whenever I try to log in with

auth.signIn

or

auth.refreshSession

, this error is thrown :

Swift.DecodingError.dataCorrupted(Swift.DecodingError.Context(codingPath: [StringCodingKey(stringValue: "user", intValue: nil), StringCodingKey(stringValue: "identities", intValue: nil), _JSONKey(stringValue: "Index 0", intValue: 0), StringCodingKey(stringValue: "created_at", intValue: nil)], debugDescription: "Invalid date format: 2022-11-25T00:00:00Z", underlyingError: nil))

I would like to also query a foreign table, while listening *(only) * to the primary table. We know the listen doesn't provide a parameter for foreign query.

dart
await supabase.from('documents')
  .stream(primaryKey: ['id'])
  .listen((List<Map<String, dynamic>> data) {
  // Do something awesome with the data
});

Respect to that, so should I do like this?

dart
await supabase.from('documents')
  .stream(primaryKey: ['id'])
  .listen((List<Map<String, dynamic>> data) {
   // final salesIDList = get all sales ids;
   await supabase
    .from('sales')
    .select()
    .in_('id', salesIDList);
});

Hi! I have a query that is super slow, especially compared to all the other ones I have around. If someone could help me optimize it, it would be lovely Here it is:

sql
select battle.season
from battle
inner join team on battle.id = team.battle_id
where wizard_id = 2175612 
AND battle.public IS TRUE
group by battle.season

It takes sometimes more than 2s to respond!

I am trying to add some additional meta data to a given user but whenever I call the supabaseClient.auth.updateUser function (which is successfully updating the user), the client's JWT doesn't get updated. I've tried calling refreshSession() after the update call, but the session still doesn't update on the client. Any ideas of what I am doing wrong?

Hi, I am trying to allow users to login to google and get redirected to the dashboard in my next js project. I try the following, yet it redirects the user to the index page with a bunch of query parameters (localhost:3000/#access_token=....):

js
await supabase.auth.signIn(
      {
        provider: 'google',
      },
      { redirectTo: '/dashboard' }
    );

Any idea whats happening here?