@waptik I'm glad that it helped you, inserts are working fine for me

Yep, I was the one who posted that 😅

Hey, is there any way to send a session refresh_token with a `from().select()`(supabase-js) query to my database i've got a RLS statement that lets users only see their own content, but I would think sending a refresh token or id or something would be the only right way to do this

why does gmail flag the confirmtion mails as dangerous and removes all links? xD

I am doing some testing, and noticed an interesting behavior. I log into my GitHub account using Supabase.js auth. Then I log out. Then I log in with my Twitter account, which has the same email address. What's strange is that I'm seeing the JWT for the GitHub provider come back to my app even when I specify Twitter as the provider. I actually see the app redirect to the Twitter auth page and then bounce back to my app with the GitHub JWT. Is this expected behavior?

Perhaps the system is seeing the Twitter auth come back with the same email as the GitHub profile, so it's then returning that JWT?

Does Supabase do some kind of email coalescing for accounts?

Hi, is there a way to access database usage history? Because my db usage is already at 8mb but I don't remember entering any data except just for playing around

@User That's the default data supabase needs I think. I also have an nearly empty project with only a few bytes of table rows in it. but it's also at 8mb.

well that's a bummer, 8mb/500mb is quite noticeable..

When a user signs up is it possible to send another field to the database along with username and password

@User Kinda, but the 500mb is only for the database, storage and everything is extra. And I think you would have to save A LOT of data to get to 500mb. And then I think it's fair to upgrade.

@Tan Not directly at signup, but afterwards, you can create some custom fields for a user. Look at this example: https://supabase.io/docs/reference/javascript/auth-update#update-a-users-metadata

Sure, but I din't say that it's not fair to upgrade, this stuff is gold man

It's just my precious 8mb database storage..

@User Absolutely! Maybe someone from the supabase team can answer better, what these 8mb are.

@User thanks, I'll take a look at this field

hey everyone im new to webdev so this probably is a very nooby question. im trying to make a small javascript app where you can create a post as a user (only when authenticated). i have a table "posts" and the following frontend code: const postFunction = (event) => { event.preventDefault() console.log("post") const { data, error } = supabase .from('posts') .insert([ { creator: supabase.auth.user().id, text: document.getElementById('postinput').value } ]) .then(() => { fetchPost(); }) } but like this everyone could change "creator: supabase.auth.user().id," to any user right? so whats the right way to do this (so users can only create post with their own uid)? thanks is advance for helping 🙂

Hey @User Everyone started sometimes, no worries 🙂 Actually, in theory, this would be true yes. But when you activate RLS (Row Level Security), only the user that's authenticated with this id in your client can create new posts with his/her id. Read more about it here: https://supabase.io/docs/guides/auth#row-level-security

This video released today by @User will help you with this, its a very good explanation of RLS and he is also talking about a blog post scenario

Hello! Newbiequestion here. Is it possible to rename properties when doing a select request?

const { data, error } = await supabase.from('bets').select(`
    stake,
    profiles ( username ),
    events ( fixture )
  `);

for example rename profiles to profileInfo or something like that 🙂

guess Im looking for the 'as' equivalency

Try

sql
const { data, error } = await supabase.from('bets').select(`
    stake,
    profiles:profileInfo ( username ),
    events ( fixture )
`);

no luck there

Hi, quick question about the Svelte guide: I'm following this: https://supabase.io/docs/guides/with-svelte My rollup.config.js:

js
import { config } from 'dotenv';
import replace from '@rollup/plugin-replace';
import json from '@rollup/plugin-json'
...
plugins: [
        replace({
            __api: JSON.stringify({
                env: {
                    ...config().parsed // attached the .env config
                }
            }),
        }),
        json(),
        svelte({
            compilerOptions: {
                // enable run-time checks when not in production
                dev: !production
            }
        }),
        ...

.env and supabaseClient.js is the same as that guide. This is the error I face:

supabaseClient.js:10 Uncaught ReferenceError: __api is not defined

I'm guessing I'm doing something wrong with rollup.config.js, not able to find what that is :/

hello i need help urgent inside a middleware i cannot get supabase.auth.user() value

I am using nuxt

auth.api.getUserByCookie() when i use this