Launch Week X is just over, but the fun doesn't stop! This changelog summarizes what has been released for Studio over last week as well as other improvements that we shipped behind the scenes while Launch Week X was ongoing.
https://github.com/supabase/supabase/assets/19742402/c10ab0bc-a2be-4739-be3a-5eb6ef802af1
We've got a new RLS Editor that brings SQL front-and-center, giving developers access to the full potential of Postgres rather than abstracting it away. Accompanying it is an AI assistant that has been tuned to produce SQL for Row Level Security policies, making it fast and easy to get your policies setup the way you need them.
If you're keen to give this a spin, you may enable this feature from the Feature Previews section (which we'll cover more in the last section of this changelog) while you're in a project. This will replace the current UI for creating RLS policies with this new AI assisted RLS Editor UI.
PR: https://github.com/supabase/supabase/pull/19166
Link: https://supabase.com/dashboard/project/_/auth/policies
Postgres Roles & User Impersonation#
Run queries in Studio using different roles - this is potentially a powerful tool for testing your Row Level Security policies and determining which data each role can access. You may also impersonate a specific user in Studio by "minting" a JWT with their ID and then running the queries using that JWT.
This feature is available not just in the Table Editor, but also in the SQL Editor, GraphiQL interface, and Realtime Inspector (which we'll talk about more right in the next section below)
PR: https://github.com/supabase/supabase/pull/18945
Link: https://supabase.com/dashboard/project/_/editor
An easy way to prototype, inspect, and debug Realtime directly in the Studio. You can use the Realtime Inspector to view messages being sent and received in channels, and also filter messages by type: presence, broadcast, and database changes.
PR: https://github.com/supabase/supabase/pull/17617
Link: https://supabase.com/dashboard/project/_/realtime/inspector
Our new tool for unveiling new features - we'll release beta features as previews before making them generally available. This will help us to get features out to you faster, make it easier for you to give us feedback, and also shorten the iteration loop.
PR: https://github.com/supabase/supabase/pull/17775
Link: https://supabase.com/dashboard/project/_
Supabase Auth allows a user to initiate identity linking with a different email address when they are logged in. More information can be found in our documentation here.
PR: https://github.com/supabase/supabase/pull/19615
Link: https://supabase.com/dashboard/project/_/settings/auth
Database extensions that are installed through the dashboard on the database/extensions page are, most of the time, installed by default in the extensions schema (as it's the default dropdown option) unless the extension has a schema that it's required to be in, or the user changes it to be installed in another schema.
If the installed extension (e.g vector) has enumerated types, the Table Editor then can access those types for users to assign them to columns, without having the user to install them in another schema.
PR: https://github.com/supabase/supabase/pull/19580
Link: https://supabase.com/dashboard/project/_/editor
PR: https://github.com/supabase/supabase/pull/19666
Link: https://supabase.com/dashboard/project/_/settings/database