I’ve been going through the interface, this is my first project using supabase, or any sql database

Sure that's normal

Honestly I haven't used the interface that much and since I'm in my bed that's going to be hard to help you right now 😂

Thank you for the resources though, I really appreciate it

The docs are really great

There is a crash course from Traversy media on YouTube, I think that would be great for you to get started

I did watch that, however I’m trying to build an express server with node using this as the db, and he only really goes into the routes, not the library

if i hosted my own version of supabase, that would also include a self-hosted version of the storage buckets, right?

re-read the self-hosting guide and yes it does

Has anyone had success with the Swift + Gotrue SDK? It crashes the app as soon as I create a user or try to log in. There’s not much documentation, so I’m not sure if I’m implementing it correctly.

yeah create a profile table for that and link with auth table https://supabase.io/docs/guides/auth/managing-user-data

i tried that, but then when i went to enter the User ID i get the error: invalid value for foreign key to 'users.id

Hey there! I have a question regarding twitter authentication. If I enable my Twitter App to be able to post tweets or DMs how would I actually do that after I authenticated with Twitter in Supabase? I mean yeah, I am logged-in in my app and I have a user & a session but how do I perform authenticated requests to the Twitter API after that, where do I get the credentials I need for a Twitter API-request. Example header:

--header 'authorization: OAuth oauth_consumer_key="YOUR_CONSUMER_KEY", oauth_nonce="AUTO_GENERATED_NONCE", oauth_signature="AUTO_GENERATED_SIGNATURE", oauth_signature_method="HMAC-SHA1", oauth_timestamp="AUTO_GENERATED_TIMESTAMP", oauth_token="USERS_ACCESS_TOKEN", oauth_version="1.0"'

Hi how to cast in Supbase?

js
const { data, error } = await supabase
        .from('phones')
        .delete()
        .eq('id', CAST(phone.id as INTEGER))

CAST not working in Supabase

hi so I have this profiles table that supabase created for me, does anyone know how to access the notes json inside this for example?

Hey all - does anyone have any suggestion how best to delete data from a table programatically. For example, in my table, I have a jsonb field and in that theres an event date. I'm trying to find the best way to delete any rows where this field is over a week old. Im using Next.js so cant use cron jobs on the server

Hey! You have to parseInt, CAST does not work there, try this parseInt(phone.id);

user id need to be UUID type to build the foregin key

Is there is a way to get all online user in supabase project? SQL? API?

it is type uuid, when i go in and try to edit the foreign key relation in supabase i just get a blank slider screen

Mike92988 issue

Are saved queries in the SQL editor deleted after some time? I can't find the ones I saved a while ago. Maybe that's because my project has been paused because of the inactivity

this is our fault Florian - they are only saved to Local Storage at the moment - we will fix this in the next 1 month.

that's fine 👍

Hi how to resolve typescript error Typescript: invalid input syntax for type integer: "undefined"

ts
declare interface Phone {
  id ?: number | undefined;
  user_id ?: string | undefined;
  is_active ?: boolean | undefined;
  type ?: string | undefined;
  phone ?: string | undefined;
  description ?: string | undefined;
  created_at?: Date | undefined;
  updated_at?: Date | undefined;
}

const deletePhoneById = async (phone: Phone) => {
  const { data, error } = await supabase
        .from('phones')
        .delete()
        .eq('id', phone.id)
}

A bit hard to say with just the info provided

But i would say you are trying to delete a phone entry from the database with id: 'undefined'

my guess is that phone.id is not defined

maybe log the phone object to check it

Before you try to run the request, make sure to check if

phone.id

is truthy. You're asking the db to delete a field based on an int, but possibly passing undefined