v0.24.02

Matryoshka Embeddings: Faster OpenAI Vector Search Using Adaptive Retrieval

Learn about how OpenAI’s newest text embeddings models, text-embedding-3-small and text-embedding-3-large, are able to truncate their dimensions with only a slight loss in accuracy.

Blog post

Easily Connect to Supabase Projects From Frameworks and ORMs of Your Choice

Connect to Supabase from any framework or ORM with our new “Connect” panel in Studio. This displays simple setup snippets that you can copy and paste into your application. We’ve started with a selection of popular frameworks and ORMs and you can request more by feature request or pull request.

Pull request

PostgREST Aggregate Functions

PostgREST v12 has been released, and with it, comes the release of the highly requested aggregate functions, avg(), count(), sum(), min(), and max(), that is used to summarize data by performing calculations across groups of rows.

Blog post

Terraform Provider to Manage Resources on Supabase Platform

We’ve created an official Supabase Provider for Terraform to version-control your project settings in Git. You can use this provider in CI/CD pipelines to automatically provision projects and branches and keep configuration in code.

Learn more

Support for Composite Foreign Keys in Table Editor

We've shifted the management of foreign keys into the Table Editor’s side panel so you can easily see all foreign keys pertaining to a table as well as referencing columns to composite foreign keys.

Pull request

Build a Content Recommendation App With Flutter and OpenAI

Learn about how we built a movie listing app that recommends another movie based on the movie that a user is currently viewing built with Supabase, Flutter, and OpenAI.

Blog post

Load Testing Supabase

Performance testing evaluates a system's compliance with its performance requirements. It reveals your app’s ability to handle user load, unexpected spikes, or recover from stressful workloads. In this blog post you will learn about how we automated our performance testing.

Blog post

More Studio Updates

• Collapsible main sidebar navigation [PR]
• Create charts from SQL Editor [PR]
• Resizable main tabs in Table Editor and SQL Editor [PR]
• View user metadata from the dashboard [PR]
• Bulk delete SQL Editor snippets [PR]
• Query Performance updates [PR]
• Choose a compute option when creating a project (Paid organizations only) [PR]
• Logs Explorer facelift [PR]

Quick Product Announcements

• [Auth] Require AAL2 to enroll additional factors for MFA enrollment [PR]
• [Storage] Increased maximum file upload size to 50GB for paid plans [PR]

Made With Supabase

• Inkvestigations is a webgame using LLM technology (currently GPT) to create interactive mystery games [GitHub]
• MathPuzzles- a multiplayer game to outsmart your friends [GitHub]
• Create a recipe app with Nowa [Article]
• Open-source AI wearable device that captures what you say and hear [GitHub]
• Brick yourself - turn yourself into a mini-figure [Website]

Community Highlights

• SupaVlog: Vlog Application Starter Kit Built with Supabase, Stream, Hookdeck, and Next.js [Article]
• Chat with Supabase PostgreSQL using AI [Article]
• How to implement Google sign-in on Flutter with Supabase on iOS, Android and the Web [
  ]
• They're Making Supabase Better... [
  ]
• How to send welcome emails with Supabase edge functions and database triggers [Article]
• How to Create Email Signup and Login Screens in React Native (Expo), ExpressJS, and Supabase [Article]
• Integrating Supabase with Flutterflow [
  ]
• Join the #SupaBuilders movement and never get your project paused again!