Postgres with data branching and PII anonymization
a year ago
- #PostgreSQL
- #Database
- #Cloud Computing
- Xata relaunches as 'Postgres at scale', offering a new PostgreSQL platform with features like Copy-on-Write branching and PII anonymization.
- The platform is cloud-agnostic, supports BYOC (Bring Your Own Cloud), and separates storage from compute for better scalability and cost efficiency.
- Key features include instant data branching, data anonymization for developer branches, and compatibility with existing PostgreSQL services like AWS RDS and Aurora.
- Xata addresses organizational challenges at scale, including zero-downtime schema changes, realistic testing data without PII, and ephemeral developer environments.
- The platform integrates open-source projects pgstream (for replication and masking) and pgroll (for zero-downtime schema changes).
- Xata's storage system, powered by Simplyblock, enables features like instant Copy-on-Write branching and distributed storage over NVMe/TCP.
- Compute is managed via Kubernetes and CloudNativePG, ensuring high availability, scalability, and cloud-agnostic deployment.
- Xata offers significant cost savings (up to 80% compared to Aurora) with a simple pay-as-you-go pricing model for compute and storage.
- The Xata Agent, an LLM-powered tool, helps optimize and tune PostgreSQL instances.
- Existing Xata users can continue using Xata Lite, a free tier for smaller projects, while the new platform targets startups and enterprises.