Top 10 Launches of LWX

2023-12-19

6 minute read

This launch week was unique. We had so much content that we decided to do a “main stage”, with five major features, and a “build stage” with additional content. It's a lot to digest, so here are 10 of my favorites.

Top 10

#1: We teamed up with Fly

We're launching Fly Postgres, a managed Postgres offering by Supabase and Fly.io. Fly's current Postgres offering is unmanaged, so we're working with them to bring the same delightful Postgres experience to Fly.

Read more

#2: We launched Supabase Grafana

We shipped an open source observability suite for your Supabase project, using Prometheus and Grafana. It collects around 200 metrics and can be deployed to any server.

Read more

#3: pg_graphql now supports Postgres Functions

Supabase GraphQL (pg_graphql) 1.4+ supports the most requested feature: Postgres functions a.k.a. User Defined Functions. Execute custom SQL logic within GraphQL queries to support complex server-side operations.

Read more

#4: Python libs are now stable

Supabase Python is now stable and ready to use in your Python applications. We've created a few guides and examples to show how easy it is to use Python libraries with existing frameworks like Flask.

Read more

#5: Aggregate Functions in PostgREST

Support for aggregate functions has been much requested feature that went through multiple iterations of design and review. PostgREST 12 was just released and it now supports avg, count, max, min, sum.

Read more

#6: Supavisor 1.0

Supavisor is a cloud-native connection pooler for Postgres, built with Elixir. We've migrated all projects on the platform from pgbouncer to Supavisor. Every new Supabase project launched now gets a Supavisor connection string to use for connection pooling.

Read more

#7: Edge Functions now support Node & NPM

Edge Functions now natively supports npm modules and Node built-in APIs. You can directly import millions of popular, commonly used npm modules into your Edge Functions.

Read more

#8: Leaked Password Protection with Have I Been Pwned

we have integrated the HaveIBeenPwned.org Pwned Passwords API in Supabase Auth to prevent users from using leaked passwords. This will prevent your users from using a password that has previously been leaked.

Read more

#9: Supabase Branching

Branching gives you a Postgres database for every Pull Request. You can run experimental changes on your branch database, and then merge your changes into production when you're happy with the changes. We're rolling out branching in batches.

Read more

#10: Postgres Read Replicas

Read replicas continuously, well, replicate data from a primary database. It contains a constantly-updated copy of the data in your Primary. These are great for distributing data closer to your users to reduce application latency, and for reducing the load on your Primary database.

Read more

Bonus: we dropped an Album

I made a bet with Sam that we would make an album. Luckily Jon has a side hobby. Check out supabase.productions.

Cool things from the community

I also wanted to highlight a few things that happened in the community over the past few weeks:

Local AI Stack with Yoko from a16z

I caught up with Yoko from Andreessen Horowitz to chat about the Local AI stack that she developed with Supabase, Ollama, Langchain, and Next.js.

Finance integrations with OpenBB

Didier explained the origins of OpenBB Terminal, the first financial terminal that is free and fully open source. He shared some details about the integration that he's building with Supabase.

Offline sync with ElectricSQL

Offline sync is one of the most requested features for Supabase. I caught up with the team at ElectricSQL to learn more about their integration.

Basejump is like “shadcn for Supabase”

In the past few months, Tiniscule has been quietly upgrading the Basejump starter kit for Supabase. I think of it a bit like shadcn for Supabase - super easy to template out a secure, scalable enterprise app. Along the way, he's been developing periphery tooling like test helpers, and pushing us to provide better primitives. One of our most common questions is “accounts and permissions?”. Basejump solves that and more.

Basejumo

Mockup madness from tldraw

Oh, and the tldraw team have been on an absolute tear this week:

In case you missed it …

And finally…

We wouldn't be anything without Postgres.

Postgres meme

Share this article

Build in a weekend, scale to millions