Querying auth.users table in Supabase
I have the following function defined in the database:
Querying auth.users table in Supabase
I have the following function defined in the database:
Upsert does not work with not null with default
I am upserting the data like this
Problem after data migration from MySQL to Supabase
so basically I had a RDS running with a DB and wanted to switch it to Postgres with Supabase, so I followed the official documentation and managed to get it all done.
Postgresql – Create generated column containing a string of values from another column containing an array of JSON object
Each row in my DB has a column called ‘phones’ which is an array of individual JSON objects that look something like
When should you create triggers in postgres vs creating function
I am trying to understand pattern/or ideally when would someone create triggers.
How do I authorise users with username in Supabase?
Supabase supports authorising users with an email address and a password, but how do I allow users to login with a username (instead of their email) and a password?
Get list of forms user has access to via user ID or group they’re in
I have some tables like so:
How to query the value of the first available key of a jsonb object with postgresql?
So I have this table:
Efficiently Matching Complex JSONB Criteria and Notifying Users in PostgreSQL
I am developing a PostgreSQL-based (with Supabase) system where new entries in a cars table must be matched against user-defined preferences stored in a monitoring_preferences table, each containing criteria in JSONB format. Additionally, users can select attributes to monitor via a “facets” table, which specifies JSONB paths against which new car data should be queried.