# ParadeDB

ParadeDB is an Elasticsearch alternative built on Postgres. It is open source and self-hosted, installable on Docker Hub, Kubernetes (Helm) and Unraid.

Canonical page: https://ourlocalhost.com/app/144/paradedb

## Description

ParadeDB is an Elasticsearch alternative built on Postgres. We’re modernizing the features of Elasticsearch, starting with real-time search and analytics.

## Platform availability

Available on 2 of 9 platforms: Unraid, Helm.

## Health score

67/100 (Good), based on 3 of 4 factors.
- Maintained: 100 (last commit 18 days ago)
- Popular: 31 (36 GitHub stars)
- Easy to install: 45 (2 install platforms, install notes, Docker image)

## Links

- GitHub: https://github.com/paradedb/paradedb
- Docker Hub: https://hub.docker.com/r/paradedb/paradedb
- Documentation: https://www.paradedb.com/docs/start/install
- Kubernetes (Helm): https://artifacthub.io/packages/helm/paradedb/paradedb
- Unraid: https://ca.unraid.net/apps/paradedb-0xwsu4c06su62o?q=ParadeDB
- Official website: https://paradedb.com

## Common questions

### How do I start a local ParadeDB instance and reconnect to it later?

Use the one-line Docker installer, which starts ParadeDB in Docker with persistent storage and prints your connection credentials. To reconnect, run docker exec -it paradedb psql -U postgres -d paradedb.

### Which port and volume does the Docker quickstart use?

The example maps host port 5432 to container port 5432 and mounts the named volume paradedb_data to /var/lib/postgresql/.

### What must I change when installing pg_search on Postgres.app?

Install the pg_search extension, then add pg_search to shared_preload_libraries in postgresql.conf while keeping any existing libraries.

### Which extension package should I choose when installing pg_search directly?

Choose the package that matches your operating system and architecture, such as amd64, arm64, x86_64, or aarch64. A wrong package can fail to install or not load in PostgreSQL.

### Can ParadeDB self-hosted indexes survive failover in a highly available Postgres cluster?

In a highly available Postgres cluster, ParadeDB indexes replicate to standby instances alongside your data and remain available after failover. High availability for ParadeDB indexes requires ParadeDB Enterprise, so contact sales to self-host it.

### Why might a tutorial example fail after installing ParadeDB?

Use the versioned install script that matches the tutorial, such as the 0.25.3-pg18 example. ParadeDB syntax and commands have changed, so an old version can make examples fail.

## Alternatives

- Algolia: Algolia helps product teams connect their users with information by providing the building blocks they need to create fast, relevant, perso…
- Elasticsearch: Elasticsearch is a distributed search and analytics engine that indexes and queries full-text, log, metric, and vector data in near real ti…
- Golem: Golem is a global, open sourced, decentralized supercomputer that anyone can access.
- OpenSearch: OpenSearch is an open-source search and observability suite for self-hosters who need scalable indexing, analysis, and visualization of log…

---
Source: Our Local Host (https://ourlocalhost.com/app/144/paradedb), the self-hosted and open-source app directory.