Xata can be a good alternative to Planetscale Serverless?
Planescale is a serverless database recommended in the t3stack docs. Xata codegen seems like giving better generator of database code than prisma, also allow table relations thing that Planetscale don't allow, and have integrate search and analytics functionality. Does anyone know a comparison between these two serverless databases? Xata pricing is cheap? Xata is ready for production or we should wait a few months first?
25 Replies
is xata stable?
they say it is in his launch, but nobody is sure.
i mean
a database that isnt stable for sure
i would not trust it for a production app
i would take CockroachDB over xata as for now
plus aws aurora too
CockroachDB is serverless?
can be
"A distributed SQL datatabase designed for speed, scale, and survival"
i wanna be easy to integrate, easy to scale and integrate
i have to check it out
CockroachDB Docs | CockroachDB Docs
CockroachDB is the SQL database for building global, scalable cloud services that survive disasters.
Serverless Performance Benchmarking | CockroachDB Docs
Learn more about CockroachDB Serverless performance benchmarks
any ideas on the other questions?
planetscale != planetscale serverless driver
two whole different products
but what advantage give me CockroachDB right know over Plantescale?
the serverless driver is better for edge stuff
but isnt typesafe
npm
kysely-planetscale
Kysely dialect for PlanetScale Serverless. Latest version: 1.1.0, last published: a month ago. Start using kysely-planetscale in your project by running
npm i kysely-planetscale. There is 1 other project in the npm registry using kysely-planetscale.planetscale at edge
cockroach is postgres based
ps is mysql based
the first you can self host if you want, the second not
you have vitess for the second but dont bother with it
good point
ps free plan is nice too
HobbyOne database per organization Free
5 GB storage
1 billion row reads/mo
10 million row writes/mo
1 production branch
1 development branch
Community support
bleeding edge is fun
but not on databases
wow, CockroachDB seems very good
you should try both and see the differences yourself
unless you know a sql service is production ready and battle tested
its too much dangerous to use in productionj
yeah, i know, i was asking about it, because Xata seems very good, but i know that is too early
What do you think is the main diference between this? When someone should choose a serverless database?
you dont know when a sudden load on the database can happen
or is using stuff on the edge
serverless is a "infinite scale" concept
but you also have a premium tax
for the same resources, you pay some % more because its serverless
right know i'm building a new app that is deployed in Vercel, Pusher for Websockets and i was using Supabase as database, but i was looking for a replace for Supabase
you can use prisma + ps + kysely
edge but with type safety
for a postgres compatible
cockroach is serverless
prisma + prisma proxy + whatever here
is fine for most part
thanks
i will try CockroachDB
gl
cockroach should be wire-compatible with postgresql, so you can use Kysely's built-in postgres dialect