planet scale vs digital ocean?
Planet scale seems overpriced … why is it a good choice over other services?
40 Replies
you pay a premium for the luxury of never managing your own database deployment
they do so much complex stuff behind the scenes to allow you to not think about connection limits, performance, branching, caching and more
Hmm interesting
They also have planetscale boost which might be good for you if u have super demanding queries
Aws aurora is kinda sweet though and fairly cheap would go for that over DO easily
DO has been troubling lately, my team is planning to migrate out.
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
DO has managed databases they just aren't as good
try cockroach db
way more reasonable pricing
and fully managed serverless db like pscale
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
ooo nexxel got beef with planetscale?
Go pscale or aws, don't deal with non MySQL/postgres unless u really know what ur doing
No I love planetscale, but don't love their pricing
damn
Why you lump Postgres there? 👀genuinely curious
Postgres is a proven prod database that can be run anywhere. I think it fine to use
unless you have a heavy use on database
to the point of being a bottleneck
mysql/postgres there is no difference
My understanding is that MySQL is slightly better at read ops and postgres tends to have better features or devs new stuff faster. Either are fine.
There are specialty databases as well but don't bother with them unless ur scale is insane and the db iand use case is super specific
Postgres
ilike is fine
But full text search is bad either way
Iirc the PS CEO was talking about things people say in favor of pg
Like "the first db to accept json" but when was finally ready to use on production, MySQL also had the featureits the opposite actually
postgres is optimized for reads, mysql is optimized for writes
its because postgres doesn't block reads when writing. this is the most important difference between postgres and mysql
Everything I've read over the years says ur wrong but happy to read some of your material if u have it
Wrong about the general concensus not the blocking parts
if you just look at reads
mysql will be faster
but postgres will 100% be faster for reads if data is being written and read frequently
if you have users this is probably the case
MySQL is generally known to be faster with read-only commands at the cost of concurrency, while PostgreSQL works better with read-write operations, massive datasets, and complicated queries
Dude u are so confusing, I said this generically speaking. And u said MySQL was optimized for writes
U lost me
lemme search online wait i might be wrong
all my knowledge is just from discussions on discord so i might be wrong
Yea but even in these last few messages uve said various things that conflict
oh well
But also like Neto said it's minor differences at best these days
Performance wise
For most apps
the concurrency is probably the major difference
Any prod worthy app should have a read replica anyways if things are blocking
of course postgres has some more features but yeah sure they aren't used often
like spatial points iirc
for PS could make more sense to use mysql (vitess but still)
their use of database isnt our avg use
GitHub
GitHub - citusdata/citus: Distributed PostgreSQL as an extension
Distributed PostgreSQL as an extension. Contribute to citusdata/citus development by creating an account on GitHub.
vitess like for pg
uhh
Generically speaking pick pg or MySQL and use a manages service like rds or pscale always
Don't run your own db it's not worth it
the premium tax is worth it
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
serverless is very scalable
also idk how you compared the pricings cause they are different pricing models
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
its pay as you go
the clearest pricing model ever
idk how much simpler it can get
branching is great!
planetscale def has great features and is pioneering serverless dbs for sure
thats why i like them
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
yea thats not straightforward at all LMAO
i don't get it lol
its pretty clear to me
RUs are pretty standard 🤷