@User Ah, this maybe explains it. I'm on 1.22.4, it works for me. I think the .textSearch property is relatively new if I remind that correctly. Maybe you can upgrade to the newest version.

Ah great! It's no longer showing that problem. Although It still isn't searching my column. I get the following warning when I run it:

Possible unhandled Promise Rejection (id: 0): TypeError: _initSupabase.supabase.from('ingredients').select('name').textSearch is not a function. (In _initSupabase.supabase.from('ingredients').select('name').textSearch("'orange' & 'apple'", { 
        config: 'english' 
      })

I hard coded my search values to see if I could get it working - but no luck! ` const searchIngredients = async () => { const { data: items, error } = await supabase .from('ingredients') .select('name') .textSearch('name',

'orange' & 'apple'

, { config: 'english' }) if (error) console.log('error', error) else setIngredients(items!) }`

@User hm, this is weird. And what happens when you try it without the TypeScript Type, so like:

const { data: items, error } = await supabase
  .from('ingredients')
  .select('name')
  .textSearch('name', `'orange' & 'apple'`, { 
    config: 'english' 
  })

Is it possible to use Supabase (auth, db mostly) in a Chrome extension with the manifest v3?

even im done with the sendgrid domain auth, i recieve the email confirmation in "spam messages"

Do I need take care about reqs/s for database?

Is there a way to create field-level access control? E.g.: the table

users

contains public fields, that can be viewed by anyone, as well as private fields, that can only be read and modified by the user who owns the profile? For this easy example, I could still think about an easy solution: creating a

profiles_public

and a

profiles_private

table, but then my second question comes into play: can I use the rest-api for a user and his public profile in a single roundtrip to supabase?

You can create a view (https://www.postgresql.org/docs/9.2/sql-createview.html , https://www.postgresqltutorial.com/managing-postgresql-views/) which act like tables, but are useful for only allowing read-only access to data. You can also grant privileges to specific columns (https://www.postgresql.org/docs/9.5/infoschema-column-privileges.html). For example, pgAdmin has a security tab for each column, which allows you to set the

privilege_type

and

grantee

. Alternatively, allow

SELECT

only via RLS, and then use functions to allow users to update specific columns.

Hey all, is there such a thing as "Virtual columns" or "Generated Columns" in Supabase?

thanks, Scott, I'll look into it!

Virtual columns or Generated Columns in supabase or postgres

I have a question regarding data types for numbers. If i want to store a number say

23797.5

which is a monetary value in cents, which data type should i use in the UI? I initially chose

int8

but getting this error

invalid input syntax for type bigint: "23797.5"

now.

float

I might be wrong, but i think float will do the trick

Ok. I see float4 and float8 in supabase ui, which one do i choose?

Oh okay. So i guess i gotta choose

float8

then

you should probably take a look at @User link https://www.postgresql.org/docs/9.3/datatype-money.html

Got it! I went with

float8

👍

@User @User Thanks! That worked👍

I'm working on an "invite only" auth flow and I haven't figured out how to create auth.users (maybe via

auth.signUp(...)

) without getting logged out myself. Any ideas? It seems to be returning a session and logging me out even though I have email confirmation enabled in the UI.

How come theres no entries in the Table Editor even though I can get back several rows when using the API? Is the Table Editor broken?

Haha I actually should have debugged it myself before asking. Apparently uBlock Origin blocked the attempts to get the rows. Fixed by allowing the website in ublock

For timestamping, it's 3:12am CAT Is https://app.supabase.io down?

Hi! Can i use Prisma and Supabase Realtime APIs together?, im trying to make a query using Supabase API on a DB generated with Prisma, but i get this error: message: 'permission denied for schema public', I turn on all my tables, and im using service_role KEY, to bypass RLS, many thanks!

Hey @User , have you tried looking at this? https://dev.to/prisma/set-up-a-free-postgresql-database-on-supabase-to-use-with-prisma-3pk6

How do I create new roles? Can't see any option on the dashboard...

Hey, yes, i already done that but i need to use Supabase RESTful API (not realtime API, my mistake on original question) for performance purposes, i read that connection pooling its not the best for serverless.