Fly Postgres: A Powerful Collaboration with Supabase

Supabase, the renowned open-source Firebase alternative, has joined forces with Fly.io to enhance the Postgres offering. This collaboration paves the way for a managed Postgres service on Fly, which adds another dimension to Fly.io’s already impressive portfolio. The Supabase CEO, @kiwicopple, shared the exciting news and addressed questions and comments from the community.

A Synergy of Excellence

The partnership between Supabase and Fly.io is an exciting development in the tech world. @denysvitali expresses enthusiasm for the collaboration, anticipating the impressive results that can be achieved by these two innovative companies working together. It’s no wonder that users are eager to see the outcome of this powerful synergy.

The Art of Capitalization

In the comment thread, an interesting discussion emerges about the capitalization style used by @kiwicopple in their announcement. @pplante jokingly points out the subtle change in casing, which adds a touch of humor to the conversation. This playful interchange highlights the importance of paying attention to details and the impact it can have on the way messages are perceived.

Responding to Feedback with Grace

@kiwicopple graciously acknowledges the comments about capitalization and engages in a light-hearted conversation. This interaction showcases the CEO’s ability to handle criticism and respond with a touch of humor. @swyx commends the CEO for their response, expressing appreciation for the transparency and competence exhibited by the Supabase team.

Exploring Managed Services in the Cloud

@satvikpendem raises an interesting point about why Fly.io does not offer their own managed services, similar to DigitalOcean and other cloud providers. This sparks a lively discussion about the different challenges and problem spaces that companies face. @tptacek dives into the details, articulating the complexities involved in managing databases and the reasoning behind the decision. The conversation sheds light on the distinction between automated and managed services, highlighting the expertise required to handle the intricacies of managing database clusters effectively.

The Power of Distributed SQLite

@jerrygoyal poses an intriguing question about the potential rise of distributed SQLite as the default choice over Postgres. @devoutsalsa recommends checking out Turso, a technology built on SQLite that has received positive reviews. This exchange highlights the diverse range of options available and the ongoing exploration of different technologies in the database space.

Navigating Supabase’s REST API

@trevor-e expresses confusion about how to use the basic REST API in Supabase and where to place business logic. This prompts a helpful response from the Supabase team. @kiwicopple explains that users have multiple options for connecting to Supabase, including directly connecting to Postgres or utilizing PostgREST and Edge Functions. They emphasize that Supabase is just PostgreSQL and the REST API is an additional tool for interacting with the database.

The Role of Stored Procedures in Supabase

@zoogeny offers valuable insights into the use of stored procedures in Supabase. While the REST API provided by Supabase is convenient for basic operations, more complex scenarios may require business logic to be placed in stored procedures. This can add complexity to the development process and impact performance. @zoogeny highlights the importance of considering the role of stored procedures and their implications in the overall system architecture.

Adding JavaScript to PostgreSQL with plv8

@phanimahesh suggests using plv8, which allows JavaScript to be written directly in PostgreSQL. This can be a useful approach for certain use cases, as it enables developers to leverage their existing JavaScript skills. @zoogeny acknowledges that plv8 can work well but points out that it adds another layer to the technology stack. The decision to use stored procedures or additional tools like plv8 depends on the specific requirements and complexity of the project.

Understanding Row Level Security (RLS)

The conversation shifts to the topic of Row Level Security (RLS) in PostgreSQL. @refulgentis expresses curiosity about RLS and its potential benefits. @zoogeny provides insights into the capabilities of RLS, noting that it can be a powerful tool for granular access control to data. However, it also comes with potential performance implications, especially for aggregate queries. @niklasd shares an experience with performance issues encountered with RLS and offers a helpful resource for optimizing RLS performance.

Embracing Feedback and Honesty

The Supabase CEO, @kiwicopple, acknowledges the feedback and criticism, emphasizing the importance of listening to user concerns. They express humility by admitting mistakes and highlighting that tech companies, including Supabase, make calculated bets that may not always pay off. Transparency and honesty are at the core of their approach, as they strive to provide users with the best possible experience.

The collaboration between Supabase and Fly.io brings together the strengths of both platforms, offering users a powerful and managed Postgres service. As the partnership unfolds, the tech community eagerly awaits the exciting developments that lie ahead. With Supabase’s expertise in open-source Firebase alternatives and Fly.io’s robust infrastructure, the future of managed Postgres looks brighter than ever before.