August 12th, 2024

Neon Postgres vs. Supabase

Neon and Supabase are modern database platforms for developers, offering scalable solutions with unique features. Neon is serverless with automatic scaling, while Supabase is an open-source Firebase alternative for PostgreSQL backends.

Read original articleLink Icon
Neon Postgres vs. Supabase

Neon and Supabase are two modern database platforms designed to cater to developers' needs for building scalable applications. Neon is a serverless database inspired by Amazon Aurora, featuring a unique architecture that separates compute and storage, allowing for automatic scaling and a history of PostgreSQL transactions. It offers features like database branching, passwordless authentication, and extensive connection pooling, making it suitable for developers seeking a straightforward setup. Supabase, on the other hand, is an open-source alternative to Firebase, providing a comprehensive suite of tools for creating secure PostgreSQL backends with minimal configuration. It includes functionalities such as real-time databases, authentication, and storage solutions, appealing to developers who require flexibility and control over their applications. The article compares both platforms across various aspects, including connection methods, architecture, integrations, and security features, helping developers choose the right database for their specific project needs. Neon emphasizes a stateless compute model and efficient resource management, while Supabase focuses on leveraging open-source tools and providing a user-friendly experience.

- Neon is a serverless database platform with automatic scaling and PostgreSQL transaction history.

- Supabase is an open-source alternative to Firebase, offering a suite of tools for PostgreSQL backends.

- Both platforms provide robust connection methods and security features tailored for developers.

- The comparison aids developers in selecting the appropriate database based on their project requirements.

- Neon and Supabase support various integrations with popular tools and services for enhanced functionality.

Related

Supabase (YC S20) Is Hiring Postgres SREs

Supabase (YC S20) Is Hiring Postgres SREs

Supabase seeks a Site Reliability Engineer to manage Postgres databases remotely. Responsibilities include enhancing reliability, ensuring high availability, and optimizing performance. Ideal candidates possess multi-tenant database experience, Postgres tools proficiency, and AWS deployment skills. Benefits include remote work, equity, health coverage, and tech allowance.

Graph-Based Ceramics

Graph-Based Ceramics

The article discusses managing ceramic glazes, introducing a custom app. It compares Firebase and Supabase databases, opting for Supabase's better data modeling. Instant database is explored for a hybrid solution.

Supabase (YC S20) Is Hiring an Auth Engineer (Remote)

Supabase (YC S20) Is Hiring an Auth Engineer (Remote)

Supabase, an open-source Firebase alternative, seeks an Auth Engineer for remote work. Role involves Auth feature development using Go, TypeScript, and Postgres. Benefits include equity ownership and tech allowance. Application process is fully remote.

Supabase (YC S20) Is Hiring Auth Engineers (Fully Remote)

Supabase (YC S20) Is Hiring Auth Engineers (Fully Remote)

Supabase is hiring a remote Auth Engineer to develop authentication features using Go and TypeScript. Candidates need five years of experience, knowledge of web fundamentals, and familiarity with OAuth and OIDC.

Neon: A serverless open-source alternative to AWS Aurora Postgres

Neon: A serverless open-source alternative to AWS Aurora Postgres

Neon is an open-source, serverless alternative to AWS Aurora Postgres, featuring a scalable architecture with a free tier, local installation requirements, and comprehensive documentation for users and contributors.

Link Icon 9 comments
By @ko_pivot - 6 months
While you can use Supabase as simply a Postgres provider, the more interesting comparison IMO is to other backend-as-a-service providers. Supabase used to call themselves a “Firebase alternative” but at this point they have surpassed Firebase in almost every way, in my view.
By @roberttod - 6 months
Do these providers really bring enough value to use them over a colocated managed db? (Not just the same region, but subnet etc)

I was under the impression for quite some time that it wasn't that bad to have 2-3ms latencies compared to a co-located DB which is typically <1ms. However, we recently switched from Neon to a colocated, managed db and there was a huge improvement. Some of our queries were executing sequentially (due to our ORM, Prisma), and so what was a 3 second transaction was reduced to only 1 second. Yes this could be rearchitected better, but it illustrates a major floor in my mind for these companies providing only a DB.

Managed vs. unmanaged is a massive difference and would be worth it. But these days I was under the impression most hosting companies also offer managed DBs.

By @eashish93 - 6 months
Supabase can't become firebase alternative, if they do not introduce pay per hour pricing model. Their plan starts at $25/month (their free plan is shit). Even their auth is not free unlike firebase which has everything almost free to start.
By @re-thc - 6 months
What is a CPU?

If it's AWS hosted for example it can range from a t2 (low end) to c7a (high end) and have huge performance impacts. How will this change over time?

It's weird that pricing is based on CPU but it's never defined. And how do we compare between offerings when that much is not obvious?

By @alexnewman - 6 months
I tried using supabase to back a vercel project. It was far too slow so we switched back to postgresql included with vercel. Turns out that was neon under the hood. The project is called webtm.io. It's opensource so you should be able to see this in history.
By @someoneontenet - 6 months
Seems weird to compare them since I see them as complimentary services.
By @qaq - 6 months
what is the largest node size Neon will scale to ?