# ParadeDB

> ParadeDB is a transactional alternative to Elasticsearch built on Postgres. It is a PostgreSQL-native search and analytics engine - a columnstore index for OLAP and a BM25 inverted index for full-text search, all inside Postgres as an extension. ParadeDB makes Postgres fast for both analytics and search without ETL or external systems.

## Website

- [Homepage](https://www.paradedb.com)
- [Blog](https://www.paradedb.com/blog)
- [Learn](https://www.paradedb.com/learn)
- [Sitemap](https://www.paradedb.com/sitemap.xml)
- [RSS Feed](https://www.paradedb.com/feed.xml)

## Blog

- [How We Optimized Top K in Postgres](https://www.paradedb.com/blog/optimizing-top-k)
- [Retrieve and Rerank: Personalized Search Without Leaving Postgres](https://www.paradedb.com/blog/personalized-search-in-postgresql)
- [Hybrid Search in PostgreSQL: The Missing Manual](https://www.paradedb.com/blog/hybrid-search-in-postgresql-the-missing-manual)
- [From Text to Token: How Tokenization Pipelines Work](https://www.paradedb.com/blog/when-tokenization-becomes-token)
- [Postgres as a Search Engine: The Write Performance Problem](https://www.paradedb.com/blog/increased-write-performance)
- [Teaching Postgres to Facet Like Elasticsearch](https://www.paradedb.com/blog/faceting)
- [Deep Dive into ParadeDB's v2 API: The Future of SQL Search](https://www.paradedb.com/blog/v2api)
- [ParadeDB 0.20.0: Simpler and Faster](https://www.paradedb.com/blog/paradedb-0-20-0)
- [The ACID Test: Why We Think Search Needs Transactions](https://www.paradedb.com/blog/elasticsearch-acid-test)
- [Elasticsearch Was Never a Database](https://www.paradedb.com/blog/elasticsearch-was-never-a-database)
- [Syncing with Postgres: Logical Replication vs. ETL](https://www.paradedb.com/blog/etl-vs-logical-replication)
- [Announcing Our $12M Series A](https://www.paradedb.com/blog/series-a-announcement)
- [We Made Postgres Writes Faster, but it Broke Replication](https://www.paradedb.com/blog/lsm-trees-in-postgres)
- [A New Postgres Block Storage Layout for Full Text Search](https://www.paradedb.com/blog/block-storage-part-one)
- [Similarity Search with SPLADE Inside Postgres](https://www.paradedb.com/blog/introducing-sparse)
- [We've Rebranded](https://www.paradedb.com/blog/rebrand)
- [Why We Picked AGPL](https://www.paradedb.com/blog/agpl)
- [Full Text Search over Postgres: Elasticsearch vs. Alternatives](https://www.paradedb.com/blog/elasticsearch-vs-postgres)
- [pg_search: Elastic-Quality Full Text Search Inside Postgres](https://www.paradedb.com/blog/introducing-search)
- [Introducing ParadeDB](https://www.paradedb.com/blog/introducing-paradedb)

## Customers

- [Alibaba Picks ParadeDB to Bring Full Text Search to its Postgres-Based Data Warehouse](https://www.paradedb.com/customers/case-study-alibaba)
- [Bilt Reduces Postgres Query Timeouts by 95% with ParadeDB](https://www.paradedb.com/customers/case-study-bilt)
- [INSA Strasbourg Powers New Research Database with ParadeDB](https://www.paradedb.com/customers/case-study-insa)
- [Sweetspot Unifies Hybrid Search on Postgres with ParadeDB](https://www.paradedb.com/customers/case-study-sweetspot)

## Learn

- [Lexical vs Semantic Search](https://www.paradedb.com/learn/search-concepts/lexical-vs-semantic)
- [What is Full-Text Search?](https://www.paradedb.com/learn/search-concepts/full-text-search)
- [What is BM25?](https://www.paradedb.com/learn/search-concepts/bm25)
- [What is Reciprocal Rank Fusion?](https://www.paradedb.com/learn/search-concepts/reciprocal-rank-fusion)
- [What is RAG?](https://www.paradedb.com/learn/search-concepts/retrieval-augmented-generation)
- [What is Vector Search?](https://www.paradedb.com/learn/search-concepts/vector-search)
- [What is Hybrid Search?](https://www.paradedb.com/learn/search-concepts/hybrid-search)
- [What is Faceted Search?](https://www.paradedb.com/learn/search-concepts/faceting)
- [Full-Text Search in PostgreSQL](https://www.paradedb.com/learn/search-in-postgresql/full-text-search)
- [Implementing BM25 in PostgreSQL](https://www.paradedb.com/learn/search-in-postgresql/bm25)
- [Introduction to Tantivy](https://www.paradedb.com/learn/tantivy/introduction)