I deployed an app with supabase my apps most valuable part is the data collection. With the public anon key it seems anyone can just steal all my data records is there a was I can limit the number of api calls based on IP address just to make it little difficult. I have set supabase to return only 25 results per call but still nobody stopping them from grabbing everything in database in set of 25 results at a time. Is it possible to do this inside supabase or I have to write up the limit login in my app with some api keys.

Ok let me try it thank you

Limiting data

Which one is faster for the database, multiple junction tables or one big junction table?

How can I do conditional filter chaining. I am currently using this but it is not good if I want to add more filter options as a form in my app:

js
let searchTerm

if (searchTerm) {
  const {data, error} = supabase.from('products').select('*').ilike('name', '%' + searchTerm +'%')
} else {
  const {data, error} = supabase.from('products').select('*')
}

Filter chaining

I have set supabase to return only 24 items per api call. is there a way to bypass that limit for certain tables? For instance I want the limit to apply across all tables product, images etc. But I do not want the limit to apply on

categories

table.

Hello, I have a project which I'm only using the database, so I'd like to avoid my project of being like Inactive? I would like to maintain it active

Hello, is there a way to use twilio whatsapp authentication ?

Tried self-hosting supabase, but this is what I'm seeing in the API page.

There is an issue about this https://github.com/supabase/supabase/issues/5540

Thanks a lot, working now 👍

Awesome

hi guys i created a table through supabase interface, is there a way i can see it as postgres?

I started having issues with the API to query database views with a foreign key, but only in my production environment, staging which has exactly the same data is working fine

do you know how I can check other things about my project, like if they upgraded it to a version with a bug or something?

Downloading an image from storage returns a Blob. How can I use this inside a

<img />

??

Has anyone experience using supabase with nuxt 3? I can't seem to get it to work. That's my

supabase.client.ts

js
import type { SupabaseClient } from '@supabase/supabase-js'
import { createClient } from '@supabase/supabase-js'
import { defineNuxtPlugin } from '#app'

declare module '#app' {
  interface NuxtApp {
    $supabase: SupabaseClient
  }
}

declare module '@vue/runtime-core' {
  interface ComponentCustomProperties {
    $supabase: SupabaseClient
  }
}

export default defineNuxtPlugin(() => {
  const { supabaseUrl, supabaseKey } = useRuntimeConfig()
  const supabase: SupabaseClient = createClient(supabaseUrl, supabaseKey)

  return {
    provide: {
      supabase
    }
  }
})

But I get the error

[worker] Cannot read properties of undefined (reading 'from')

when calling

js
const { $supabase } = useNuxtApp()

const { data, pending } = $supabase.from('categories').select('*')

Found the issue. The filename was the problem. It can't be

supabase.client.ts

because nuxt only loads it client side because of the suffix

.client

Hi, I feel like I'm going mad with the name of the cookie sent to the server, which is being used by the call supabase.auth.setAuth(token) In GetServerSideProps (Next JS) I had the following code working to get the correct user and access RLS tables from the server: "` let token = req.cookies['sb:token'] let authorize = supabase.auth.setAuth(token)`" This was working fine until a couple of weeks ago when it stopped and checking the req object I found the cookie name was name now sb-access-token and updated all my GetServerSideProps to reflect this new name. "` let token = req.cookies['sb-access-token'] let authorize = supabase.auth.setAuth(token)`" Now I check in today and find its broken again and I need to change the token name back to sb:token - does anyone know why this changing? Thx

Cookie name change

is it safe to have my supabase anon-key and url on my public github repo if i've enable rls for all my tables?

I am having trouble integrating supabase into a sveltkit (not the svelte template that was in the startup guide - that worked fine) - any ideas? I have put the details here https://stackoverflow.com/questions/71251164/sveltekit-with-superbase-api-not-defined

Hello, How can i use supabase with deno? I tried: importing it with es6 like the example on github (doesn't work) using deno.land/x/supabase (doesn't work) writing my own library (too much work and no time)

someone found an open RLS-free table and spammed the living hell out of it, i deleted the records but is there any way to get the logs from it? its within the 1 day period for logs but nothing shows

Hi! I am trying to port my supabase app to TS and I get this warning for my Authentication provider wrapper... can't wrap my head around what to do here...

The property

supabase

doesn't exist on

AuthProvider

. CMD + Space / CTRL + Space and intellisense should show you what props you can pass to it.

it says no suggestions

may be I haven't set it up correctly?

Can i set a user without an email?