Skip to content
Changelog

Supabase Upsert, RPC Calls & Full-Text Search

Supabase Upsert, RPC Calls & Full-Text Search

Supabase and Postgres gain an Upsert Row action, Supabase RPC calls you can run straight from action flows with typed results, and a Postgres-backed Search (Full-Text) query filter. Plus fixes for case-sensitive collaborator invites, iOS phone sign-in with reCAPTCHA Enterprise, and the code editor's handling of Windows line endings.

Features

Upsert Row action for Supabase and Postgres

Supabase and Postgres now support an Upsert Row action that inserts a row, or updates the existing one when the selected on-conflict columns (or the primary key) match. One action replaces the read-then-branch-then-write flow you used to build by hand.

Supabase Upsert Row selected in the Backend Call action type menu
Use Upsert Row to insert or update without building a separate branching flow.

Call Supabase RPC from action flows

Call Supabase RPC (Postgres database functions) directly from your action flows. Function signatures are synced from your Supabase project, so parameters are listed for you, and results come back typed and bindable like any other action output.

Supabase RPC section showing synced article category stats and increment article views functions
Synced database functions appear under Supabase RPC in the action menu.

Full-text search in Supabase queries

Supabase queries now support a Search (Full-Text) filter backed by Postgres full-text search, with a configurable search type and language.

Supabase query filter configured for full-text search using the Websearch search type
Choose the full-text relation, search syntax, and language directly in the query builder.

5 Bug Fixes

  • Collaborator invitations now grant project access when the invited email was entered with different capitalization than the account uses.
  • Auth: iOS phone sign-in now links the reCAPTCHA Enterprise SDK for projects targeting iOS 15+, so it works with Firebase reCAPTCHA SMS Defense instead of failing with “reCAPTCHA SDK is not linked”. Projects below iOS 15 that use phone sign-in now show a heads-up to raise the minimum.
  • Custom Code: Pasting code with Windows line endings into the code editor no longer adds a blank line after every line when you save, and no longer leaves the Save button enabled after a successful save.
  • Gemini: Gemini API key settings now guide you through platform-specific restrictions before you generate or deploy your app.
  • API Calls: FlutterFlow now flags API credentials that may be included in generated client code.
Updated on