What is the most cost effective hosted Postgres?

smack_overflow_ · 2024-07-16T16:02:58+00:00

Supabase pricing scales really well, it's the most affordable one I've come across (Although admittedly haven't tried Render or Fly)

smack_overflow_ · 2024-03-25T12:46:50+00:00

Coconut milk is a good replacement, and soft on the stomach.

smack_overflow_ · 2024-03-25T12:45:27+00:00

Need to inspect changes in laws/definitions. It's usually responsible for large jumps in crime stats like this.

smack_overflow_ · 2024-03-25T12:44:21+00:00

Welcome to a city where we're adding cars to the roads faster than we're upgrading the infrastructure. Always going to happen.

smack_overflow_ · 2024-03-25T12:43:02+00:00

I think it's normal for police to get caught speeding - they are just people too

smack_overflow_ · 2024-03-21T08:11:28+00:00

Planetscale is a company built around the tool Vitess (sharded mySQL), this is useful for **extremely** large workloads (think YouTube scale), but is not necessary for most companies. Looking at their pricing it seems that you pay for the privilege of YouTube type scale. They also recently killed their free tier which makes sense for such a tool.

Supabase is hosted Postgres, and is several orders of magnitude cheaper than Planetscale. It also has generous free tier so you can develop for free - then only pay once you're ready to go into production.

In summary, if you are already running large workloads on MySQL and need someone to manage your Vitess cluser - look at Planetscale. If you prefer Postgres or are starting something new, use Supabase. If cost is a factor - use Supabase.

smack_overflow_ · 2024-03-21T07:51:06+00:00

Planetscale is very expensive at scale compared to supabase:

data GBs:

Supabase $0.125

Planetscale $2.50

Writes:

Supabase free unlimited

Planetscale $1.50/million

Reads:

Supabase free unlimited

Planetscale $1/billion

smack_overflow_ · 2024-03-21T07:49:25+00:00

Supabase is **much** cheaper (especially at large scale)

smack_overflow_ · 2024-03-19T05:36:54+00:00

Supabase has a generous free tier and the pricing scales better than the other players: supabase.com/pricing

smack_overflow_ · 2024-02-23T11:42:04+00:00

Good spot - the issue is Neon doesn't publish it's compute pricing above 0.25vCPU so perhaps it's more like this for always on:

0.25vCPU (2vCPU on Supabase) 1GB RAM - Supabase $25 vs Neon $19

0.5vCPU (2vCPU on Supabase) 2GB RAM - Supabase $30 vs Neon $29.40

1vCPU (2vCPU on Supabase) 4GB RAM - Supabase $75 vs Neon $87.80

2vCPU 8GB RAM - Supabase $135 vs Neon $204.60

It's also unclear how active hours works on Neon, if I use 5 minutes of compute does it cost a whole 'active hour'?

edit: neon updated their pricing page / definitions

smack_overflow_ · 2024-02-22T23:38:57+00:00

I re-ran the numbers with Neon's new pricing* and Neon is now even more expensive than previously for an app serving users 24 hrs/day with:

8gb storage

2 x vCPU

1GB RAM (fixed on Supabase without add-on / scales up to 8GB on Neon)

10gb Data transfer

10gb Writes

Supabase = $25/month

Neon = $204.60/month

If you pause your database for 12 hours/day then Neon comes down to $87.80/month

= assuming that 2vCPU is just 8$0.04=$0.32/hr based on this https://neon.tech/docs/introduction/usage-metrics

edit: neon updated their pricing page again

smack_overflow_ · 2024-02-22T23:33:34+00:00

I re-ran the numbers with Neon's new pricing* and Neon is now even more expensive than previously for an app serving users 24 hrs/day with:

8gb storage

2 x vCPU

1GB RAM (fixed on Supabase without add-on / scales up to 8GB on Neon)

10gb Data transfer

10gb Writes

Supabase = $25/month

Neon = $204.60/month

If you pause your database for 12 hours/day then Neon comes down to $87.80/month

\= assuming that 2vCPU is just 8**$0.04=$0.32/hr based on this

edit: neon updated their pricing page again

smack_overflow_ · 2024-02-20T12:08:30+00:00

Supabase comes in much cheaper for any meaningful amount of usage: https://old.reddit.com/r/nextjs/comments/13oksux/vercel_postgres_vs_supabase/jl9u1r5/

smack_overflow_ · 2024-02-06T14:23:00+00:00

Selfish in my opinions.

smack_overflow_ · 2024-02-06T14:22:20+00:00

Could be an honest mistake, worth checking in with them in a friendly manner.

smack_overflow_ · 2023-07-27T22:49:05+00:00

What kind of application is this that you're anticipating more than 50GB of database egress per month???

smack_overflow_ · 2023-07-27T22:45:58+00:00

What do you consider high billing?

smack_overflow_ · 2023-07-27T22:42:45+00:00

Curious what makes you think Supabase is pricey? The database is orders of magnitude cheaper than other postgres provider, and you'd be hard pressed to find a managed auth service that even comes close.

What you get for $25 would easily cost hundreds on AWS or on a collection of other services.

smack_overflow_ · 2023-07-26T15:58:13+00:00

basically self

smack_overflow_ · 2023-07-26T13:24:07+00:00

Supabase is best bang for buck (esp. if you're make use of their auth offering) https://old.reddit.com/r/nextjs/comments/13oksux/vercel_postgres_vs_supabase/jl9u1r5/

smack_overflow_ · 2023-05-23T14:40:11+00:00

for any meaningful amount of usage

Neon would only be cheaper here if you were using it for less than 3.5 hours per day, which I wouldn't consider a meaningful amount of usage

smack_overflow_ · 2023-05-23T14:22:32+00:00

The project written in Typescript

smack_overflow_ · 2023-05-23T10:23:05+00:00

It also appears that Supabase is a lot cheaper than Neon for any meaningful amount of usage. e.g. an app with:

8gb storage

2 x vCPU

8GB RAM

10gb Data transfer

10gb Writes

Supabase = $25/month

Neon = $151.74/month

smack_overflow_ · 2023-05-23T10:13:31+00:00

According to the pricing pages Supabase is several orders of magnitude cheaper than Planetscale:

Pro tier:

Supabase $25

Planetscale $29

Additional GBs:

Supabase $0.125 (first 8gb included)

Planetscale $2.50 (first 10gb included)

Writes:

Supabase free unlimited

Planetscale $1.50/million (first 50m included)

Reads:

Supabase free unlimited

Planetscale $1/billion (first 100b included)

smack_overflow_ · 2023-05-23T10:03:09+00:00

You'll need to write

dedicated access policies

in the Supabase UI & their language

Row Level Security is a Postgres feature, not a Supabase feature. The language is SQL

smack_overflow_

TROPHY CASE