Blog
Xata Agent v0.2.0: Powered-up chat, custom playbooks, GCP support & more
By Alex Francoeur
• April 16, 2025
Version 0.2.0 introduces a redesigned chat interface, customizable playbooks, support for monitoring PostgreSQL instances on Google Cloud Platform and various improvements across the board.
pgroll 0.11.0 update
By Noémi Ványi
• April 8, 2025
pgroll v0.11 includes support for YAML migration files, a fix for the bookkeeping of pgroll, and smaller usability improvements.
Writing an LLM Eval with Vercel's AI SDK and Vitest
By Richard Gill
• April 2, 2025
LLM Evals - testing for applications using LLMs
pgstream v0.4.0: Postgres-to-Postgres replication, snapshots & transformations
By Esther Minano Sanz
• March 27, 2025
Learn how the latest features in pgstream refine Postgres replication with near real-time data capture, consistent snapshots, and column-level transformations.
Are AI agents the future of observability?
By Tudor Golubenco
• March 25, 2025
After vibe coding, is vibe observability next?
pgroll 0.10.0 update
By Andrew Farries, Noémi Ványi
• February 28, 2025
pgroll v0.10 includes one breaking change, a new subcommand to convert SQL statements into pgroll operations and improvements to adding default values to existing tables.
Postgres Cafe: Building PostgreSQL extensions in Zig using pgzx
By Cezzaine Zaher
• February 12, 2025
In this episode of Postgres Café, we discuss pgzx, an open-source Zig framework for developing PostgreSQL extensions that combine modern memory safety, direct C interoperability, and flexible design.
pgroll 0.9.0 update
By Andrew Farries
• February 10, 2025
pgroll v0.9 includes one breaking change, several improvements to table level constraint definitions and better CLI feedback
Anatomy of table-level locks: Reducing locking impact
By Gulcin Yildirim Jelinek
• January 20, 2025
Not all operations require the same level of locking, and PostgreSQL offers tools and techniques to minimize locking impact.
Postgres Cafe: Solving schema replication gaps with pgstream
By Cezzaine Zaher
• January 15, 2025
In this episode of Postgres Café, we discuss pgstream, an open-source tool for capturing and replicating schema and data changes in PostgreSQL. Learn how it solves schema replication challenges and enhances data pipelines.
Anatomy of Table-Level Locks in PostgreSQL
By Gulcin Yildirim Jelinek
• January 13, 2025
This blog explains locking mechanisms in PostgreSQL, focusing on table-level locks that are required by Data Definition Language (DDL) operations.
Postgres Cafe: Exploring pgroll for zero-downtime schema changes
By Gulcin Yildirim Jelinek
• December 18, 2024
Discover how pgroll helps teams manage schema changes with ease in our new Postgres Cafe blog and video series.
pgroll 0.8.0 update
By Andrew Farries
• December 9, 2024
Learn about the latest changes in pgroll in the v0.8.0 release as we add new CLI commands, expand what's possible with multi-column keys and constraints and add performance benchmarks.
Is pg_dump a backup tool?
By Gulcin Yildirim Jelinek
• December 5, 2024
I was invited to the Postgres.fm podcast together with Robert Haas, hosted by Michael Christofides and Nikolay Samokhvalov, to discuss the technical aspects of the question if pg_dump is a backup tool, and in what way it is or is not.
Changes to the Xata free plan
By Tudor Golubenco
• December 4, 2024
We're announcing important changes to the Xata free tier plan.
Maintaining Postgres for Modern Workloads
By Gulcin Yildirim Jelinek
• November 27, 2024
I was invited to the Maintainable Podcast hosted by Robby Russell. We talked about what makes software maintainable and naturally we also talked about Postgres.
Prague PostgreSQL Meetup on November 18th
By Gulcin Yildirim Jelinek
• November 17, 2024
The Prague PostgreSQL Meetup will take place on November 18th!
Recap of PGConf.EU 2024 in Athens
By Gulcin Yildirim Jelinek
• November 15, 2024
My notes from PGConf.EU 2024 in Athens, Greece. Talks, extension summit, diversity committee meeting, Xata Postgres dinner, and more!
Schema changes and the power of expand-contract with pgroll
By Andrew Farries
• November 13, 2024
A pgconf EU talk recap covering how the expand-contract pattern and pgroll enable zero-downtime schema changes and rollbacks.
Prague PostgreSQL Meetup on October 29th
By Gulcin Yildirim Jelinek
• October 28, 2024
The next Prague PostgreSQL Meetup will take place on October 29th!
pgroll 0.7.0 update
By Andrew Farries
• October 23, 2024
Learn about the latest changes in pgroll in the 0.7.0 release as we continue developing it into a leading open-source schema migration tool for Postgres.
What I look forward to at PGConf.EU in Athens
By Gulcin Yildirim Jelinek
• October 21, 2024
The 14th PostgreSQL Conference in Europe is taking place in Athens, Greece from 22-25 October 2024. In this blog post, I will be sharing what I look forward to at PGConf.EU 2024 including a great keynote, extension ecosystem summit, Xata dinner and more.
Trackstack improves query performance by 67% with Xata
By Cezzaine Zaher
• October 16, 2024
Discover how Trackstack improved PostgreSQL query performance by 67 percent, saving 32 hours of developer time per month, after migrating from PlanetScale to Xata, a fully managed and serverless database solution.
Recap of OSS Vienna: What is Happening in the Open Source World
By Gulcin Yildirim Jelinek
• October 4, 2024
My notes from the Open Source Summit Europe in Vienna, featuring fresh updates from open source communities, insights from the Xata booth, and highlights from our Postgres Happy Hour
Prague PostgreSQL Meetup on September 30th
By Gulcin Yildirim Jelinek
• September 25, 2024
The fifth Prague PostgreSQL Meetup of 2024 will take place on September 30th!
HydroPro Solutions achieves a 60% reduction in search time using the Xata Postgres-powered platform
By Cezzaine Zaher
• September 19, 2024
Discover how HydroPro Solutions reduced search time by 60% and transformed their operations with the powerful Postgres-based serverless database solution from Xata, streamlining water meter installations and improving overall efficiency.
Meet Xata at PGConf NYC 2024
By Cezzaine Zaher
• September 17, 2024
Join Xata at PGConf NYC 2024 as we showcase our serverless Postgres platform and present key talks on schema migrations and PostgreSQL operational pain points and solutions.
Savas Labs saves 60+ hours in development time with Xata's Serverless Postgres
By Cezzaine Zaher
• September 5, 2024
See how Savas Labs saved 60+ hours in development time with Xata’s serverless Postgres solution, improving database management and accelerating digital projects for clients like the Environmental Integrity Project.
Postgres Happy Hour with Xata at Open Source Summit Europe
By Gulcin Yildirim Jelinek
• September 3, 2024
Join us for the Postgres Happy Hour in Vienna on September 18th!
Postgres webhooks with pgstream
By Tudor Golubenco
• August 27, 2024
A simple tutorial for calling webhooks on Postgres data and schema changes using pgstream.
If pg_dump is not a backup tool, what is?
By Gulcin Yildirim Jelinek
• August 23, 2024
pg_dump was a utility for backing up a PostgreSQL database, not anymore
Modernizing the conference management backend of the World Affairs Conference
By Alex Francoeur
• August 21, 2024
Putting the spotlight on Samuel Martineau, a software developer apprentice based out of Québec, Canada replacing the backend of a conference management system with Xata.
Switching gears from law to launch
By Lea Artemov
• August 13, 2024
How I ditched the traditional world of law for the fast paced tech start up scene
Why you should upgrade PostgreSQL today
By Gulcin Yildirim Jelinek
• August 9, 2024
Upgrade PostgreSQL today to avoid CVE-2024-7348 vulnerability
Announcing the summer hackathon winners
By Cezzaine Zaher
• July 19, 2024
Out of many fantastic submissions, the judges have chosen the winners for the PXCI Summer Hackathon in collaboration with Prisma, Clerk and Inngest.
pgroll 0.6.0 update
By Andrew Farries
• July 19, 2024
Learn about the latest changes in pgroll in the 0.6.0 release as we continue to build and turn it into a first-class open-source schema migration tool for Postgres.
Postgres major version upgrades with minimal downtime
By Carlos Pérez-Aradros Herce
• July 18, 2024
With the beta release of dedicated clusters, we've added the ability to move branches between clusters. Xata customers can now perform Postgres major version upgrades with minimal downtime.
Introducing pgstream: Postgres replication with DDL changes
By Esther Minano Sanz
• July 17, 2024
Today we’re excited to expand our open source Postgres platform with pgstream, a CDC command line tool and library for PostgreSQL with replication support for DDL changes to any provided output.
Introducing multi-version schema migrations
By Andrew Farries
• July 16, 2024
Today's release of multi-version schema migrations addresses one of the most common pain points of application deployment - keeping your application code and database schema in sync. You can now present two versions of your schema, both old and new, to client applications.
Announcing the public beta for dedicated clusters
By Alex Francoeur
• July 15, 2024
Today we're excited to open up dedicated clusters to all our customers and some amazing new additions to our serverless Postgres platform.
The economics of a Postgres free tier
By Tudor Golubenco
• July 11, 2024
Let's look at the numbers behind Xata's free tier. How much does a database cost us and why are we offering them for free.
Summer launch week hackathon with the PXCI stack
By Cezzaine Zaher
• July 5, 2024
Join our summer hackathon challenge in collaboration with Prisma, Clerk and Inngest to win some amazing prizes!
Schema changes and the Postgres lock queue
By Andrew Farries
• June 18, 2024
Learn how schema changes can cause downtime by locking out reads and writes and how migration tools can avoid it by using lock timeouts, along with backoff and retry strategies.
Simplifying critical heart transplant waitlist data with Xata
By Cezzaine Zaher
• June 13, 2024
A community spotlight featuring Daniel Reale a QA engineer who used Xata to create an application for personally tracking his son's position on the Philadelphia heart transplant waitlist.
Accelerating app development with Xata as the data layer
By Alex Francoeur
• May 29, 2024
Putting the spotlight on Mathias Eriksson (aka Matzie), founder of Matzielab, a company that has nearly perfected the app development process.
Developing a personalized mood enhancement service
By Alex Francoeur
• May 21, 2024
Putting the spotlight on Dr. Ndubuisi Ekwueme (aka Dr. Dubz), who recently launched Moodly, a service that aims to brighten its users moods.
Geographically distributed Postgres for multi-tenant applications
By Tudor Golubenco
• May 16, 2024
Documenting a pattern for making multi-tenant applications global by distributing the data, using only standard PostgreSQL functionality.
Simplifying license management and reducing costs with AWS and Xata
By Cezzaine Zaher
• May 13, 2024
Putting the spotlight on Ilia Gandelman, who significantly improved a cumbersome software license management system for smart rehabilitation therapy devices using Xata and AWS.
Club Xata reunion: teamwork across borders
By Lea Artemov
• May 7, 2024
Amidst breathtaking views of the Portuguese hilly landscape and early summer sun, we recap our Spring 2024 offsite in Evora for connecting and collaborating with our colleagues.
Website deep dive: A fresh website for a new future
By Elizabet Oliveira
• March 23, 2024
Showcasing the details of the makeover of the Xata website as we move to our new serverless Postgres offering.
Introducing Dedicated Clusters for PostgreSQL
By Simona Pencea, Matt Field
• March 22, 2024
We are announcing dedicated clusters, for more scalable and isolated PostgreSQL databases.
Introducing pgzx: create PostgreSQL extensions using Zig
By Tudor Golubenco, Steffen Siering
• March 21, 2024
We are excited to introduce pgzx, a framework for creating Postgres extensions using the Zig programming language.
Using Prisma with Xata's Postgres service
By Emily Morgan
• March 20, 2024
Get started with Prisma ORM and Xata
Introducing usage monitoring
By Siobhán Meier, Ryan Slade
• March 20, 2024
Learn about the new Usage feature available in Xata
Powering up schema migrations with pgroll
By Emily Morgan
• March 19, 2024
Integrating pgroll into Xata to provide zero-downtime, reversible schema migrations.
Xata launch week Easter egg hunt
By Cezzaine Zaher
• March 18, 2024
Find the hidden egg each day for a chance to win a Meta Quest 3 headset!
A new serverless Postgres platform
By Tudor Golubenco
• March 18, 2024
We're announcing the next major evolution for the Xata data platform, a serverless Postgres service.
Xata celebrates International Women's Day
By Aimee Nolan
• March 8, 2024
Celebrating this years International Women's Day to inspire inclusion
Educating new frontend developers with Xata
By Alex Francoeur
• February 14, 2024
Putting the spotlight on Teri Eyenike, a software engineer out of Lagos, Nigeria empowering the next generation of developers to build.
How to perform Postgres schema changes in production with zero downtime
By Alex Francoeur
• February 2, 2024
Schema migrations are a pain. In this workshop we review the problem space and tools available to make reversible schema changes in production with zero downtime.
Reducing search response time by 99.98% with Xata
By Alex Francoeur
• January 9, 2024
Putting the spotlight on Parker Dinkins, a young founder with a love for geospatial data who recently launched GISData.io.
The Club Xata experience - connecting, collaborating, creating
By Lea Artemov
• December 19, 2023
Enjoying sunny days and starry nights. A look at Xata's Fall 2023 offsite, a time for work and plenty of fun.
Automating the creation of Shopify stores with Xata
By Alex Francoeur
• December 14, 2023
Putting the spotlight on Katriel Lucas, a developer who is simplifying Shopify store creation for small business owners.
How pgroll works under the hood
By Andrew Farries
• November 30, 2023
Learn how pgroll implements zero-downtime schema changes by exploring an example.
What is horizontal sharding?
By J Edwards
• November 23, 2023
A basic overview of horizontal sharding. What is it and what are the challenges?
Using Next.js to improve speed and efficiency at Xata
By Elizabet Oliveira
• November 9, 2023
Discover how Xata utilizes Next.js to enhance speed and efficiency.
Simplifying architecture for a hotel management SaaS solution
By Alex Francoeur
• November 1, 2023
Putting the spotlight on Emanuel Arcos, a software developer from Argentina who is innovating in the hotel management space with a brand new subscription model.
Database nightmares: Tales from the Postgres crypt
By J Edwards
• October 30, 2023
Explore some of the challenges and terrors that can negatively impact your PostgreSQL database project
Distilling news articles and legal research into simple chat experiences
By Alex Francoeur
• October 18, 2023
Putting the community spotlight on Agustín Gomez and Alvaro Machuca, two developers based in Paraguay building real world applications for conversational search with your data.
Introducing pgroll: zero-downtime, reversible, schema migrations for Postgres
By Carlos Pérez-Aradros Herce
• October 3, 2023
We are excited to ship the first version of pgroll, a command line tool that offers safe and reversible schema migrations for PostgreSQL
SQL over HTTP and ORM integrations
By Noémi Ványi
• August 31, 2023
Query PostgreSQL directly with SQL over HTTP in our REST API and SDKs
LangChain Integrations
By Tudor Golubenco
• August 29, 2023
Announcing Xata's integrations with LangChain, available both as a vector store and a memory store.
Bring (and take) your own data with CSV import and export
By Richard Gill
• August 28, 2023
Simplified data import and export in the Xata UI to bring, manage, and retrieve your own data
XataByte: Basics of database indexing
By J Edwards
• August 11, 2023
A basic overview of database indexing - what is a database index and what does it do?
Designing your database schema
By J Edwards
• August 4, 2023
Understanding database schema design - a quick guide with examples
Navigating the database landscape: overview of SQL, MySQL, PostgreSQL, and NoSQL
By J Edwards
• July 25, 2023
An exploration of the SQL,MySQL,PostgreSQL, and NoSQL database options and discussion on where and when to use them.
Full-text search engine with PostgreSQL (part 2): Postgres vs Elasticsearch
By Tudor Golubenco
• July 19, 2023
Using PostgreSQL as a full-text search engine is tempting because it requires less infrastructure. But is its set of search-related features enough to compete with the Lucene based alternatives?
Create an advanced search engine with PostgreSQL
By Tudor Golubenco
• July 12, 2023
PostgreSQL provides the necessary building blocks for you to combine and create your own search engine for full-text search. Let's see how far we can take it.
Postgres schema changes are still a PITA
By Tudor Golubenco
• June 29, 2023
Table locking, downtime risks, long running migrations, manual steps, difficult rollbacks. Is there a better way?
Introducing the new Xata regions: Sydney & Frankfurt
By J Edwards
• June 27, 2023
Discover enhanced data accessibility and global reach with Xata's newest regions.
On the performance impact of REPLICA IDENTITY FULL in Postgres
By Tudor Golubenco
• June 7, 2023
Analyzing the performance impact of REPLICA IDENTITY FULL by looking at the PostgreSQL source code and performing benchmarks.
Club Xata Reunion
By Lea Artemov
• May 31, 2023
A Remote Adventure in the Mountains. Recapping Xata's Spring 2023 offsite.
How we implemented database renaming
By Noémi Ványi
• May 26, 2023
Starting today, you can now rename your Xata database
Accelerating time-to-market for ecommerce platform Batchoop
By Alex Fancoeur
• April 20, 2023
In this community spotlight, we are excited to introduce Charles Bellorini, Xavier Dersy and their innovative tatcommerce company, Batchoop.
Xata powers search for RankOne’s social platform
By Alex Francoeur
• February 7, 2023
RankOne is using Xata to bring streamers closer to their audience.
Announcing the winners of the Xata challenge
By Alex Francoeur
• January 13, 2023
We're excited to announce the winners of the first Xata Challenge.
The Xata serverless database community
By Atila Fassina
• August 3, 2022
Join the Xata serverless database community on Discord for free and inclusive networking, and learning opportunities.
Coming together to build Xata
By Tudor Golubenco
• April 4, 2022
Take a look at our photo-blog post about Xata's first off-site, featuring insights on our learnings.
Branching brings predictability to web development
By Anjalee Sudasinghe
• March 21, 2022
Explore the advantages of branching in developer workflows and how Xata brings these benefits to data infrastructure.
Xata launches a serverless database with the usability of a spreadsheet
By Monica Sarbu
• March 8, 2022
We’re excited to announce that we’ve raised a Series A investment of $30M, co-lead by Redpoint and Index Ventures.
Talking about serverless databases
By Tudor Golubenco
• February 6, 2022
Proposing a definition for serverless databases and adding some clarity to the discussion.
Hello, world! Xata raises $5M for a new type of serverless database
By Monica Sarbu
• September 13, 2021
Learn what Xata is and how it can revolutionize your development experience.
Start free,
pay as you grow
Xata provides the best free plan in the industry. It is production ready by default and doesn't pause or cool-down. Take your time to build your business and upgrade when you're ready to scale.
- Single team member
- 10 database branches
- High availability
- 15 GB data storage
- Single team member
- 10 database branches
- High availability
- 15 GB data storage
Copyright © 2025 Xatabase Inc.
All rights reserved.