The Curious Engineer

All blogs / Databases

Xata blog

xata.io

Insights and updates from the Xata team.

DatabasesDevOps / SRE / infrastructure

’21’22’23’24’25’26
Posts
167 from 13 Sep 2021 to 29 Oct 2026
Posting
weekly (50 in the last year)
Kind
company blog
Feed
https://xata.io/rss.xml

2026 43

  1. Postgres branching without moving your database
  2. Introducing the Xata MCP server 2.0
  3. Xata
  4. Multi-tenant BYOK encryption in PostgreSQL with pgcrypto
  5. PostgreSQL
  6. The instant database scratchpad: xata scratch
  7. Introducing the Xata GitHub App
  8. PostgreSQL as a temporal database
  9. Branch Logs: PostgreSQL observability, right in the console
  10. pgstream v1.1.0: Steps towards turning it into a service
  11. pgstream
  12. A thousand Postgres branches for $1
  13. Query Editor v2: A Better Way to Write SQL in Xata Console
  14. Design
  15. How we rebuilt PostgreSQL branch metrics on VictoriaMetrics, per cell
  16. Building production AI apps with Xata and Claude Code
  17. A connection pooler for every Postgres branch, scaling to zero instances with it
  18. Inside Xatastor: ZFS + NVMe-oF for millions of Postgres databases
  19. AI codes. Humans engineer
  20. Code Review for Vibe Coders
  21. The Rural Reset: Club Xata France 2026
  22. What if database branching was easy?
  23. Xata is now open source
  24. Introducing Xata OSS: Postgres platform with branching, now Apache 2.0
  25. The missing layer in LLM knowledge bases
  26. Every AI agent needs a database it can break
  27. We skipped the OLAP stack and built our data warehouse in vanilla Postgres
  28. My git-worktree setup using worktrunk and caddy
  29. The 5 Best Data Anonymization Tools for Development Teams in 2026
  30. Data Pseudonymization Explained: When Anonymization Isn't Enough
  31. Skim-review is the new normal. Your data workflow has to catch up
  32. Dynamic Data Masking: Use Cases, Limitations, and Going Beyond
  33. Is Postgres really enough in 2026?
  34. Introducing the xata CLI container image: Automate your database workflows in Kubernetes
  35. What is database branching? A complete guide for development teams
  36. pgstream v1.0.0: Stateless schema change replication
  37. Secure by design: Data masking, obfuscation, and pseudonymization for engineering teams
  38. Pseudonymization vs. Anonymization: Which approach fits your data strategy?
  39. Xata acquires Privacy Dynamics for advanced anonymization
  40. Anonymization: The missing link in dev workflows
  41. Introducing AI-assisted PII removal for safer staging
  42. Database branching for AI coding agents: a minimal, CLI-first setup that actually works
  43. Optimizing data throughput for Postgres snapshots with batch size auto-tuning

2025 44

  1. Modernize your database workflows without a migration (code with real data)
  2. Teaching Claude Code to use isolated database branches with Agent Skills
  3. What you should know about constraints in PostgreSQL
  4. Closing the loop: Building a coding agent that uses Postgres branches
  5. How we improved Organization Invites to Keycloak
  6. Tips for configuring Neovim for Claude Code
  7. pgstream v0.9.0: Better schema replication, snapshots and cloud support
  8. The Villa Getaway: Club Xata Rome 2025
  9. Recap of Berlin Postgres Meetup on September 23rd 2025
  10. Going down the rabbit hole of Postgres 18 features
  11. From natural language to SQL queries: How we built Generate SQL with AI
  12. Making Postgres scale to zero with CNPG
  13. pgstream v0.8.1: hstore transformer, roles snapshotting, CLI improvements and more
  14. From DBA to DB Agents
  15. PGConf.EU Community Events Day: CfPs closing soon
  16. Postgres in Malmö: Powered by Elly Phneah
  17. Zero Downtime Schema Changes with Vercel and Xata
  18. pgroll is on a roll! We hit 5k stars on Github
  19. Reaction to the PlanetScale PostgreSQL benchmarks
  20. pgroll 0.14 - New commands and more control over version schemas
  21. Behind the scenes: Speeding up pgstream snapshots for PostgreSQL
  22. PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 2
  23. pgstream v0.7.1: JSON transformers, progress tracking and wildcard support for snapshots
  24. Neon vs Supabase vs Xata: Postgres Branching Compared
  25. pgstream v0.6.0: Template transformers, observability, and performance improvements
  26. pgroll v0.13.0: Start using pgroll on existing databases with the new baseline feature
  27. Xata Agent v0.3.1: Custom tools via MCP, Ollama integration, support for reasoning models & more
  28. From OpenAPI Spec to MCP Server: A Practical Guide with Kubb and Next.js
  29. pgstream v0.5.0: New transformers, YAML configuration, CLI refactoring & table filtering
  30. Highlights from PGConf.DE 2025
  31. Off the grid, on the same page - Club Xata Iceland 2025
  32. Xata: Postgres with data branching and PII anonymization
  33. pgroll v0.12.0: create command, verbose mode & idempotent migrate command
  34. Xata Agent v0.2.0: Powered-up chat, custom playbooks, GCP support & more
  35. pgroll v0.11.0: YAML migration support, pgroll.migration table improvements & more
  36. Writing an LLM Eval with Vercel's AI SDK and Vitest
  37. pgstream v0.4.0: Postgres-to-Postgres replication, snapshots & transformations
  38. Are AI agents the future of observability?
  39. pgroll 0.10.0 update
  40. Postgres Cafe: Building PostgreSQL extensions in Zig using pgzx
  41. pgroll 0.9.0 update
  42. Anatomy of table-level locks: Reducing locking impact
  43. Postgres Cafe: Solving schema replication gaps with pgstream
  44. Anatomy of Table-Level Locks in PostgreSQL

2024 51

  1. Postgres Cafe: Exploring pgroll for zero-downtime schema changes
  2. pgroll v0.8.0: Support for multi-column primary keys, multi-column constraints & new CLI commands
  3. Is pg_dump a backup tool?
  4. Changes to the Xata free plan
  5. Maintaining Postgres for Modern Workloads
  6. Prague PostgreSQL Meetup on November 18th
  7. Recap of PGConf.EU 2024 in Athens
  8. Schema changes and the power of expand-contract with pgroll
  9. Prague PostgreSQL Meetup on October 29th
  10. pgroll 0.7.0 update
  11. What I look forward to at PGConf.EU in Athens
  12. Trackstack improves query performance by 67% with Xata
  13. Recap of OSS Vienna: What is Happening in the Open Source World
  14. Prague PostgreSQL Meetup on September 30th
  15. HydroPro Solutions achieves a 60% reduction in search time using the Xata Postgres-powered platform
  16. Meet Xata at PGConf NYC 2024
  17. Savas Labs saves 60+ hours in development time with Xata's Serverless Postgres
  18. Postgres Happy Hour with Xata at Open Source Summit Europe
  19. Postgres webhooks with pgstream
  20. If pg_dump is not a backup tool, what is?
  21. Modernizing the conference management backend of the World Affairs Conference
  22. Switching gears from law to launch
  23. Why you should upgrade PostgreSQL today
  24. Announcing the summer hackathon winners
  25. pgzx: Version 0.2.0 update
  26. pgroll v0.6.0: Retry logic, alter multiple columns in one operation, raw SQL migrations & more
  27. Postgres major version upgrades with minimal downtime
  28. Introducing pgstream: Postgres replication with DDL changes
  29. Introducing multi-version schema migrations
  30. Announcing the public beta for dedicated clusters
  31. The economics of a Postgres free tier
  32. Summer launch week hackathon with the PXCI stack
  33. Schema changes and the Postgres lock queue
  34. Simplifying critical heart transplant waitlist data with Xata
  35. Accelerating app development with Xata as the data layer
  36. Developing a personalized mood enhancement service
  37. Geographically distributed Postgres for multi-tenant applications
  38. Simplifying license management and reducing costs with AWS and Xata
  39. Club Xata reunion: teamwork across borders
  40. Website deep dive: A fresh website for a new future
  41. Introducing Dedicated Clusters for PostgreSQL
  42. Introducing pgzx: create PostgreSQL extensions using Zig
  43. Introducing usage monitoring
  44. Using Prisma with Xata's Postgres service
  45. Powering up schema migrations with pgroll
  46. Xata launch week Easter egg hunt
  47. A new serverless Postgres platform
  48. Xata celebrates International Women's Day
  49. Educating new frontend developers with Xata
  50. How to perform Postgres schema changes in production with zero downtime
  51. Reducing search response time by 99.98% with Xata

2023 24

  1. The Club Xata experience - connecting, collaborating, creating
  2. Automating the creation of Shopify stores with Xata
  3. How pgroll works under the hood
  4. What is horizontal sharding?
  5. Using Next.js to improve speed and efficiency at Xata
  6. Simplifying architecture for a hotel management SaaS solution
  7. Database nightmares: Tales from the Postgres crypt
  8. Distilling news articles and legal research into simple chat experiences
  9. Introducing pgroll: zero-downtime, reversible, schema migrations for Postgres
  10. SQL over HTTP and ORM integrations
  11. LangChain Integrations
  12. Bring (and take) your own data with CSV import and export
  13. Designing your database schema
  14. Navigating the database landscape: overview of SQL, MySQL, PostgreSQL, and NoSQL
  15. Full-text search engine with PostgreSQL (part 2): Postgres vs Elasticsearch
  16. Create an advanced search engine with PostgreSQL
  17. Postgres schema changes are still a PITA
  18. Introducing the new Xata regions: Sydney & Frankfurt
  19. On the performance impact of REPLICA IDENTITY FULL in Postgres
  20. Club Xata Reunion
  21. How we implemented database renaming
  22. Accelerating time-to-market for ecommerce platform Batchoop
  23. Xata powers search for RankOne’s social platform
  24. Announcing the winners of the Xata challenge

2022 4

  1. Coming together to build Xata
  2. Branching brings predictability to web development
  3. Xata launches a serverless database with the usability of a spreadsheet
  4. Talking about serverless databases

2021 1

  1. Hello, world! Xata raises $5M for a new type of serverless database