base on Postgres for Search and Analytics <h1 align="center"> <a href="https://paradedb.com"><img src="docs/logo/readme.svg" alt="ParadeDB"></a> <br> </h1> <p align="center"> <b>Postgres for Search and Analytics</b> <br /> </p> <h3 align="center"> <a href="https://paradedb.com">Website</a> &bull; <a href="https://docs.paradedb.com">Docs</a> &bull; <a href="https://join.slack.com/t/paradedbcommunity/shared_invite/zt-2lkzdsetw-OiIgbyFeiibd1DG~6wFgTQ">Community</a> &bull; <a href="https://paradedb.com/blog/">Blog</a> &bull; <a href="https://docs.paradedb.com/changelog/">Changelog</a> </h3> --- [](https://artifacthub.io/packages/search?repo=paradedb) [](https://hub.docker.com/r/paradedb/paradedb) [](https://github.com/paradedb/paradedb?tab=AGPL-3.0-1-ov-file#readme) [](https://join.slack.com/t/paradedbcommunity/shared_invite/zt-2lkzdsetw-OiIgbyFeiibd1DG~6wFgTQ) [](https://x.com/paradedb) [ParadeDB](https://paradedb.com) is an Elasticsearch alternative built on Postgres. We're modernizing the features of Elasticsearch's product suite, starting with real-time search and analytics. ## Roadmap - [x] Search - [x] Full-text search with BM25 with [pg_search](https://github.com/paradedb/paradedb/tree/dev/pg_search#overview) - [x] Dense and sparse vector search with [pgvector](https://github.com/pgvector/pgvector#pgvector) - [ ] Distributed search - [ ] Analytics - [x] Fast analytics over data lakes (i.e. S3) and table formats (i.e. Iceberg) with [pg_analytics](https://github.com/paradedb/pg_analytics) - [ ] Column-oriented Postgres table access method For a detailed roadmap, see the [ParadeDB Roadmap for 2024 - 2025](https://github.com/orgs/paradedb/discussions/1668). ## Get Started To get started, please visit our [documentation](https://docs.paradedb.com). ## Deploying ParadeDB ParadeDB and its extensions can be deployed in one of two ways: - Docker image based on [Postgres](https://hub.docker.com/_/postgres) ([see deployment instructions](https://docs.paradedb.com/deploy/aws)) - Kubernetes Helm chart based on [CloudNativePG](https://artifacthub.io/packages/helm/cloudnative-pg/cloudnative-pg) ([see deployment instructions](https://docs.paradedb.com/deploy/helm)) For more information, including enterprise features and support, please [contact us by email](mailto:[email protected]). ### Extensions You can find prebuilt binaries for the ParadeDB Postgres extensions on Debian 12, Ubuntu 22.04 and 24.04, Red Hat Enterprise Linux 8 and 9, and macOS 14 (Sonoma) and 15 (Sequoia) for Postgres 14, 15, 16 and 17 in the [GitHub Releases](https://github.com/paradedb/paradedb/releases/latest). ParadeDB supports all versions supported by the PostgreSQL Global Development Group, which includes PostgreSQL 13+, and you can compile the extensions for other versions of Postgres by following the instructions in the respective extension's README. ### Docker Image To quickly get a ParadeDB instance up and running, simply pull and run the latest Docker image: ```bash docker run --name paradedb -e POSTGRES_PASSWORD=password paradedb/paradedb ``` This will start a ParadeDB instance with default user `postgres` and password `password`. You can then connect to the database using `psql`: ```bash docker exec -it paradedb psql -U postgres ``` To install ParadeDB locally or on-premise, we recommend using our `docker-compose.yml` file. Alternatively, you can pass the appropriate environment variables to the `docker run` command, replacing the <> with your desired values: ```bash docker run \ --name paradedb \ -e POSTGRES_USER=<user> \ -e POSTGRES_PASSWORD=<password> \ -e POSTGRES_DB=<dbname> \ -v paradedb_data:/var/lib/postgresql/data/ \ -p 5432:5432 \ -d \ paradedb/paradedb:latest ``` This will start a ParadeDB instance with non-root user `<user>` and password `<password>`. The `-v` flag enables your ParadeDB data to persist across restarts in a Docker volume named `paradedb_data`. You can then connect to the database using `psql`: ```bash docker exec -it paradedb psql -U <user> -d <dbname> -p 5432 -W ``` ParadeDB collects anonymous telemetry to help us understand how many people are using the project. You can opt out of telemetry using configuration variables within Postgres: ```sql ALTER SYSTEM SET paradedb.pg_search_telemetry TO 'off'; ``` ### Helm Chart ParadeDB is also available for Kubernetes via our Helm chart. You can find our Helm chart in the [ParadeDB Helm Chart GitHub repository](https://github.com/paradedb/charts) or download it directly from [Artifact Hub](https://artifacthub.io/packages/helm/paradedb/paradedb). ### ParadeDB Cloud At the moment, ParadeDB is not available as a managed cloud service. If you are interested in a ParadeDB Cloud service, please let us know by joining our [waitlist](https://form.typeform.com/to/jHkLmIzx). ## Support If you're missing a feature or have found a bug, please open a [GitHub Issue](https://github.com/paradedb/paradedb/issues/new/choose). To get community support, you can: - Post a question in the [ParadeDB Slack Community](https://join.slack.com/t/paradedbcommunity/shared_invite/zt-2lkzdsetw-OiIgbyFeiibd1DG~6wFgTQ) - Ask for help on our [GitHub Discussions](https://github.com/paradedb/paradedb/discussions) If you need commercial support, please [contact the ParadeDB team](mailto:[email protected]). ## Contributing We welcome community contributions, big or small, and are here to guide you along the way. To get started contributing, check our [first timer issues](https://github.com/paradedb/paradedb/labels/good%20first%20issue) or message us in the [ParadeDB Community Slack](https://join.slack.com/t/paradedbcommunity/shared_invite/zt-2lkzdsetw-OiIgbyFeiibd1DG~6wFgTQ). Once you contribute, ping us in Slack and we'll send you some ParadeDB swag! For more information on how to contribute, please see our [Contributing Guide](/CONTRIBUTING.md). This project is released with a [Contributor Code of Conduct](/CODE_OF_CONDUCT.md). By participating in this project, you agree to follow its terms. Thank you for helping us make ParadeDB better for everyone :heart:. ## License ParadeDB is licensed under the [GNU Affero General Public License v3.0](LICENSE) and as commercial software. For commercial licensing, please contact us at [[email protected]](mailto:[email protected]). ", Assign "at most 3 tags" to the expected json: {"id":"3365","tags":[]} "only from the tags list I provide: [{"id":77,"name":"3d"},{"id":89,"name":"agent"},{"id":17,"name":"ai"},{"id":54,"name":"algorithm"},{"id":24,"name":"api"},{"id":44,"name":"authentication"},{"id":3,"name":"aws"},{"id":27,"name":"backend"},{"id":60,"name":"benchmark"},{"id":72,"name":"best-practices"},{"id":39,"name":"bitcoin"},{"id":37,"name":"blockchain"},{"id":1,"name":"blog"},{"id":45,"name":"bundler"},{"id":58,"name":"cache"},{"id":21,"name":"chat"},{"id":49,"name":"cicd"},{"id":4,"name":"cli"},{"id":64,"name":"cloud-native"},{"id":48,"name":"cms"},{"id":61,"name":"compiler"},{"id":68,"name":"containerization"},{"id":92,"name":"crm"},{"id":34,"name":"data"},{"id":47,"name":"database"},{"id":8,"name":"declarative-gui "},{"id":9,"name":"deploy-tool"},{"id":53,"name":"desktop-app"},{"id":6,"name":"dev-exp-lib"},{"id":59,"name":"dev-tool"},{"id":13,"name":"ecommerce"},{"id":26,"name":"editor"},{"id":66,"name":"emulator"},{"id":62,"name":"filesystem"},{"id":80,"name":"finance"},{"id":15,"name":"firmware"},{"id":73,"name":"for-fun"},{"id":2,"name":"framework"},{"id":11,"name":"frontend"},{"id":22,"name":"game"},{"id":81,"name":"game-engine "},{"id":23,"name":"graphql"},{"id":84,"name":"gui"},{"id":91,"name":"http"},{"id":5,"name":"http-client"},{"id":51,"name":"iac"},{"id":30,"name":"ide"},{"id":78,"name":"iot"},{"id":40,"name":"json"},{"id":83,"name":"julian"},{"id":38,"name":"k8s"},{"id":31,"name":"language"},{"id":10,"name":"learning-resource"},{"id":33,"name":"lib"},{"id":41,"name":"linter"},{"id":28,"name":"lms"},{"id":16,"name":"logging"},{"id":76,"name":"low-code"},{"id":90,"name":"message-queue"},{"id":42,"name":"mobile-app"},{"id":18,"name":"monitoring"},{"id":36,"name":"networking"},{"id":7,"name":"node-version"},{"id":55,"name":"nosql"},{"id":57,"name":"observability"},{"id":46,"name":"orm"},{"id":52,"name":"os"},{"id":14,"name":"parser"},{"id":74,"name":"react"},{"id":82,"name":"real-time"},{"id":56,"name":"robot"},{"id":65,"name":"runtime"},{"id":32,"name":"sdk"},{"id":71,"name":"search"},{"id":63,"name":"secrets"},{"id":25,"name":"security"},{"id":85,"name":"server"},{"id":86,"name":"serverless"},{"id":70,"name":"storage"},{"id":75,"name":"system-design"},{"id":79,"name":"terminal"},{"id":29,"name":"testing"},{"id":12,"name":"ui"},{"id":50,"name":"ux"},{"id":88,"name":"video"},{"id":20,"name":"web-app"},{"id":35,"name":"web-server"},{"id":43,"name":"webassembly"},{"id":69,"name":"workflow"},{"id":87,"name":"yaml"}]" returns me the "expected json"