ts
import type { PostgrestResponse } from '@supabase/supabase-js';
import { getSupabase } from '@supabase/auth-helpers-sveltekit';
import type { Database } from '$lib/types/database.types';
import type { PageLoad } from './$types';
import { redirect } from '@sveltejs/kit';

type Message = Database['public']['Tables']['messages']['Row'];

export const load = (async (event) => {
  const { session, supabaseClient } = await getSupabase(event);
  if (!session) {
    throw redirect(303, '/auth/login');
  }
  const { data: messages }: PostgrestResponse<Message> = await supabaseClient
    .from('messages')
    .select(
      `
    message,
    created_at,
    profiles (
    id,
    username
    )
  `
    )
    .eq('id', event.params.id);

  if (!messages) {
    return { messages: [] };
  }

  return { messages };
}) satisfies PageLoad;

Type 'PostgrestResponse<{ message: any; } & { created_at: any; } & { profiles: ({ id: any; } & { username: any; }) | ({ id: any; } & { username: any; })[] | null; }>' is not assignable to type 'PostgrestResponse<{ created_at: string; id: string; message: string; userId: string | null; }>'.

Does anyone have an example of using Remix for User Sign up and Server Side Logic? I've seen the example in the Remix repo on how to do signIn etc which is fine, but struggling to get my head around how to do sign up and SS logic, whilst keeping the sessions in sync. As an example, I have a sign up form which takes username, password, and some other details. I want to use the SignUp Method from supabase, but then I need to create a row in a profiles table to populate it with that user, some other fields, and then make a call to Stripe.

Is it possible to change config's directory? So that it's located in

src

, maybe?

Hi, quick question: I created an internal admin tool in retool. However, images don't load directly as they have to be signed first. This signing process is very slow. The images are not public, but Retool has admin access to supabase. Is there a way to get the images directly or what is the recommended pattern for this?

I'm not sure where the issue is here, except it's OAuth related. This is not in regards to the supabase-js

signInWithOAuth

redirectTo

option - I'm just passing in the provider with the test repo. I'm using Sveltekit's

goto()

in the

onAuthStateChange

function, after events fire, to do my redirect. I've created a repo you can use to test this yourself. https://github.com/j4w8n/sanity (because I'm about to lose mine) Clone, install, npm run dev or whatever. Open a browser and dev tools console at http://localhost:5173 If you click the

Email Login

button, it signs you in and properly redirects you to /app. Click

Logout

button and you go back to the homepage. All is well. Now try the

Github Login

button (I can delete your user later, no problemo). You may notice the browser console log 'Navigating to /app', but it never happens - at least not on my machine. It's being interrupted somewhere. Different browsers do different things. Firefox will show vite reconnecting. Chrome shows it's navigating to the homepage. In both instances, you can usually see that it's trying to go to the "redirectTo" url twice - the supabase project's base url in this case, since we aren't setting it in the signIn function. However, I've passed-in this option while testing in other projects, and that's what shows up twice. Does it work for you? I cannot figure this out. I've even tried a 1.0.0-next.xxx versions of sveltekit which allowed me to downgrade to vite 3.2.0, and supabase-js 2.0.0. Still have issues. Which is strange, because I don't recall having issues with this in the past with supabase-js v2. I've even tried it on my mac, because I've been using a new Windows laptop and thought that had something to do with it.

Is one cell a query? Is one row a query? If you are saying sending code to take a query from like 50 cells does that count towards how many you can do per minute for the rate limit or is each code Query/Mutation together 1 request?

Example: I have a table called "folder" and another table called "note." Each folder can contain multiple subfolders and notes, and they are connected through a column called "parent_folder_id." My goal is to delete a folder from the "folder" table and have all of its subfolders and subnotes, as well as their respective children, also be deleted. how can i achieve this using Supabase?

Hello, I 've got a problem with redirtect in reset password. The link received opens in browser instead of my app (local or mobile apk). The response is :

json
{
"message": "No API key found in request",
 "hint": "No apikey request header or url param was found."}

I made all steps from the official supabase documentation: https://supabase.com/docs/guides/getting-started/tutorials/with-flutter I also put my poc project to git: https://github.com/Mateusz-92/Test-App-Supabase. Here is a part of my anroid manifest file:

xml
<!-- Add this intent-filter for Deep Links -->
          <intent-filter>   
            <action android:name="android.intent.action.VIEW" />
            <category android:name="android.intent.category.DEFAULT" />
            <category android:name="android.intent.category.BROWSABLE" />

            <data
               android:scheme="io.supabase.test_app_supabase"
               android:host="reset-password" />
          </intent-filter>

and my url configuration from supabase: io.supabase.test_app_supabase://reset-password/ Did anyone have similar problem or has some hints ?

Hello, I have the following tables: contact_tags (id: uuid, client_id: fk uuid, name: text), contacts(id: uuid, name: text, user_id: fk uuid) and user_data(id:uuid). How can I implement a RLS policy where I will check if the inserted client_id is owned by the auth.uid() ? Thanks in advance

Hello, I have the following tables: contact_tags (id: uuid, client_id: fk uuid, name: text), contacts(id: uuid, name: text, user_id: fk uuid) and user_data(id:uuid). How can I implement a RLS policy where I will check if the inserted client_id is owned by the auth.uid() ? Thanks in advance

I am using the cloud version of supabase. Is there a way to connect the cloud postgres db with pgAdmin? I want to be able to inspect the tables, views, materialized views, properly. I could use the SQL-Editor (for creation at least) but it does not really fit all needs I am used to. Any ideas?

Hi, I followed the authentication guide from the official documentation and when I'm trying to check the user's session in a component, it always returns null even though the user is signed in.

I've learned that the Supabase client doesn't support transactions. I've also had issues with other stuff directly using their client. Do people routinely adopt Prisma for interacting with just the DB mutations aspect of using Supabase? It's starting to feel like I will have to do something. Is there a good guide for this? I've only spent a few hours with Prisma. The idea of having to define my schemas in Supabase and then in an ORM config file seems bad. I'd want there to be one single source of truth either way.

Hi Supabase community! 👋 👋 👋 I am pretty new to Supabase and am building a frontend dev platform which will integrate with Supabase. Just curious what apps(internal? customer facing? admin panels? games? or others?) people are building with Supabase.

Hello all, I have a question regarding the correct flow to follow when doing these steps, the goal is this, a user can only have a profile picture, so first we check if that profile has a picture if it does delete it and then we upload the new one, then I try to fetch the new one that has been upload it, right now however this is not working as expected as I don't get the correct updatedDate url, perhaps I am missing something?

Is there a way to send push notifications using supabase

Hi Today i'm experiencing a new issue with RLS. It looks like any RLS with the ``authenticated`` role is not working, returning false. When adding ``anon`` to the list of roles, it is working correctly. Note that i restarted the instance, logout and login again, still have this issue. Any idea?

imported 156 rows from csv to a table, where the

id

col is the primary key and identity, so it is "Automatically assigned a sequential unique number to the column" but i get a error

duplicate key value violates unique constraint "events_id_key"

details: "Key (id)=(1) already exists."

so it's starting to insert rows with id 1 instead of 157. how would i fix this?

I'm currently evaluating Supabase for a new app and i'm pretty intrigued by the whole concept. Especially around the power of safely exposing the db directly to clients vis RLS + auth. But one of my concerns would be a point in the future where a working policy was modified and subsequently broke app usage. Are there any plans to provide some level of version control in order to rollback changes? To kind of add to this, is there any way to possibly preview the impact a new policy or policy change might have beforehand? Maybe through some example queries to run with the new policy temporarily applied. I'd be generally curious if there are any known workarounds for this folks have found, or if it is currently just accepted limitations of the platform.

Is there any documentation on how to use SupabaseJS with pivot tables?

I'm not receiving the password reset to my Supabase account. Anyone else experience this today?

Hey guys, I was using the admin dashboard and I wanted to change the created_at value of my data to one earlier in the year. However, everytime I do it keeps changing it to the previous value. I don't have any custom policies I've created for this so I'm assuming its one of the supabase default triggers casuing it Thanks

Upgraded to Pro and added a custom domain, went through the DNS steps, and Supabase reports “Your custom domain is currently active and is serving traffic”. However, when I try to sign into my Supabase app locally (dev), I get this:

{
  "type": "invalid",
  "status": 500,
  "data": {
    "error": "Server error. Try again later.",
    "values": {
      "email": "me@gmail.com"
    }
  }
}

And I've updated the local

.env

to point to my new custom domain... In production, which is using the old Supabase hostname, auth works fine. What am I missing?

I'm trying to replicate this query in supabase-js which gets a list of teams for which the user has one of the desired roles:

SELECT * FROM teams WHERE data#>>'{roles,user1}' IN ('admin', 'guest')

Where

data

is a

jsonb

column with data structured like this:

{
  "name": "Some Example Team"
  "roles": {
    "user1": "admin",
    "user2": "guest"
  }
}

My closest attempt is this:

const { data, error } = await supabase.from("teams").select("*").in("data#>>'{roles,user1}'", ["admin", "guest"]);

But I get

Token "admin" is invalid. Invalid input syntax for type json.

I've also tried JSON stringifying, appending single quotes around things inside the JS strings, and several other things without success.

Why the avatar is not deleted in my storage if i run this function?

js
await supabase.storage.from("avatars").remove(["testuser.jpg"])

Do i need to setup some policies for this? Because earlier worked fine and now i get this error:

json
{"statusCode": "409", "error": "Duplicate", "message": "The resource already exists"}

For some reason I can't log into the CLI "No connection could be made because the target machine actively refused it."

Hey everyone, I am using the Discord OAuth in my Next JS project and when I try logging in, the session is never instanced. I keep getting null. Am I missing something? I set all the env variables, set up my project in Supabase as docs indicated but nothing yet. Thanks in advance!

I've seen a lot of password reset threads here but it seems there are different ways to implement the password reset flow. I'm using Supabase's AUTH UI to set up an Auth component. The email/password fields are automatically rendered for me to either signup or signin my account. That component also has a "Forgot your password?" link. I clicked on it, entered my email address, got an email with the password reset link and it took me straight to localhost:3000. Here's the question: I know I need to change my Site URL but how does that facilitate the password reset? Where does the user enter the new password from the Supabase Auth component? For context, here's a snippet of my code - in the signin.js page from my Next.js project:

import { Auth, ThemeSupa } from "@supabase/auth-ui-react"; // this is the Auth component that renders the signin/signup form
import { useSession, useSupabaseClient } from "@supabase/auth-helpers-react";
...
const Signin = () => {
  const session = useSession();
  const supabase = useSupabaseClient();
...
  return (
    <div className="container" style={{ padding: "50px 0 100px 0" }}>
      <Auth
        supabaseClient={supabase}
        appearance={{ theme: ThemeSupa }}
        theme="dark"
      />
     )
    </div>
  );
};

export default Signin;

Screenshots to show what the rendered component looks like...see attached.

Hello I’m wondering if there a a way to get a list of tabes I have via a API or via SQL? Thank you!

Is it expected that JSONB columns are converted to strings when queried via the API? For example, if this is my (simplified) schema:

sql
CREATE TABLE foo (id int, data jsonb);

And I have some data in the table:

1 | [[1, 2], [3, 4]]
2 | [[5, 6], [7, 8]]

Then I query it via the API:

sh
curl 'https://<supabase id>.supabase.co/rest/v1/foo?select=*' \
-H "apikey: SUPABASE_KEY" \
-H "Authorization: Bearer SUPABASE_KEY"

The result is the following JSON:

json
[
  {
    "id": 1,
    "data": "[[1, 2], [3, 4]]"
  },
  {
    "id": 2,
    "data": "[[5, 6], [7, 8]]"
  }
]

But I would have expected the

data

value to be a JSON array? Is this the expected behavior or is there something I am doing incorrectly? (edit: sorry, the title poorly worded for a help request but I don't think I can change it)