Blog
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.
Guide to developing a travel application: Xata, Next.js, Tailwind CSS, & Vercel
By Teri Eyenike
• June 6, 2024
Learn how to create a travel dashboard application using Xata, Next.js, Tailwind CSS, and Vercel to help you track your adventures and organize your travel experiences.
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.
Build authenticated and paywall pages with Stripe and Xata
By Rishi Raj Jain
• April 10, 2024
Learn how to build protected and paywall pages using using Astro, Stripe, Lucia Auth, Xata and Vercel.
Building Streamlit apps faster with the Xata connector
By Alex Francoeur
• April 3, 2024
Putting the spotlight on Sergio Demis Lopez Martinez, the developer responsible for a new open source Streamlit: Xata connector.
Caching OpenAI Chat API Responses with LangChain and Xata
By Rishi Raj Jain
• March 27, 2024
Learn how to cache OpenAI Chat API responses in LangChain with Xata.
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 Drizzle with Xata's Postgres service
By Alexis Rico
• March 20, 2024
Get started with Drizzle ORM and Xata
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
Building a Retrieval-Augmented Generation Chatbot with SvelteKit and Xata Vector Search
By Rishi Raj Jain
• February 28, 2024
Learn how to create a Retrieval-Augmented Generation Chatbot using Xata, SvelteKit, LiteLLM, TailwindCSS and Vercel.
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.
Create your own content management system with Remix and Xata
By Rishi Raj Jain
• February 7, 2024
Learn how to create a custom CMS using Xata, Remix, Novel, LiteLLM, and Vercel.
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.
Announcing the winners of the Holiday Hackathon
By Alex Francoeur
• February 1, 2024
We're excited to announce the winners of the Holiday Hackathon
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.
Build your own image gallery CMS
By Rishi Raj Jain
• January 4, 2024
Learn how to create a custom image gallery CMS using Xata, Astro, and Cloudflare Pages.
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.
Connect your Cloudflare Worker with Xata in one click
By Alexis Rico
• December 14, 2023
Connecting a Cloudflare Worker with Xata is now possible from the Cloudflare dashboard.
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.
Add feature flags in Astro apps using Xata and Vercel
By Rishi Raj Jain
• December 12, 2023
Follow this tutorial to learn how to implement feature flags in your Astro apps with Xata and Vercel.
Holiday Hackathon
By Alex Francoeur
• December 8, 2023
Join in on the holiday cheer by entering the Xata Holiday Hackathon!
Announcing the release of the Xata Go SDK
By Philip Krauss
• December 6, 2023
We are excited to announce the initial alpha version of the Xata Go SDK.
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.
Announcing the winners of the Xata content hackathon
By J Edwards
• October 13, 2023
Celebrate the standout creators and contributions from Xata's 2023 launch week content hackathon
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
Xata Playground now runs Python in the browser
By Alexis Rico
• September 18, 2023
You can write code in the Xata Playground using Python, TypeScript, and SQL.
Indexing File Attachments with the Python SDK
By Kostas Botsas
• September 14, 2023
Extracting text from File Attachments and indexing it with Python.
Building a chatbot with OpenAI, Vercel AI and Xata
By Alexis Rico
• September 6, 2023
Ask your data questions and get intuitive, efficient answers with OpenAI, Vercel AI and Xata
Introducing the JSON column type
By Alejandro Martínez
• September 1, 2023
Use the new JSON column type for improved data storage in Xata.
Reduce query round trips with improved one-to-many relations
By Alejandro Martínez Vieites
• September 1, 2023
Addressing the N+1 problem and navigating one-to-many relationships with Xata's new approach.
New Getting Started Guides: Astro, Next.js, Nuxt, Remix, SolidStart, and SvelteKit
By Phil Leggetter
• September 1, 2023
Learn how to add Xata database and full-text search functionality to Astro, Next.js, Nuxt, Remix, SolidStart, and SvelteKit with our new Getting Started guides.
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
File Attachments: Databases can now store files and images
By Sorin Toma
• August 30, 2023
Extending a database record to include a new file column type with a global CDN, common security boundaries, and image transformations.
Announcing General Availability of the Python SDK
By Philip Krauss
• August 29, 2023
We are excited to ship the first generally available version of the Xata Python SDK.
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
Launch Week
By Alex Francoeur
• August 28, 2023
Join us for an exciting week filled with announcements, fun activities, and a chance to win prizes!
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.
Connecting data sources to Xata with Airbyte and Zapier integrations
By Kostas Botsas
• July 6, 2023
Effortlessly automate data ingestion with Xata integrations
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.
Server Actions, databases, and the future of data handling
By Atila Fassina
• June 21, 2023
Check out how Xata is improving data handling in modern apps using React advancements
The next era of databases are serverless, adaptive, and collaborative
By Alex Francoeur
• June 14, 2023
Take a look at the ideal database for tomorrow's builders: exceeding application needs, encouraging teamwork, and enhancing developer efficiency
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
XataForm is here!
By Fabien Bernard
• May 4, 2023
New open-source project to deal with your forms, survey and quizzes!
End-to-end preview deployment workflows with Xata and Vercel
By Alex Francoeur
• April 26, 2023
Preview deployments have changed the way we work. Xata's integration with Vercel brings the data layer directly into that workflow.
Modern database workflows with GitHub, Vercel, Netlify, and Xata
By Alex Francoeur
• April 26, 2023
Finally, a database with a complete end-to-end developer workflow.
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.
Search three ways with Xata
By Benedicte Raae
• April 14, 2023
There comes a time in every project where the next feature on the roadmap is search. In this example, we’ll walk you through three different ways you can search your Xata database.
The story behind xata-go, a Go SDK for Xata
By Alex Francoeur
• April 12, 2023
Putting the community spotlight on Kerdo Kurs, the creator of xata-go, a Go SDK for Xata.
Building a datetime picker for a database
By Richard Gill
• April 5, 2023
Learn how we built a next-generation datetime picker for a next-generation database.
The importance of data modeling in TypeScript
By Fabien Bernard
• March 28, 2023
Take a deep dive into TypeScript to explore the importance of data modeling.
Build Next.js apps with JWT authentication, Auth.js, and Xata
By Attila Fassina
• March 23, 2023
Use Xata and Auth․js on two Next․js apps: app directory and pages directory.
How we reduced our API Latency by 50% using Cloudflare
By Paula Guijarro
• March 15, 2023
Discover how we boosted speeds by switching to Cloudflare and get insights into our migration journey.
Semantic or keyword search for finding ChatGPT context. Who searched it better?
By Tudor Golubenco
• March 6, 2023
The blog post compares keyword search with semantic/vector search for the task of selecting context for an ChatGPT-based questions and answers bot.
Xata & OpenAI: ChatGPT for your data
By Daniel Everts
• March 2, 2023
Use Xata to ask your data questions and get the answers that matter most.
Semantic search with Xata, OpenAI, TypeScript, and Deno
By Tudor Golubenco
• March 2, 2023
Reduce complex data and perform similarity search with Xata.
How to fuzzy search with Xata
By Benedicte Raae
• February 13, 2023
Explore the world of free text search possibilities with Xata and take a deep dive into fuzzy search.
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.
A new trend for databases: platforms
By Tudor Golubenco
• February 3, 2023
It's about more than the data stored in your table; it's what you can do with that data.
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.
Xata, tRPC, and Clerk: the killer combo
By Fabien Bernard
• January 13, 2023
Build a fully typed application with Clerk for authentication and tRPC for a robust stack.
Xata Workers: client-side database access without client-side secrets
By Alexis Rico
• January 1, 2023
Xata Workers act as middleware to simplify database access and deploy front-end functions on databases.
Hackmamba Jamstack Content Hackathon 2.0
By Fabien Bernard
• December 12, 2022
Two full weeks of learning, writing, and networking to support the dev community.
Take a closer look at Xata's latest starter templates
By Fabien Bernard
• December 12, 2022
Begin your Xata journey with our new starters - SolidStart, Astro, and SvelteKit.
Searching for retro games with Xata & Next.js 13
By Anjana Vakil
• November 2, 2022
Creating a full-stack web app to search retro games data and prioritize highly-rated games in the results.
Xata is now live
By Monica Sarbu
• November 2, 2022
After more than a year of hard work and addressing feedback from developers, Xata is now available!
The future of data fetching with Next.Js 13
By Alexis Rico
• October 26, 2022
Discover Next.js' new data fetching features and seamless integration with Xata in its latest release.
Securely querying your database with Xata
By Atila Fassina
• October 24, 2022
Connect to a Xata database and fetch data from client-side apps without exposing security keys.
A journey to bulletproof links in documentation
By Fabien Bernard
• September 5, 2022
Learn how we solved the issue of broken internal links in our documentation, once and for all.
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.
From OpenAPI to type safe react-query hooks
By Fabien Bernard
• April 12, 2022
Learn how we build predictable API communications with the OpenAPI codegen.
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.
Jamstack: a deep dive
By Anjalee Sudasinghe
• February 28, 2022
Explore Jamstack, its alternatives, and how Xata complements it with a serverless database.
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 © 2024 Xatabase Inc.
All rights reserved.