Hello, I'm trying to install supabase on our repo, but running the cli installation codes resulted in an error:

admin@AFVFHGQBRQ6L7 AIKnowledgebase % npm install -S @supabase/supabase-js
npm ERR! code ERESOLVE
npm ERR! ERESOLVE could not resolve
npm ERR! 
npm ERR! While resolving: class-variance-authority@0.4.0
npm ERR! Found: typescript@5.0.4
npm ERR! node_modules/typescript
npm ERR!   typescript@"5.0" from the root project
npm ERR!   peerOptional typescript@">=3.3.1" from eslint-config-next@13.2.4
npm ERR!   node_modules/eslint-config-next
npm ERR!     eslint-config-next@"13.2.4" from the root project
npm ERR! 
npm ERR! Could not resolve dependency:
npm ERR! peerOptional typescript@">= 4.5.5 < 5" from class-variance-authority@0.4.0
npm ERR! node_modules/class-variance-authority
npm ERR!   class-variance-authority@"^0.4.0" from the root project
npm ERR! 
npm ERR! Conflicting peer dependency: typescript@4.9.5
npm ERR! node_modules/typescript
npm ERR!   peerOptional typescript@">= 4.5.5 < 5" from class-variance-authority@0.4.0
npm ERR!   node_modules/class-variance-authority
npm ERR!     class-variance-authority@"^0.4.0" from the root project
npm ERR! 
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR! 
npm ERR!

Can you help resolve this? Thanks in advance

How do I add an update policy for my app?

Hi, I am trying to set up an app with nextjs 13 (with app router) and supabase, and setting up authentication for log in/log out with private page routes. I managed to set up a basic POC app using @supabase/auth-helpers-nextjs and @supabase/supabase-js. The problem is that when I log in, the cookie created is readable by javascript on the browser. (i.e. type "document.cookie" in the console.). Where can I change the cookie options such as httpOnly, secure, maxAge, etc. so that the cookie cannot be read by the front end,etc.? I am not sure if this is nextjs or supabase settings. Just for your refence, here is my repo https://github.com/nfabacus/supabase-nextjs13-example-app. Thank you in advance. 🙂

I am new to Supabase. Just now migrated from Firebase. As i am trying it out on free plan. I saw that unwanted egress data is seen in the Supabase console its way more than the amount of data i have in my database. Please help me out here

I'm trying to implement an app and am worried about supabase's scalability -- specifically pertaining to inserts, updates, and deletions. What are the practical write rate limits I should expect with a pro account on this platform? or with an enterprise account? For clarification, my concerns stem from the fact that supabase uses postgres, a relational db whereas I understand document based dbs to be generally faster due to ease of horizontal scaling and the nature of eventual consistency.

I am trying to create a filter where the returned rows don't contain any of the provided values. The documentation https://supabase.com/docs/reference/dart/not says I need to provide raw postgrest syntax for the

not

filter. This is what I currently have:

dart
     return baseQuery
            .select()
            .not('my_column', 'cs', '{"value1", "value2"}')
            .select();

but this returns rows where any of the following statements are true: 1. contains "value1" and not "value2" 2. contains "value2" and not "value1" 3. does not contain "value1" and not "value2" How do I change the query so that I only get the 3. result? Replacing the

cs

operator with

in

throws an error:

PostgrestException(message: "failed to parse filter (not.in.{"value1","value2"})" (line 1, column 5), code: PGRST100, details: unknown single value operator not, hint: null)

I am trying to upload a blob to my avatars storage bucket but i keep getting POST ERROR 500 and am trying to make sure if its not a problem from my side

I'm writing a flutter app which uses Supabase as its backend. I'm using the bucket and messaging functionalities the following way, a quite standard one:

dart
  await Supabase.initialize(
      url: dotenv.get('SUPABASE_URL'),
      anonKey: dotenv.get('SUPABASE_ANON_KEY', fallback: ''),
      debug: false);
  FirebaseMessaging messaging = FirebaseMessaging.instance;

  NotificationSettings settings = await messaging.requestPermission(
    alert: true,
    announcement: false,
    badge: true,
    carPlay: false,
    criticalAlert: false,
    provisional: false,
    sound: true,
  );

...

    final downloadedTraining = await Supabase.instance.client.storage
        .from('general')
        .getPublicUrl('trainings/2023-04-17.pdf');
...
    final dt = await Supabase.instance.client.storage
        .from('general')
        .download('/trainings/2023-04-17.pdf');
...

And now I would like to mock the storage in order to always return an expected result when performing the e-2-e tests with patrol. Is it possible mocking just what I need i.e. storage.from('...').download? How can I achieve it? The two ways I've figured out are: - create a mock client you can give it to supabase when

initialize

is called (slow and complicated: you should check all the API calls and mock them) - adopting Dependency Injection, creating an interface and implement it one with Supabase, and another one with a mock (mockito or so) Supabase's IA talks about a

supabase_flutter_test

library, but I think it's totally wrong 😅

OS: Ubuntu 22 Node: 18.16.0 Error: https://ale.kto-pytal.pl/u/3BujEM Full response is in file https://cdn.discordapp.com/attachments/1112004885773299802/1112004885932671076/message.txt

I upload a file:

ts
        const { data, error } = await supabase.storage.from('attachments').upload(`attachments/${uniqueString}`, file.bytes, {
            contentType: file.type,
        })

How I get the id of the storage object uploaded?

Hi there, I ran a prisma db reset and forgot that it trashes the permissions on supabase and I was unable to create new users as there was permission denied on schema auth. The app also stopped working due to permission denied on public. I followed some guides online but they are all out of data and don't account for supabase_admin role not being modified and the presence of supabase_auth_admin. Is there an up to date guide or SQL command to fix and then verify the permission?

Hi there, I want to define the RLS policies in code instead of using the UI. I saw that the feature is not yet in Prisma but is being worked on (https://github.com/prisma/prisma/issues/12735). Is there a better way to define these without using Prisma or the UI for now? I could always write some .sql files but that is kind of a kludge.

Good Day. I have a trigger that calls a function which updates a table row. I'm having issues figuring out the policy. It works when RLS is off. Only the system, which I thought would be

postgres

but that doesn't work (the way I'm using it). I'd also like a policy that will let my app select that table. public.grammar_stats This table get's updated when a user checks the grammar. With this new row inserted, the Trigger fires to update: public.grammar_count which has one row with two columns .id and .total

CREATE OR REPLACE FUNCTION update_grammar_count()
RETURNS TRIGGER AS $$
BEGIN
  UPDATE grammar_count
  SET total = total + NEW.char_count
  WHERE id = 1;

  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

DROP TRIGGER IF EXISTS grammar_count_insert_trigger ON grammar_stats;

CREATE TRIGGER grammar_count_insert_trigger
AFTER INSERT ON grammar_stats
FOR EACH ROW
EXECUTE FUNCTION update_grammar_count();

and this is not allowing an update when RLS is enabled:

-- Create a policy to allow system updates and inserts
CREATE POLICY allow_system_update_grammar_count ON grammar_count
FOR ALL
TO postgres
USING (true);

So any dates coming into my angular app from Supabase are just a string as follows:

created_at: "2022-12-18T10:56:09+00:00"

Is there a way to auto format these through Supabase HTTP settings? or intercept them some how to make them into dates? Currently I'm doing things like this to format nested strings into dates and it's becoming smelly! 💩

findAll$ = () => super.findAll$().pipe(
    map(({data, ...others}) => ({
      ...others,
      data: data && data.map(item => ({
        ...item,
        last_message: {
          body: item?.last_message?.body,
          dateCreated: item?.last_message?.dateCreated ? new Date(item.last_message.dateCreated) : null
        }
      }))
    })
    )
  )

Maybe even if this is something I can set in Postgres?

I have installed supabase and provided the url and api key . I correctly imported it in the following way:

import { createClient } from "@supabase/supabase-js";
const supabase = createClient(supabaseURL,supabaseKEY);
export default supabase;

where the parameters are my URL and KEY assigned to variables I actually wanted a successful login implementation when I click the login button with the email and password it should verify it with the table in the database called User where I have attributes namely, a username and password. I dont' need a new user registeration or a signup , just a basic login function. And if the user entered credentials is equal to that of the ones in the User table then it should be redirected to another page (/homePage). When I ran npm start in the terminal, site loads and in the login page when I click the login button ,it says "invalid credentials" which is written in the following logintrial.js although I provided the same username and password as of in the table. The file called logintrial will be put as an image next to this due to word limit Please provide a good help. Looking forward for the fast reply.Following is each component code : --------fetchUserCredentials.js-----------

import supabase from "../config/client";
const fetchUserCredentials = async () => {
const { data, error } = await supabase.from("User").select("*");
if (error) {
console.error("Error fetching user credentials:", error);
}
return data;
};
export default fetchUserCredentials;

I checked the Python doc and it seems to have no

.is()

api like the JS library. How to you do that in Python?

Can I use Supabase Auth in React and verify the user's token using Python/FastAPI?

I have rpc to update user table I add RLS to turn off update on user table for not making users to update their information , it's work fine but the rpc I have doesn't update table anymore why ?

I'm using

supabase.auth.signInWithOAuth

in SvelteKit with redirectTo set to an api route which does

ts
const code = url.searchParams.get("code");

if (code) {
  await supabase.auth.exchangeCodeForSession(code);
}

with hCaptcha enabled in the auth settings, but I'm getting a

AuthApiError: hCaptcha verification process failed

error whenever someone runs that particular api route (despite the signInWithOAuth method not having any captchaToken parameter in the options)

Is it possbile to use css to style my template email?

I wish to only allow GitHub and OTP auth in my Supabase app

is there a way to change what gets shown here from dgnvviqfnfrqdxuwuyrm to the base URL or something more recognizable?

So I tried this approach - https://github.com/supabase-community/supabase-custom-claims/blob/main/install.sql and discovered that since the set_claim function does not return a trigger it wouldn't show up in the studio. so I rewrote it

CREATE OR REPLACE FUNCTION set_claim() RETURNS TRIGGER AS $$
BEGIN
  NEW.raw_app_meta_data = NEW.raw_app_meta_data || jsonb_build_object('role', 'USER');
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

any thoughts on the pros/cons of the new rewrite. seems to get the job done.

Once I login with my google account there is no way changing it. Clicking on login with google button logins my previous google account and I do not see accounts selection page again. Firefox works fine. Deleting cache and cookies did nothing. Any idea? I am on next js 13.4.4

Should it be possible to generate a signed upload url using a service_role key on the server without any particular policies defined? The following code on a NextJS server side route fails with error

StorageApiError: The resource was not found

.

const { data, error } = await supabase.storage
    .from("user-files")
    .createSignedUploadUrl(filename);

supabase

is an instance of the Supabase client initialized with the service role key as follows...

import { createClient } from '@supabase/supabase-js'

const supabase = createClient(supabase_url, service_role_key, {
  auth: {
    autoRefreshToken: false,
    persistSession: false
  }
})

Looking at the error logs for the Supabase Storage container running locally on Docker I see the following error...

DatabaseError: failed to retrieve bucket
    at new DatabaseError (/app/dist/storage/errors.js:22:28)
    at Database.<anonymous> (/app/dist/storage/database.js:105:35)
    at step (/app/dist/storage/database.js:33:23)
    at Object.next (/app/dist/storage/database.js:14:53)
    at fulfilled (/app/dist/storage/database.js:5:58)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
  status: 406,
  postgresError: {
    code: 'PGRST116',
    details: 'Results contain 0 rows, application/vnd.pgrst.object+json requires 1 row',
    hint: null,
    message: 'JSON object requested, multiple (or no) rows returned'
  },
  metadata: { bucketId: 'upload' }
}

Weird because the list operation on the same bucket works fine, not sure why bucketId is "upload" in the metadata section above either. Anybody have any ideas?

Hi everyone, I’m trying to put a storage limit on users’s accounts, so that they can only upload a certain amount of items until their space runs out. And I’m trying to make that amount free up when they delete items. I know I can make a column with how many gigabytes they have in their plan, but how can I actually enforce it with storage? The way it’s currently setup, every user only has access to a folder with their user Id on it. Thanks in advance for the help!

Hello everyone, I need help that. I've added github login on my website but can't find how can i create a condition with session. I use typescript btw my github login component:

ts
"use client";
import { createClientComponentClient } from "@supabase/auth-helpers-nextjs";
import { Session } from "@supabase/supabase-js";
import { useRouter } from "next/navigation";

async function AddCommment() {
  const supabase = createClientComponentClient();
  const router = useRouter();

  async function signInWithGitHub() {
    const { data, error } = await supabase.auth.signInWithOAuth({
      provider: "github",
    });
  }

  const handleSignOut = async () => {
    await supabase.auth.signOut();
    router.refresh();
  };

  return (
    <div className="mt-10">
      <button
        onClick={() => {
          signInWithGitHub();
        }}
      >
        Sign In
      </button>
      {/* if user logged in */}
      <button onClick={handleSignOut}>Sign Out</button>
    </div>
  );
}

export default AddCommment;

Hi, As the title implies, the restoration process is taking almost a day to restore the project and the amount of data is really low. I don't want to delete the project since I've defined schemas, triggers, etc... What do I do?

Hi, new user here 👋 I am trying to setup a project with a single table such that * any user accessing my project from their browser can perform a

SELECT

(they do not need to login) * users will never write to the database * there is a GCP Cloud Function that performs a

DELETE

and

INSERT

to my table Given this setup, should I use the

service_role

API key for my Cloud Function? Or would it make more sense to setup a custom role? If the latter is the case, I suppose I would have to setup a policy that checks for a predefined

email

field, and also handle refreshing the JWTs every once in a while. I didn't really see a section for service accounts in the docs, so I wanted to know how other people would handle this setup. Thanks in advance 🙏

am getting this error that i cant seem to find a solution for [AuthRetryableFetchError: Network request failed]