Xata: Postgres at scale, with copy-on-write branching and anonymization
1–10 of 17 posts
Re: Xata: Postgres at scale, with copy-on-write branching and anonymization
#2Nice to see the underlying tooling is open source, and BYOC. Still, doubtful I'd trust my complex Pg usage to any of these. I've already worked through most of those problems, and don't have time to vet these much less the budget to pay Xata.
Re: Xata: Postgres at scale, with copy-on-write branching and anonymization
#3Nice to see the underlying tooling is open source, and BYOC. Still, doubtful I'd trust my complex Pg usage to any of these. I've already worked through most of those problems, and don't have time to vet these much less the budget to pay Xata.
> I've already worked through most of those problems…
Have you talked about this anywhere? I (and I assume many other HN folks) would appreciate any detail you'd be willing to share.
Re: Xata: Postgres at scale, with copy-on-write branching and anonymization
#4nice seeing stuff like this go open source tbh, always makes me pause though - for stuff you’ve already solved and run yourself, you think anything ever convinces you to switch or is it just about trust at that point
Re: Xata: Postgres at scale, with copy-on-write branching and anonymization
#5Does Xata allow multiple "projects" or databases to share the same compute? As in, can you have a xata.medium with 3 databases running on it, or do you have to do run 3x xata.micro (or other size)?
Also, are there a minimum number of nodes required for PayG (not on-prem)?
I had to write off Xata (Now called Xata Lite) in the past due to the complicated pricing/plans while not being sure it did what I needed. But the new pricing is understandable and with Neon's acquisition I want to know my options.
EDIT: I missed this section at the bottom since I was already off reading other parts of the website:
> Are you looking for a simple, serverless, no-frills Postgres hosting for your side project, prototype, non-profit or vibe coded app? Xata Lite offers a generous free tier and per-storage pricing.
> Are you a Startup, Scaleup, or Enterprise that is running Postgres at scale? Then the new Xata Postgres platform brings you all the benefits outlined by this blog post.
Hmm, as much as I hate being lumped in with "vibe coded apps" I think Xata would only want me on Xata Lite. I'm not running Postgres "at scale". I do want a no-frills Postgres hosting but Xata Lite's pricing is annoying and hard to guesstimate.
Re: Xata: Postgres at scale, with copy-on-write branching and anonymization
#6One of my mentees worked with Xata in their app using Prisma and it wasn't great. The need for a second db for the 'shadow' db that prisma needs, and they would throw Out of Memory errors frequently without any significant usage.
The app now moved to Prisma's postgres hosting and it works like a charm, only thing that changed is the db.
Re: Xata: Postgres at scale, with copy-on-write branching and anonymization
#7One of my mentees worked with Xata in their app using Prisma and it wasn't great. The need for a second db for the 'shadow' db that prisma needs, and they would throw Out of Memory errors frequently without any significant usage. The app now moved to Prisma's postgres hosting and it works like a charm, only thing that changed is the db.
Oh yeah that prisma that decided doing joins in memory was a good idea? Yeah def would trust them to run a db hosting platform too
/s
Re: Xata: Postgres at scale, with copy-on-write branching and anonymization
#8One of my mentees worked with Xata in their app using Prisma and it wasn't great. The need for a second db for the 'shadow' db that prisma needs, and they would throw Out of Memory errors frequently without any significant usage. The app now moved to Prisma's postgres hosting and it works like a charm, only thing that changed is the db.
[Author here] I'm sorry for the bad experience with Xata. If it's still an issue I'd be glad to have a look.
Just to make sure, I suppose this is on the Xata Lite free tier, not on the Postgres at scale platform that this blog post talks about.
Re: Xata: Postgres at scale, with copy-on-write branching and anonymization
#9What's the use case for database branching?
Re: Xata: Postgres at scale, with copy-on-write branching and anonymization
#10What's the use case for database branching?
If you use a branch per issue you can't have a single staging database. You need multiple databases.