ParadeDB is a PostgreSQL extension that brings advanced search and analytical capabilities to Postgres.
It is aimed at teams that want to build search-driven applications without maintaining a separate search engine, letting them keep search workloads close to their relational data and existing PostgreSQL infrastructure.
This is free and open source software.
Key Features
- Provides full-text search features including BM25 scoring, Top K retrieval, highlighting, tokenizers, and token filters.
- Supports filtering, bucket and metric aggregations, facets, and columnar storage for analytical workloads.
- Includes JOIN support so search results can be combined with relational queries inside PostgreSQL.
- Can be deployed as a self-hosted PostgreSQL extension or used as a logical replica of managed PostgreSQL services.
- Integrates with tools and platforms including Django, SQLAlchemy, Rails, Railway, Render, and DigitalOcean.
Website: github.com/paradedb/paradedb
Support:
Developer: ParadeDB
License: GNU Affero General Public License v3.0
ParadeDB is written in Rust. Learn Rust with our recommended free books and free tutorials.
Related Software
| Search Engines for Big Data | |
|---|---|
| ElasticSearch | Flexible and powerful distributed RESTful search engine and analytics |
| Solr | Search engine server that uses Lucene |
| Lucene | Search engine library |
| MeiliSearch | Easy to use and deploy search engine |
| OpenSearch | Enterprise-grade search and observability suite |
| Sphinx | Search engine designed with indexing database content in mind |
| Xapian | Probabilistic information retrieval library |
| Typesense | Fast, typo-tolerant search engine |
| Manticore Search | Easy to use fast database for search |
| Vespa | AI search platform |
| Groonga | Fulltext search engine and column store |
Read our verdict in the software roundup.
Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |

