count error

is there any better way to do this?

ts
  let { data: Users, error } = query.search
    ? await supabase
        .from('User')
        .select('*')
        .ilike('username', `%${query.search}%`)
    : await supabase
        .from('User')
        .select('*')

like any

ILIKE

query that matches all values?

nevermind, got it

ts
  let { data: Users, error } = await supabase
        .from('User')
        .select('*')
        .ilike('username', `%${query.search || ""}%`)

Hey guys, I have one problem with upload image, I added policies and upload went nicely, but when i want to show the image in img src, it says {"statusCode":"400","error":"TokenExpiredError","message":"jwt expired"}

When you call createSignedUrl how long are you setting the token to last?

30

Hello, please has anyone used Supabase for infinite scroll in react here ? I need help on implementing it

Inifinite Scroll with React

Hi Folks... I got a strange behavior here:

await this.$supabase
        .from("votes")
        .select("*").eq("project_id", this.project_id)

returns an Array as expected... but If I try to count it, it returns none:

await this.$supabase
        .from("votes")
        .select("*", { count: "exact", head: true }).eq("project_id", this.project_id)

what am I doing wrong?

if I remove the "eq" from count it also works...

Remove head:true, that tells it to just return count.

I'd like just the count number... so with "head" I can't filter?

Anybody have any suggestions on how to dynamically change pagination? for instance if the query param was something like ?page=1 I want to show the first pieces of data, and so forth, I'm just not entirely sure how to go about this with the library

I'm doing a paginated page right now. Basically you use .range(page x pagesize, page x pagesize + pagesize - 1) where page starts at 0. I use count return to generate a "paginator" in my case if more than 1 page worth.

sorry, I'm a bit of an idiot. but just to confirm, pagesize would be the total amount of result that you want on one page, correct?

anybody have any suggestions on how to trigger a webhook when a specific column is updated in the DB?

Anyone on react native run into issues with joins data loading on the first load? Entire row is being read, but all of the joined information is returning null till I refresh. This is using a postgres function

or anyone using rpc's in general

ahhhh figured it out. Forgot to set read policies on the table i was joining on

I'm having some trouble with .neq() in my nodejs server, I'm trying to find all users except for a certain user type and I have the query set up with a couple of paramters in there, like a .eq(), and a .gt(), is there a specific order that I have to input these as or am I missing something?

can you use .select() to get multiple columns of data?

yes

If you just want columns of that table, then it's sql-like notation (comma-separated)

is there a way to do a

SELECT FOR UPDATE

with the client library?

was doing a bulk upsert and ran into (what i assume) was a lock contention issue (select and upsert statements locked up and timed out).

also does the free tier get throttled?

The subscription is not working for me even though my syntax is correct. My code is as follows: let chatSubscription = supabase .from('messages') .on('*', payload => { console.log('Change received!', payload) }) .subscribe() Any ideas what I may be doing wrong? I do have the table replication on at Supabase.

How can I read rows on JavaScript? I'm not good at Javascript. I don't think this might help, but I will write my source code down.

const username = async () => {
    return await supabase.from('users').select('username').eq('id', user?.id)
}

Read rows in JavaScript

Hey there, I'd like to do an or statement with fullText search. How do I go about this? Here's the documentation: https://supabase.io/docs/reference/javascript/or and its example:

const { data, error } = await supabase
  .from('cities')
  .select('name, country_id')
  .or('id.gt.20,and(name.eq.New Zealand,name.eq.France)')

if do:

const { data, error } = await supabase
  .from('cities')
  .select('name, country_id')
  .or('fts_description.fullText.keyword,and(title.eq.New Zealand,name.eq.France)')

I get:

failed to parse logic tree