{"data":{"slug":"paradedb-paradedb","name":"paradedb","tagline":"One Postgres for 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":9278,"forks":457,"topics":["aggregations","analytics","bm25","columnar-storage","distributed-search","full-text-search","htap","hybrid-search","mpp","olap","postgresql","postgresql-extension","real-time-analytics","rust","search-engine","semantic-search","similarity-search","sparse-vector","vector-database","vector-search"],"archived":false,"github_pushed_at":"2026-09-18T06:55:47+00:00","maintenance_label":"Very active","stars_delta_30d":161,"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":213,"watchers":47,"ai_summary":"ParadeDB is a PostgreSQL extension that supports full-text search, vector retrieval, and aggregations, offering a comprehensive solution for hybrid search and analytics.","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://www.paradedb.com/docs/operate/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://www.paradedb.com/docs/operate/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-09-20T04:31:22.49681+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":"columnar-storage","name":"columnar-storage"},{"slug":"distributed-search","name":"distributed-search"},{"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-09-18T08:31:05.169Z","maintenance":{"label":"Very active","score":96,"methodology":"github_public_v1","releases_90d":15,"days_since_push":0,"last_release_at":"2026-09-11T21:57:22Z","stars_delta_30d":161,"open_issues_delta_30d":8},"security_summary":{"status":"no_lockfile","scanner":null,"low_count":0,"high_count":0,"last_scan_at":"2026-09-18T08:31:06.878Z","medium_count":0,"scan_profile":"none","critical_count":0}},"capability_facts":{"scan":{"source":"repo_scan","observed_at":"2026-09-18T08:31:04.078Z"},"languages":{"value":["rust"],"source":"github.language","observed_at":"2026-09-18T08:31:04.078Z"},"license_spdx":{"value":"AGPL-3.0","source":"github.license","observed_at":"2026-09-18T08:31:04.078Z"}},"decision_facts":{"hosting":null,"pricing":{"model":"freemium","summary":"ParadeDB Community is free and open-source under the AGPL-3.0 license. ParadeDB Enterprise offers commercial licensing for additional features and support."},"requirements":{"notes":["Installation can be done locally in a fresh Docker container.","For deployment, check out the hosting options provided by ParadeDB."],"min_ram_gb":2,"requires_docker":true},"constraints":{"min_ram_gb":2,"pricing_model":"freemium","requires_docker":true},"when_to_use":["When you need a PostgreSQL extension that supports full-text search, vector retrieval, and aggregations in a single database.","If your application requires real-time analytics and hybrid search capabilities, combining both full-text and vector search.","For projects that benefit from the BM25 ranking algorithm for full-text search, offering more relevant search results.","When you are working with sparse vectors and need efficient storage and retrieval capabilities."],"when_not_to_use":["If your project strictly requires a standalone vector database without the need for full-text search or aggregations.","When you prefer a solution that does not come with the GNU Affero General Public License v3.0, as this might not align with your licensing requirements.","If your application does not require real-time analytics or hybrid search capabilities, and you are looking for a simpler solution.","For scenarios where you need a distributed search solution that operates independently of PostgreSQL."],"source":"enrich:decision_facts","observed_at":"2026-09-18T10:19:26.388Z"},"constraint_facets":{"min_ram_gb":2,"pricing_model":"freemium","requires_docker":true},"decision_summary":[{"label":"Pricing","value":"freemium - ParadeDB Community is free and open-source under the AGPL-3.0 license. ParadeDB Enterprise offers commercial licensing for additional features and support."},{"label":"Requirements","value":"Min 2 GB RAM; Requires Docker; Installation can be done locally in a fresh Docker container.; For deployment, check out the hosting options provided by ParadeDB."},{"label":"Adopt for","value":"ParadeDB is a PostgreSQL extension written in Rust, designed for full-text search, vector retrieval, and aggregations, making it a comprehensive solution for hybrid search and analytics."},{"label":"License detail","value":"ParadeDB Community is licensed under the GNU Affero General Public License v3.0, while ParadeDB Enterprise offers commercial licensing options."}]}}