Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

You can create a unique constraint on the the table so that the combination of those two values is always unique.

do you have any links you can share on how to implement this?

just saw that it is a sql statement something like

    CONSTRAINT UC_Person UNIQUE (ID,LastName)

can you add this to an existing table?

I can see 2 approaches for this, either implement a generated column or use a function that is triggered on insert and updates

https://www.postgresql.org/docs/12/ddl-generated-columns.html

https://www.postgresql.org/docs/9.1/sql-createfunction.html

`ALTER TABLE Persons
ADD CONSTRAINT UC_Person UNIQUE (ID,LastName);`

think this is it

<@!412741823887572998> Yeah, that looks right