https://supabase.com/ logo
Join Discord
Powered by
# help
  • m
    Does anyone know how to filter for a timestamp field (query) using the Js api ?
  • b
    12.6 to 12.9 is a security update, not a major release migration
  • m
    Okay found the solution. For anyone interested: 
    select('username ,updated_at').lt('updated_at', new Date(2021, 11, 18, 13).toISOString())
    works or some special keywords work as well 
    select('username ,updated_at').lt('updated_at', 'now')
  • i
    yeah
  • i
    I see only two options
  • n
    i think u might be on old supabase version
  • n
    are you self hosting?
  • i
    Nope, it's hosted on Supabase
  • n
    so maybe you still have older version
  • n
    as far as i know supabase doesnt migrate automatically
  • n
    thats how it looks for me
  • n
    or maybe it's just selectively available for now
  • n
    if i were you i'd check postgres version
  • n
    if it's different than 13.3 then that would mean that idd different projects are hosted on different supabase versions
  • i
    it seems to be v 13.3
  • n
    is still can be different supabase version (i think) but i've no idea how to check that :p
  • i
    do you think I should contact the support team?
  • n
    that's what i would do
  • e
    Just curious, is there a way to extend an Auth session beyond 1 week?
  • u
  • a
    btw, I think u can edit the docker-compose file to bind studio to only localhost: - 127.0.0.1:${STUDIO_PORT}:3000/tcp
  • v
    I probably could have but I didn’t want to
  • v
    I can’t log into studio on a server
  • j
    You should also be able to create the new Date with at timestamp 
    new Date(1640105900 * 1000).toISOString()
    . In this instance you are using the ISO 8601 date format 
    2021-12-05T09:00:00Z
    for the comparison.
  • t
    Hi everyone! Realtime subscriptions (all events) are working for one of my table but not another one. Any idea where this may come from? Both are "enabled" in the replication so I just don't get it. RLS are also set correctly, the bug even happens if I disable all RLS actually. I even tried to duplicate the problematic table, delete the old one. Unsuccessfully... Did this ever happened to anyone else? Thank you so much for your help, I'm about to bang my head against the wall. 🤕
  • k
    Hey guys, when I'm using 
    signIn
    or 
    signUp
    , the 
    error.message
    reads 
    aborted
    . Would you know what's causing that/how to fix it? For reference, here's the code:
    Copy code
    js

const signin = async (email, password, navigate) => {
    console.log("log in called", email, password)
    try {
        const {user, session, error} = await supabase.auth.signIn({email, password})

        if (error) throw error
        alert('logged in')
        console.log('logged in')
        navigate('/dashboard')
    }
    catch (error) {
        console.log("error in signin", error.message)
        alert(error.message)
    }
}

const signup = async (email, password, navigate) => {
    console.log("signup called", email, password)
    try {
        // const {user, session, error} = await supabase.auth.signUp({ email, password })
        const {user, session, error} = await supabase.auth.signUp({ email, password })
        if (error) throw error
        console.log("here")
        navigate('/dashboard')
    }
    catch (error) {
        console.log("error in signup", error.message)
        alert(error.message)
    }
}
  • r
    Hey, 2 questions. 1. How can I get the exported event types? 2. When I subscribe to the delete event type, like so:
    Copy code
    ts
this.supabase.instance
      .from<definitions['games']>('games')
      .on(SupabaseEventTypes.delete, (payload) => console.log(payload))
      .subscribe();
    nothing gets logged. I've enabled full table replica like so: 
    alter table "games" replica identity full;
    but still it doesn't seem to trigger the event for some reason. 🤔
    p
    • 2
    • 24
  • j
    Retrieve vercel projects failed. An error has occured: 401
  • j
    I'm getting this error when trying to use Vercel. Anyone know how to remedy this?
  • p
    how would that translate to a SQL Statement:
    Copy code
    ts
this.supabase.from("boards").select("*, cards(*)");
1...166167168...316Latest