Python: Overview | Supabase Docs (original) (raw)

• 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

• Overview

• Create a new user

• Create an anonymous user

• Sign in a user

• Sign in with ID Token

• Sign in a user through OTP

• Sign in a user through OAuth

• Sign in a user through SSO

• Sign out a user

• Send a password reset request

• Verify and log in through OTP

• Retrieve a session

• Retrieve a new session

• Retrieve a user

• Update a user

• Retrieve identities linked to a user

• Link an identity to a user

• Unlink an identity from a user

• Send a password reauthentication nonce

• Resend an OTP

• Set the session data

• Exchange an auth code for a session

• Auth MFA

• Enroll a factor

• Create a challenge

• Verify a challenge

• Create and verify a challenge

• Unenroll a factor

• Get Authenticator Assurance Level

• Auth Admin

• Retrieve a user

• List all users

• Create a user

• Delete a user

• Send an email invite link

• Generate an email link

• Update a user

• Delete a factor for a user

• Edge Functions

• Invokes a Supabase Edge Function.

• Realtime

• Subscribe to channel

• Unsubscribe from a channel

• Unsubscribe from all channels

• Retrieve all channels

• Broadcast a message

• Storage

• Create a bucket

• Retrieve a bucket

• List all buckets

• Update a bucket

• 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

• Copy an existing file

• Delete files in a bucket

• Create a signed URL

• Create signed URLs

• Create signed upload URL

• Upload to a signed URL

• Retrieve public URL

• The auth methods can be accessed via the supabase.auth namespace.

• By default, the supabase client sets persist_session to true and attempts to store the session in memory.

• Any email links and one-time passwords (OTPs) sent have a default expiry of 24 hours. We have the following rate limits in place to guard against brute force attacks.

• The expiry of an access token can be set in the "JWT expiry limit" field in your project's auth settings. A refresh token never expires and can only be used once.