has anyone created an otp pin system with using verification by Email vs. Phone?

I asked about this some time before phone auth was added, and the response I got was that phone auth was the first step, and OTP would be a possibility later on. It's already sort of possible to build your own, but it doesn't link in directly with auth - it essentially involves logging the user out if they fail OTP, so it's a front-end hack and wouldn't be something I'd recommend

thanks @User - we were considering building one ourselves but to your point, it might be too much to manage, (especially if they plan to ship it in the near future)

Hi, everyone. Can anyone help me regarding types for typescript of User object returned after authentication process?

Has anyone come across the "Error getting session from URL." in an Expo/React Native project? I see the error as soon as I create a Supabase client and I am no longer to do anything with Supabase in my application.

Are you sure your URL (probably in

.env.local

or similar) is correct?

https://github.com/supabase/gotrue-js/blob/master/src/lib/types.ts

typescript
export interface User {
  id: string
  app_metadata: {
    provider?: string
    [key: string]: any
  }
  user_metadata: {
    [key: string]: any
  }
  aud: string
  confirmation_sent_at?: string
  recovery_sent_at?: string
  action_link?: string
  email?: string
  phone?: string
  created_at: string
  confirmed_at?: string
  email_confirmed_at?: string
  phone_confirmed_at?: string
  last_sign_in_at?: string
  role?: string
  updated_at?: string
}

Yup! Super sure. This has happened to me on two separate Expo projects using Supabase -- I set everything up (copying the set up from the expo-todo-list example), everything works for a bit, I log in and out a few times, and then eventually reach this error and am stuck.

Thanks a lot. I also found out that the type for user is exported from "@supabase/supabase-js" as "AuthUser".

How can we push new data in a row of type json array without affecting the previous data ? For eg. I have the data as follows

[{id: '1" , name: "John Doe"}]

So how can i make it like this

[{id: '1" , name: "John Doe"} , {id: "2" , name: "Jane Doe"}]

Can anyone pls help with this ?

This is for supabase specific questions fyi. But I think what you are looking for is

ts
const arrayName = [{id: '1', name: 'John Doe'}]
arrayName.push(...[{id: '2' , name: 'Jane Doe'}]);
console.log(arrayName)
// [{id: '1', name: 'John Doe'}, {id: '2' , name: 'Jane Doe'}]

Should something like this work?

ts
await supabase
  .from('posts')
  .update({ valid_until: `now() + interval '30 day'` })
  .eq('id', postId);

valid_until

is of type

timestamp with time zone

Edit: It would appear not... What's the best way to achieve this?

json
{
  "hint": null,
  "message": "invalid input syntax for type timestamp with time zone: \"now() + interval '30 day'\"",
  "code": "22007",
  "details": null
}

Doing

.update({ valid_until: 'now()'})

works... but the psql datetime operator won't?

Thank you for your response Will definitely try it out

Timestamp with later date in update function

Is there a method to get the URL the supabase client will fetch, but not actually make the fetch? e.g. for supabase .from("statements") .select("*") .eq("poll_id", pollId); I would like to return "https://my.supabase.co/rest/v1/statements?select=*&poll_id=eq.967065f5-1145-45da-865d-246bc719a6fc" The reason I want this is there are some URLs I want to prefetch in my like:

Hi everyone, before can I use

client.from('table_name').on('INSERT', (data) => {
  console.log(data)
}).subscribe()

do I need to install the

@supabase/realtime-js

? Cause I'm inserting something in my database but nothing on my console.

No - the

@supabase/supabase-js

library includes support for all client-facing features of Supabase. Make sure you've enabled subscriptions for the table you're subscribing to (check the Database > Replication page in the dashboard)

Thanks @User it's working now...

How do I access my database via Next.js API when using RLS?

there are a couple of nextjs examples here: https://github.com/supabase/supabase/tree/master/examples

None of them query the database via api routes though

hey everyone, does anyone know why is supabase including a

#

at the end of my

redirectTo

url?

Why is supabase including a hash at the end of redirectTo

Hey everyone, how do i get the accesstoken of a user after the user clicks the magic link and redirects to the site?

Thank you.

I'm first redirecting to my API route to the cookie and then send it to the page

Hi all 🤘! Working on my app in Nuxt (first app ever, its exciting and scary) And I need to count the amount of visitors on each profile page. I’m migrating from Firebase. And they have a counter with sharding on Cloud Functions. 1. How many writes a second can Supabase handle? 2. Any ideas on the best way to implement this? Do you set like a 30min cookie as session and increment the page view? 3. Very new to Supabase and Postgres so love to get any pointers on incrementing a “Visitors” column. And if you can do so at scale

I figured it out with this guide; https://codebycorey.com/blog/page-views-nextjs-supabase

Hello, anyone have a stack Redux + Supabase ?