Bases: The Big Postgres' Showdown

It’s a huge week for Postgres fans, or anyone invested on database drama in general (aren’t we all?). Both Neon and Supabase announced their General Availability on the exact same day. Coincidence? We're not so sure, but we'll let you decide. Now, let’s dive into what each platform is bringing to the table…

Supabase Hits General Availability 
This week, Supabase officially stepped out of beta and into the spotlight with their General Availability announcement, marking a major milestone for the platform. They've been quietly proving themselves capable of handling massive scale—1 million databases and counting. With a client roster that includes everyone from indie developers to big names like Mozilla and PwC, Supabase is shaping up to be the go-to for anyone needing a robust, scalable Postgres solution.

The platform isn't just about handling big numbers; it’s also focused on providing serious security measures and a dynamic set of tools for developers. With features like Row Level Security and a vibrant community contributing to its roadmap, Supabase is poised to support projects that range from weekend hacks to enterprise-grade applications.

Neon's Approach to Database Flexibility 
Simultaneously, Neon announced their own GA, bringing a fresh perspective to managing Postgres databases. Neon's big sell is their innovative architecture that separates storage from compute, enabling databases to scale more flexibly and recover from interruptions in record time. This feature alone could be a game-changer for developers looking for agility in their database solutions.

Neon introduces branching as a core feature, allowing developers to work on databases in isolation without affecting the main production data—a boon for teams looking to maintain velocity in their development cycles. With all changes being contributed back to the open-source Postgres community, Neon isn't just building a product; they're trying to push the entire ecosystem forward.

Primary Key Takeaway 
With both platforms now in General Availability, the landscape for Postgres solutions looks more exciting than ever. Whether you're drawn to Supabase for its robust security features and scalable infrastructure, or Neon for its flexible architecture and developer-friendly innovations, there’s plenty to explore. In a world where database management continues to be a critical element of software development, having two strong platforms vying to solve real-world problems is a win for developers everywhere.

Questionable Query

Can you fix this query?

SELECT name 
FROM Employees 
WHERE department = 'IT' 
AND salary ≥ 70000;

Select Stars

1. Anton Zhiyanov is back with another banger and reimagines Redis in SQLite with Redka, focusing on key Redis features while ensuring full compatibility.

2. Ryan Marcus walks us through over a decade of PostgreSQL optimizations, revealing a near 50% reduction in tail latency from version 8 to 16.

3. Curious about deploying and managing SQL scripts? Bytebase, Liquibase, and Flyway offer streamlined solutions for managing SQL changes.

4. Outerbase partners with Turso, streamlining SQLite management. Instant connections, collaboration, and AI-driven features enhance your database experience effortlessly.

5. Supabase releases Postgres Index Advisor offers tailored index suggestions to boost your query speeds, ensuring efficient execution with just a function call.

Questionable Query - Answered

The ≥ operator doesn’t exist in SQL, you will have to instead use a combination of >=

SELECT name FROM Employees WHERE department = 'IT' AND salary >= 70000;

That’s all for now!

Want us to feature your company?
Reach out about sponsoring Bases