Blog

How to build paywall pages with Stripe, Lucia Auth and Xata

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.

Community Spotlight

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.

Xata

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

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.

Dedicated Clusters

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.

pgzx

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.

Drizzle Integration

Using Drizzle with Xata's Postgres service

By Alexis Rico

March 20, 2024

Get started with Drizzle ORM and Xata

Prisma Integration

Using Prisma with Xata's Postgres service

By Emily Morgan

March 20, 2024

Get started with Prisma ORM and Xata

Xata

Introducing usage monitoring

By Siobhán Meier, Ryan Slade

March 20, 2024

Learn about the new Usage feature available in Xata

pgroll Integration

Powering up schema migrations with pgroll

By Emily Morgan

March 19, 2024

Integrating pgroll into Xata to provide zero-downtime, reversible schema migrations.

Launch Week Easter Egg Hunt

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!

Serverless Postgres Platform

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.

International Women's day

Xata celebrates International Women's Day

By Aimee Nolan

March 8, 2024

Celebrating this years International Women's Day to inspire inclusion

Chatbot with Xata

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.

Community Spotlight

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.

Xata CMS

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.

Zero-downtime schema migrations in PostgreSQL

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.

Winners

Announcing the winners of the Holiday Hackathon

By Alex Francoeur

February 1, 2024

We're excited to announce the winners of the Holiday Hackathon

Community Spotlight

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.

Xata image gallery

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.

Tenerife offsite

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.

Xata + Cloudflare

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.

Community Spotlight

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.

Create flags with Xata, Vercel, and Astro

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

Holiday Hackathon

By Alex Francoeur

December 8, 2023

Join in on the holiday cheer by entering the Xata Holiday Hackathon!

Xata Go SDK

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.

pgroll

How pgroll works under the hood

By Andrew Farries

November 30, 2023

Learn how pgroll implements zero-downtime schema changes by exploring an example.

Quick read on horizontal sharding

What is horizontal sharding?

By J Edwards

November 23, 2023

A basic overview of horizontal sharding. What is it and what are the challenges?

Buzz saying to Woody to infinity and beyond

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.

Community Spotlight

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.

Postgres database nightmares

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

Community Spotlight

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.

Xata content winners

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

pgroll

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

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.

Extracting text from File Attachments and indexing it with Python.

Indexing File Attachments with the Python SDK

By Kostas Botsas

September 14, 2023

Extracting text from File Attachments and indexing it with Python.

Xata, Vercel and ChatGPT logos

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

JSON type header

Introducing the JSON column type

By Alejandro Martínez

September 1, 2023

Use the new JSON column type for improved data storage in Xata.

Many to one relationship

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.

Astro, Remix, SolidStart, SvelteKit, Next.js, and Nuxt logos

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 access to Xata

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

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.

Xata Python SDK

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.

Xata - LangChain

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

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

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!

Quick read on database indexing

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?

Database schema design

Designing your database schema

By J Edwards

August 4, 2023

Understanding database schema design - a quick guide with examples

Comparison of database options

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.

Postgres vs Elasticsearch for full-text search

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?

Postgres full-text search

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.

Xata, Airbyte, and Zapier integration

Connecting data sources to Xata with Airbyte and Zapier integrations

By Kostas Botsas

July 6, 2023

Effortlessly automate data ingestion with Xata integrations

Posgres schema changes

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?

Xata regions

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

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

Next era of databases

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

Performance of REPLICA IDENTITY FULL

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.

Offsite graphic

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

How we implemented database renaming

By Noémi Ványi

May 26, 2023

Starting today, you can now rename your Xata database

Xata

XataForm is here!

By Fabien Bernard

May 4, 2023

New open-source project to deal with your forms, survey and quizzes!

Need a workflow cover image

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.

Need a workflow cover image

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.

Batchoop

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.

Searching with Xata

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.

Xata go

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.

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

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.

Xata JWT and Auth.js logos

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.

Xata and Cloudflare logos

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.

Keyword versus vector search

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 and ChatGPT logos

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.

Xata and ChatGPT logos

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

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.

Rankone

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.

Data platforms

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.

Winners

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.

Data platforms

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.

Winners

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.

Winnders

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.

Winnders

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.

Data platforms

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.

Winners

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!

Next JS

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.

Xata

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.

Xata

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.

Data platforms

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.

Xata

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.

Xata

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.

Xata

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

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.

Xata

Jamstack: a deep dive

By Anjalee Sudasinghe

February 28, 2022

Explore Jamstack, its alternatives, and how Xata complements it with a serverless database.

Xata

Talking about serverless databases

By Tudor Golubenco

February 6, 2022

Proposing a definition for serverless databases and adding some clarity to the discussion.

Xata

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.

Free plan includes
  • 10 database branches
  • High availability
  • 15 GB data storage
  • 15 GB search engine storage
  • 2 GB file attachments
  • 250 AI queries per month
Start freeExplore all plans
Free plan includes
  • 10 database branches
  • High availability
  • 15 GB data storage
  • 15 GB search engine storage
  • 2 GB file attachments
  • 250 AI queries per month
Add column to table

Copyright © 2024 Xatabase Inc.
All rights reserved.

Product

RoadmapFeature requestsPricingStatusAI solutionsFile attachments