[need help with search] Hey guys, how I can get results when searching for e.g.

klara

so it would match a value

Klára

as well? Essentially making modified characters equal (

á

~

a

Maybe the "unaccent" extension would help? https://supabase.io/docs/guides/database/extensions#full-list-of-extensions

Anyone available in the evenings that may be able to help me with some schema design? Backend/data modeling is not my strong suit

What timezone are you in? as the evening varies for everyone.

I accidentally send over a bunch of request via the Supabase JS Client, and think I've maybe hit an API Rate Limit, and got a timeout. I've tried searching for the Supabase rate limits, but unfortunately didn't find any - I currently can't access my tables within Supabase (Infinite loading screen) Does anybody know, if there's a hidden rate limit - and how long a timeout could vary?

Mountain Standard Time, Boise ID area

Not that I know of, but use the feedback widget in the dashboard to report the issue you are haviing.

Thank you, I've just tried sending a ticket via the back-end 😄

anyone else had problem with

(true) nothing seems to work, but if i use

all

it works fine

only issue is INSERT select,delete, all work fine

i have done some complex stuff with

SECURITY DEFINER;

but this basic thing just doesn't work 🤔

tried on multiple supabase instances as well (even self hosted)

figured it out ish need to add {returning: 'minimal'}

Hey! Anyone can help with a sample code to use in creating a supabase function for rpc?

Hi Supabasers (is that what we call ourselves?), I just joined this discord. I am exploring Supabase as a possible solution for my company. I have a few questions related to the idea of eliminating the "backend" as implied by many docs (example: https://postgrest.org/en/v8.0/),. To be honest, I like that. The less code we write the better. But to be honest, I am debating with myself on whether this is possible or not. Here are my concerns: 1. How are Schema migrations expected to be handled? Usually, we have backend code that on boot runs migration scripts againts the DB. Since the backend code is bundled with the migration scripts we can make sure they never deviate. Without a backend how do you manage that? You simply have git repo with SQL scripts? 2. Since we have no backend, that means we need to write complex queries. Is the Javascript query dsl, provided by supabase, able handle complex queries (multiple joins, subqueries, summation of columns, etc..)? 3. Basically, what is your workflow? Thanks!

can i add supabase to an api made using express js

yes, just install the npm package

oh alr ty

hey all, I'm getting this error when upserting:

there is no unique or exclusion constraint matching the ON CONFLICT specification

here's the code:

const { data: organization, error } = await supabase.from<definitions['organizations']>('organizations').upsert(
      {
        ...
      },
      {
        onConflict: 'angelList',
      },
    );

I saw when creating the table in the UI I had the option to make columns unique. but now that it's created, it's not an option in the UI. I ran this in the sql console, but still not working:

ALTER TABLE organizations 
ADD CONSTRAINT organizations_unique UNIQUE ("angelList", "crunchbase", "domain", "linkedin");

any help here?

if you specify an upsert on

angelList

, then you also need a unique constraint on just that column (i think)

your current constraint does not ensure that every row has a unique

angelList

(only ensures a unique combination of those 4 columns you specified). that seems like what the error message is saying

Hi people, i have a database structured like this:

I can fetch a specific event with all matches related to it with:

how i can fetch the teams referenced in the team1 and team2 values?

Idk if im being clear

Try

local_team1:teams!team1(*),local_team2:teams!team2(*)

The "local" strings alias the results. The "!team1/!team2" strings tell which foreign key/relationship to use in the query.

Will try this right now...

you mean like this?