What do you mean here by 'used with Supabase' and call 'Supabase directly'? Like the managed postgres database? So the client can query the database using Supabase/postgres row level security?

@User please create a thread so it's easier to keep track of your conversation.

I have never used a trigger. This is in the docs ?

Looks like it vanished from docs

https://github.com/supabase/supabase/discussions/306#discussioncomment-138424 this would be an example

Using Supabase for time series data

hiii

Hi there! Does anyone know for how long refresh tokens are stored in auth.refresh_tokens table? Or do they stay indefinitely?(and if so, is it safe to delete the old ones?)

Hi guys

is will have custom sign up function available in the future? like user_id + password signup, or even anonymous signup or use ip address sign up?

Hi there! How long does it takes to restore my data from paused project ?

Hello, all! 👋 Question on generated TypeScript types and foreign key relations:

I followed the instruction in the docs to generate my types (https://supabase.io/docs/reference/javascript/generating-types). It looks like the types don't include any foreign key relations, though.

Example: In my codebase, I have a

rule_channels

DB table with a

rule_id

column.

rule_id

has a foreign key relation to table

rules

on column

id

. I query for rules like this in my codebase:

import type { definitions } from '../../../types/supabase';

const { data, error } = await supabase
  .from<definitions['rules']>('rules')
  .select(`
    id,
    words,
    rule_channels (
      channel_id:channels ( id, title )
    )
  `)
  .eq('id', ruleId)
  .single();

But attempting to use the data that comes back results in this TypeScript error:

Property 'rule_channels' does not exist on type '{ id: number; words: string; created_by: string; updated_at: string; }'.ts(2339)

Does anybody know if there's a way to get foreign key relations included in the generated types? I hope so, otherwise having to manually compose/define them myself kind of defeats the purpose of automatically generating them

Hey guys, is there a doc for function?

Functions are not released yet. You can register here to be notified when it does: https://supabasesubscribe.vercel.app/subscription/functions

Someone recently released a tutorial on pairing Netlify functions with Supabase tho, if you want to check it out: https://twitter.com/supabase/status/1429505918471921674?s=20

Hey everyone 👋 i am wondering where i should put my discord handle on my GitHub Profile to unlock the Sponsors Channel ?! Just in this freeform Bio field 🤔

since auth v2 exists

does that mean there is also a /auth/v2/callback

is there an example or Documentation on how to migrate current user base to Supa? I have a MySQL DB that want to migrate to SB as a new table and link the users to the auth.user table. Any suggestions on where to find more info about it?

Hey So i have a Nuxt app, using nuxt-auth. On my login page, i have the following:

async fetch() {
    const user = await this.$supabase.auth.user()
    if (user) {
      return await this.$router.push('/shifts')
    }
  },

However, when the user is redirect back, user is not set. I have to refresh the page again for it to be set. I am guessing there is some race condition here. Does anyone know a way to resolve this?

right now, auth system can be login multiple time and without signout or check ip address or something else that can prevent confusion or malicious operation happen

that have no other way at the moment to solve? is that planned to be implement some sort of func that can check whether this user login-ed? check its ip address?

hey guys if i want to delete a row that has a foreign key to another table ( many to many relationship join) do i have to delete that one first? cuz right now im getting a foreign key constraint error. or is there a way to delete both at the same time

Freeform bio on Github, I think :) I believe the contributor role is handed manually. At least, that's how it was when I joined here :)

Ah, i see, thanks  😊

Yes correct its a manual process, if you link me to your PRs I can add the role for you.

hello! supabase gives you the array from select based on most recently updated in my experience. is there a way to have the return data sorted by original creation date rather than updated date?