Xata Blog

Creating a search engine with PostgreSQL

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.

Pgroll: zero-downtime, reversible schema migrations for Postgres

We are excited to ship the first version of pgroll, a command line tool that offers safe and reversible schema migrations for PostgreSQL

Postgres Webhooks with Pgstream

Trigger HTTP webhooks on every INSERT, UPDATE, or DELETE in PostgreSQL. Open-source CDC setup with pgstream, no polling required.

Speeding up PostgreSQL dump/restore snapshots

How targeted improvements helped us speed up bulk data loads and complex schemas.

Introducing pgzx: create PostgreSQL extensions using Zig

We are excited to introduce pgzx, a framework for creating Postgres extensions using the Zig programming language.

File Attachments: Databases can now store files and images

How to Distribute Postgres Geographically

Documenting a pattern for making multi-tenant applications global by distributing the data, using only standard PostgreSQL functionality.

The economics of a Postgres free tier

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.

Full-text search engine with PostgreSQL (part 2): Postgres vs. Elasticsearch

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?