{"data":{"slug":"paradedb-paradedb","name":"paradedb","tagline":"One Postgres for your application data, full-text search, vector retrieval, and aggregations.","github_url":"https://github.com/paradedb/paradedb","owner":"paradedb","repo":"paradedb","owner_avatar_url":"https://avatars.githubusercontent.com/u/124464601?v=4","primary_language":"Rust","stars":9117,"forks":424,"topics":["aggregations","analytics","bm25","database","elasticsearch","full-text-search","htap","hybrid-search","olap","postgresql","real-time-analytics","similarity-search","sparse-vector","sql"],"archived":false,"github_pushed_at":"2026-08-02T17:50:56+00:00","maintenance_label":"Very active","url":"https://www.graphcanon.com/tools/paradedb-paradedb","markdown_url":"https://www.graphcanon.com/tools/paradedb-paradedb.md","api_url":"https://www.graphcanon.com/api/graphcanon/tools/paradedb-paradedb","graph_url":"https://www.graphcanon.com/api/graphcanon/graph?tool=paradedb-paradedb","description":"One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.","homepage_url":"https://paradedb.com","license":"AGPL-3.0","open_issues":205,"watchers":43,"ai_summary":"ParadeDB is an extension to PostgreSQL that integrates capabilities for full-text search, vector retrieval, and various aggregation functions through the pg_search extension. It supports real-time analytics and hybrid transactional and analytical processing (HTAP).","readme_excerpt":"## Installation\n\nTo install ParadeDB locally in a fresh Docker container and drop straight into a `psql` session:\n\n```bash\ncurl -fsSL https://paradedb.com/install.sh | sh\n```\n\nWhen you're ready to deploy, check out our [hosting options](https://docs.paradedb.com/deploy/overview).\n\n---\n\n## License\n\nParadeDB Community is licensed under the [GNU Affero General Public License v3.0](LICENSE). For [ParadeDB Enterprise](https://docs.paradedb.com/deploy/enterprise) licensing, contact [sales@paradedb.com](mailto:sales@paradedb.com).","github_created_at":"2023-06-30T20:21:47+00:00","created_at":"2026-07-11T23:19:20.257718+00:00","updated_at":"2026-08-02T18:01:07.589054+00:00","categories":[{"slug":"data-retrieval","name":"Data & Retrieval","url":"https://www.graphcanon.com/categories/data-retrieval","markdown_url":"https://www.graphcanon.com/categories/data-retrieval.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/data-retrieval"},{"slug":"vector-databases","name":"Vector Databases","url":"https://www.graphcanon.com/categories/vector-databases","markdown_url":"https://www.graphcanon.com/categories/vector-databases.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/vector-databases"}],"tags":[{"slug":"aggregations","name":"aggregations"},{"slug":"analytics","name":"analytics"},{"slug":"bm25","name":"bm25"},{"slug":"database","name":"database"},{"slug":"elasticsearch","name":"elasticsearch"},{"slug":"full-text-search","name":"full-text-search"},{"slug":"htap","name":"htap"},{"slug":"hybrid-search","name":"hybrid-search"}],"trust":{"provenance":{"is_fork":false,"github_id":660776503,"owner_type":"Organization","methodology":"github_public_v1","parent_repo":null,"near_duplicate_slugs":[]},"computed_at":"2026-08-02T18:01:06.598Z","maintenance":{"label":"Very active","score":96,"methodology":"github_public_v1","releases_90d":8,"days_since_push":0,"last_release_at":"2026-07-28T21:46:40Z"},"security_summary":{"status":"no_lockfile","scanner":null,"low_count":0,"high_count":0,"last_scan_at":"2026-07-11T23:19:27.437Z","medium_count":0,"scan_profile":"none","critical_count":0}},"capability_facts":{"scan":{"source":"repo_scan","observed_at":"2026-08-02T18:01:07.262Z"},"languages":{"value":["rust"],"source":"github.language","observed_at":"2026-08-02T18:01:07.262Z"},"license_spdx":{"value":"AGPL-3.0","source":"github.license","observed_at":"2026-08-02T18:01:07.262Z"}},"decision_facts":{"hosting":null,"pricing":{"model":"freemium","summary":"ParadeDB Community is available under AGPL-3.0 for free, but commercial use may require contacting sales for enterprise licensing options."},"requirements":{"min_ram_gb":null,"requires_docker":true},"constraints":{"min_ram_gb":null,"pricing_model":"freemium","requires_docker":true},"when_to_use":["Use ParadeDB when you need a unified database solution that supports both transactional operations and analytical processing within the same environment (HTAP).","If your application requires real-time analytics alongside traditional SQL operations, ParadeDB can be an ideal choice due to its support for full-text search and vector retrieval.","Leverage ParadeDB when you want to extend PostgreSQL with advanced querying capabilities without leaving the familiar SQL framework."],"when_not_to_use":["Avoid using ParadeDB if your project strictly adheres to permissive licensing, as it is under AGPL-3.0 which imposes copyleft obligations.","Do not opt for ParadeDB when you specifically require a standalone full-text search solution like Elasticsearch that offers more specialized features out-of-the-box.","It may not be the best choice if your use case demands real-time processing of extremely high-speed data streams beyond its HTAP capabilities."],"source":"enrich:decision_facts","observed_at":"2026-07-12T11:54:29.925Z"},"constraint_facets":{"min_ram_gb":null,"pricing_model":"freemium","requires_docker":true},"decision_summary":[{"label":"Pricing","value":"freemium - ParadeDB Community is available under AGPL-3.0 for free, but commercial use may require contacting sales for enterprise licensing options."},{"label":"Requirements","value":"Requires Docker"},{"label":"Adopt for","value":"ParadeDB is an extension to PostgreSQL designed for integrating full-text search, vector retrieval, and aggregation functionalities."}]}}