Hi, im trying to get data by date, but im getting this error

js

  const startOfMonth = spacetime().startOf('month').format('iso');
  const endOfMonth = spacetime().endOf('month').format('iso');

      const { data: statisticsData } = await supabase
        .from('url_data')
        .select('*, clicks(*)')
        .eq('slug', slug)
        .filter((query) => {
          return query
            .gte('clicks.created_at', startOfMonth)
            .lte('clicks.created_at', endOfMonth);
        })
        .single();

Hi I'm using svelte and supabase with a multi-user blogging CMS site. The images are stored (and user-uploaded) in Supabase. I have a single component that displays the image differently depending if it's in the post view/edit, or in the grid of cards. Is it possible to use supabase image transform to pull two different image sizes? Currently I have this - is it possible to add another transform there, or do I need to make a different function for the other size? export const getImage = async (url: string) => { const { data, error: downloadError } = await imageBucket('images').download(url, { transform: { width: 320, height: 144 } }); if (downloadError) { throw downloadError; } return URL.createObjectURL(data); };

Hello, I'm trying to create a new table in the public schema. But it seams I'm not allowed. I don't think I have done anything in particular regarding permissions to mess it up. If I create a new project it all works as expected. I'm using the hosted version Any help would be much appreciated.

I'm trying to upload data with a single script that updates one table with another table. For this to work I need an id common to both tables. So I make 1first call to my "companies" table, and the results are uploaded. Rows are created But no id **is returned to me via response package (**so I could use the table ID as joint for my next call). Actually it seems that no Data is returned. This is what my terminal is sending back (node:5836) Warning: Setting the NODE_TLS_REJECT_UNAUTHORIZED environment variable to '0' makes TLS connections and HTTPS requests insecure by disabling certificate verification. (Use

node --trace-warnings ...

to show where the warning was created) { error: null, data: null, count: null, status: 201, statusText: 'Created' } I did follow the instructions and tried either .single() or .select() to have a response back. But nothing came Here is my trial code for a single row insertion, that **DOES create a new row in my Supabase table But gives me no response in terminal.** const fs = require('fs'); const csv = require('csv-parser'); const { createClient } = require('@supabase/supabase-js'); const SUPABASE_URL = "" const SUPABASE_ANON_KEY = ""; process.env.NODE_TLS_REJECT_UNAUTHORIZED = "0"; const supabase = createClient(SUPABASE_URL, SUPABASE_ANON_KEY); async function insertSingleRecord() { const newCompany = { name: 'Test Company', country: 'Test Country', company_website_url: 'https://testcompany.com', founded: 2000, industry: 'Test Industry' }; const { data, error } = await supabase .from('companies') .insert(newCompany) .single(); if (error) { console.log(

Error inserting data: ${error.message}

); } else if (data) { console.log(

Inserting company data: ${data}

); } else { console.log(

Unexpected response: ${JSON.stringify({data, error}, null, 2)}

); } } insertSingleRecord();

I am facing this issue when try to sign in user using

signInWithTokenId

(google). Anyone has any idea? I am using this package to login my user via google and get the `idToken`: https://github.com/react-native-google-signin/google-signin

hello everyone , i have a problem with resumable method , this is my code and the file gets uploaded to supabase but it shows this error to console , the error:- HEAD https://myprojectid.supabase.co/storage/v1/upload/resumable/Y29udGVudC9sZWN0dXJlLnBuZy8zZThhYmQ2Yy0yMWM3LTQ4ZmItOTFlZi1hMDNlZGFhYWQ3M2Q 500 my code:- const uppy = new Uppy().use(Tus, { endpoint: supabaseUploadURL, headers: { authorization:

Bearer ${userJWT}

, }, uploadDataDuringCreation: true, chunkSize: 6 * 1024 * 1024, allowedMetaFields: [ "bucketName", "objectName", "contentType", "cacheControl", ], }); my rls for the bucket is this:- CREATE POLICY "dw 1tghu4n_0" ON storage.objects FOR UPDATE TO authenticated USING (bucket_id = 'banners'); idk what the error is but my file gets uploaded but i dont want any console error

Hello, I am trying to reset password form our app using the client:

tsx
   const { error } = await supabase.auth.resetPasswordForEmail(email, {
      redirectTo: '/update-password',
    });

But this is the link we get in our email:

https://PROJECT.supabase.co/auth/v1/verify?token=ABCD&type=recovery&redirect_to=https://our.domain.com/

We expect to see

&redirect_to=https://our.domain.com/update-password

We have setup in the supabase auth/email section these emails: Site URL: - https://our.domain.com/ Redirect URLs - https://our.domain.com - https://our.domain.com/** Why would supabase not respect the

redirectTo

parameter?

All of a sudden, I started seeing a massive number of re-renders (see screenshots) and it seems like this is due to the session getting invalidated consistently. Not quite sure where to start debugging this, so any pointers would be helpful here! Versions:

"@supabase/auth-helpers-nextjs": "^0.5.2",
    "@supabase/auth-helpers-react": "^0.3.1",
    "@supabase/auth-ui-react": "^0.3.5",
    "@supabase/gotrue-js": "^2.13.0",
    "@supabase/supabase-js": "^2.2.0",

how to get env vars in edge functions with dart?

dart
import 'package:flutter/foundation.dart';
import 'package:flutter/material.dart';
import 'package:flutter_riverpod/flutter_riverpod.dart';
import 'package:spacevault_cash/constants.dart';
import 'package:supabase_flutter/supabase_flutter.dart';
import 'package:supabase/supabase.dart' as supabase_;

import '../services/supabase_service.dart';

class TestPage extends ConsumerWidget {
  const TestPage({Key? key}) : super(key: key);

  @override
  Widget build(BuildContext context, WidgetRef ref) {
    final user = ref.watch(userProvider);
    print(supabase.auth.currentSession);

    // Use the user variable here
    return ElevatedButton(
      onPressed: () {
        ref.read(supabaseProvider).auth.signInWithOAuth(
            supabase_.Provider.github,
            redirectTo: kIsWeb ? null : authRedirectUrl);
      },
      child: Text(user != null ? 'Logged in' : 'Login'),
    );
  }
}

I'm having trouble authenticating users when using the web client. When clicking on the button, the user gets redirected to github. After entering valid credentials, the users gets sent back to the application, however

supabase.auth.currentSession

prints

null

. However, I can see the access_token in the url bar, so it should actually have everything it needs. Any Ideas? PS: This works fine for iOS and Android

I'm a bit confused on how to pass meta data into postgres functions because I keep getting null value's, for context this is a supabase project using sveltekit auth helpers.

js
        const { error } = await supabase.auth.signUp({
            email: form.data.email,
            password: form.data.password,
            options: {
                data: {
                    username: form.data.username
                }
            }
        });

        console.log(error);

sql
create or replace function public.handle_new_user()
returns trigger
language plpgsql
security definer set search_path = public
as $$
begin
  insert into public.profiles (user_id, username)
  values (new.id, new.raw_app_meta_data->>'username');
  return new;
end;
$$;

If I created a new table in another schema, then move this table to "public" schema, GraphQL does not know this table exists. Worse, if I delete the exisiting

public

schema, and rename another schema to

public

, then nothing works.

select graphql.rebuild_schema()

is no longer availalbe

Hi. I'm trying to connect to Supabase vis Tableplus and I'm getting this error

connection to server at "db.XXXX.supabase.co" (9.9.9.9), port 5432 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?`

I've changed nothing since I last logged in a week ago. Any ideas why this might be? (API access is working)

Hi, I am writing a policy to only allow users whose roles (a string[]), inside the

app_metadata

property, contains a string 'internal-admin'. I have written the following so far, but am unsure as to check if that array contains one property (it can contain many properties btw).

pls help lmao

Im using supabase DB with prisma, and also supabase auth for the users. I want to integrate the Supabase auth users /schema into my prisma. I found this: https://supabase.com/docs/guides/integrations/prisma#using-supabase-auth-with-prisma But I didnt find it informative enough. For example, how can I develop in my localhost DB if my users only exist remotely in supabase auth? Should I run supabase locally? Basically looking for an extensive guide to integrate Prisma with Supabase Auth so I can connect my user table with my other tables. Thanks!

I went back to an older project and proceeded to migrate from 0.8 to 0.9 of the @supabase/auth-helpers-sveltekit library. I see much better now the advantages brought by the 0.9# version. However, I have a question about what is the best practice to access the DB from a component or any .ts file. For example, before I used to do the following:

ts
import { supabase } from '$lib/db/supabase'
import type { BrdElem } from '$lib/types'

export async function updateBrdElemPos(brdElem: BrdElem): Promise<void> {
    const { error } = await supabase.from('element').update({ pos: brdElem.pos }).eq('id', brdElem.id)

    if (error) console.log(error)
}

However now supabase is defined in the +layout.ts file. It makes it really easy to access via

load

in the "+" files, but I don't know how to access it from regular .svelte or .ts files.

i am using nextjs 13 with

/app

,

supabase auth

&

supabase/auth-helpers-nextjs

. when i log in, the

user data

and

session

are being stored in the

local storage

and i don't want them visible for the user in the console. Moreover, how can i increase the

cookie's max-age/ expiry date

.

dart
import 'package:flutter/foundation.dart';
import 'package:flutter/material.dart';
import 'package:flutter_riverpod/flutter_riverpod.dart';
import 'package:spacevault_cash/constants.dart';
import 'package:supabase_flutter/supabase_flutter.dart';
import 'package:supabase/supabase.dart' as supabase_;

import '../services/supabase_service.dart';

class TestPage extends ConsumerWidget {
  const TestPage({Key? key}) : super(key: key);

  @override
  Widget build(BuildContext context, WidgetRef ref) {
    final user = ref.watch(userProvider);
    print(supabase.auth.currentSession);

    // Use the user variable here
    return ElevatedButton(
      onPressed: () {
        ref.read(supabaseProvider).auth.signInWithOAuth(
            supabase_.Provider.github,
            redirectTo: kIsWeb ? null : authRedirectUrl);
      },
      child: Text(user != null ? 'Logged in' : 'Login'),
    );
  }
}

I'm having trouble authenticating users when using the web client. When clicking on the button, the user gets redirected to github. After entering valid credentials, the users gets sent back to the application, however

supabase.auth.currentSession

prints

null

. However, I can see the access_token in the url bar, so it should actually have everything it needs. Any Ideas? Just for context: This works fine for iOS and Android

Seems like using the useUser hook in Nextjs 13 with pages dir causes a crash on any browser (Firefox, Brave) when i keep it at the top of the component. So something like:

typescript
   export default function Dashboard() {
    const supabaseClient = createBrowserSupabaseClient();
    const [loading, setLoading] = useState(true);
    const router = useRouter();
    const user = useUser();

causes the tab to crash when switching between any tab and the Supabase app tab

I am really struggling getting my oauth redirect to work. Context: Nextjs (pages directory) I18next for localization using auth helpers having my redirect urls setup. I want my users to sign in/up through a modal, once they sign, they should be redirected to

baseurl/locale/dashboard

before clicking on sign in with google the url looks like this:

baseurl/locale

once signed in the url is

baseurl/locale#

It never goes to

/dashboard

, despite having it setup properly in my redirect URLs with and without wildcards Any idea how I could solve this? Could it be because the auth occurs in a modal? Could it be because of the locale being loaded a soon as the page refresh? Thanks

Hello, I have setup a waitlist table with 4 policies, the users are supposed to only have access to insert themselves into the table, however I couldn't find a way to do it without also offering them public read access in my policies, so I need some help with the function & policies. I am also trying to trigger an error message if the user email is already on the waitlist, for that I had to use a rethrow so that my " if (e is PostgrestException && e.code == '23505') { _isEmailAlreadyRegistered = true;" works, otherwise it will not get triggered but that causes the user to always receive a snackbar error upon succesful signing up for the waitlist.

Is there a way we achieve this kind of functionality? I have an “updated_at” column that should get updated by a service role, or some automated process, but the user should not be able to manually update this column, only read them. Any ideas?

Hi team, How we can add both email and phone for the same user and verify both with otp. And user can log in with otp if he adds either an email or phone number. This means both are passwordless. Thanks

I want to know, when I build a project using supabase and self-host. as a owner of project I got a super user having ability read all of users data. I think some private data of users even though the super user can not read that. I find the option named "user bypasses every row level security policy", I want to turn off for super user which user I enter the supabase local studio .

Serving functions with legacy supabase/deno-relay:v1.6.0... Run functions serve instead to use Edge Runtime.

why is it saying legacy?

Hello, I tried to create a user after the auth automatically. I write this function: handle_new_user, Schema public, return type trigger BEGIN IF NOT EXISTS (SELECT 1 FROM users WHERE id = NEW.id) THEN INSERT INTO users (id, email) VALUES (NEW.id, NEW.email); ELSE UPDATE users SET email = NEW.email WHERE id = NEW.id; END IF; RETURN NEW; END; And I create a trigger: on_auth_users_created, schema auth, table user, function handle_new_user, event : After insert, Enabled mode : Origin Do you know why it doesn't work?

I have at least 10 - 30 tables anywhere between 500,000 rows to 2.5 million rows of data and doing it through the graphical interface in Supabase keeps failing either due to "Too Many Request" or an encoding error. The Too many requests makes sense but than is there a way to combat that? where i can automatcially get it to sync up with the correct filed types like Supabase does ? But the encoding error boggles me - is there a best way to encode to make uploading this amount easier and more efficient ?

I am trying to insert information to a public.users table on every signUp so i added a trigger and a function but am getting an error after signing up

There was already a post in here regarding this issue, https://discord.com/channels/839993398554656828/1098545559926739098. The problem now is that it seems to have stopped working again. The error I'm getting looks like this:

Version 1.30.3 is already installed
Bundling verbesserer
Error: Error bundling function: exit status 1
file:///D:/Users/Matthias/Desktop/Development/web/verbesserer/supabase/functions/import_map.json
error: Uncaught (in promise) Error: Error: Die Syntax für den Dateinamen, Verzeichnisnamen oder die Datenträgerbezeichnung ist falsch. (os error 123)
      const ret = new Error(getStringFromWasm0(arg0, arg1));
                  ^
    at __wbg_new_8d2af00bc1e329ee (https://deno.land/x/eszip@v0.35.0/eszip_wasm.generated.js:513:19)
    at <anonymous> (https://deno.land/x/eszip@v0.35.0/eszip_wasm_bg.wasm:1:1522549)
    at <anonymous> (https://deno.land/x/eszip@v0.35.0/eszip_wasm_bg.wasm:1:1398157)
    at <anonymous> (https://deno.land/x/eszip@v0.35.0/eszip_wasm_bg.wasm:1:1895031)
    at __wbg_adapter_40 (https://deno.land/x/eszip@v0.35.0/eszip_wasm.generated.js:229:6)
    at real (https://deno.land/x/eszip@v0.35.0/eszip_wasm.generated.js:213:14)

Which is more or less similar to the post linked, but even though the update to eszip v0.35.0 is in, it still doesn't work. Maybe there is something wrong on my end? I'm running the latest version of supabase-cli (

1.62.3

)