Introduction
Installing
Initializing
Database
Fetch data
Insert data
Update data
Upsert data
Delete data
Call a Postgres function
Using filters
Column is equal to a value
Column is not equal to a value
Column is greater than a value
Column is greater than or equal to a value
Column is less than a value
Column is less than or equal to a value
Column matches a pattern
Column matches a case-insensitive pattern
Column is a value
Column is in an array
Column contains every element in a value
Contained by value
Greater than a range
Greater than or equal to a range
Less than a range
Less than or equal to a range
Mutually exclusive to a range
With a common element
Match a string
Match an associated value
Don't match the filter
Match at least one filter
Match the filter
Using modifiers
Order the results
Limit the number of rows returned
Limit the query to a range
Retrieve one row of data
Retrieve zero or one row of data
Retrieve as a CSV
Using explain
Auth
Create a new user
Create an anonymous user
Sign in a user
Sign in a user through OTP
Sign in a user through OAuth
Sign out a user
Verify and log in through OTP
Retrieve a session
Retrieve a new session
Retrieve a user
Set the session data
Auth MFA
Enroll a factor
Create a challenge
Verify a challenge
Create and verify a challenge
Unenroll a factor
Get Authenticator Assurance Level
Edge Functions
Invokes a Supabase Edge Function.
Realtime
Storage
Create a bucket
Retrieve a bucket
List all buckets
Delete a bucket
Empty a bucket
Upload a file
Download a file
List all files in a bucket
Replace an existing file
Move an existing file
Delete files in a bucket
Create a signed URL
Retrieve public URL
Python: Sign out a user
In order to use the
signOut()
method, the user needs to be signed in first.
Examples
Sign out
res = supabase.auth.sign_out()