> ## Documentation Index
> Fetch the complete documentation index at: https://www.paradedb.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Roadmap

> The main features that we are currently working on

We're a lean team that likes to ship at [incredibly high velocity](https://github.com/paradedb/paradedb/releases).

## In Progress

### JOIN Improvements

* **Join pushdown (beta)**. [Join pushdown](/docs/documentation/joins/overview) pushes search predicates directly into the index for significantly better performance.
* **Scoring and highlighting across JOINs**. BM25 score and snippet functions can be used in `JOIN` queries.
* **Smarter JOIN planning for search indexes**. Apply index-aware optimizations and cost estimation strategies when multiple ParadeDB-indexed tables are joined.

### Ecosystem Integrations

* **ORMs**. Official support for more ORMs, like Prisma and others, is coming. [Drizzle](https://github.com/paradedb/drizzle-paradedb), [Django](https://github.com/paradedb/django-paradedb), [SQLAlchemy](https://github.com/paradedb/sqlalchemy-paradedb), [Rails](https://github.com/paradedb/rails-paradedb), and [Entity Framework Core](https://github.com/paradedb/efcore-paradedb) are already available.
* **AI Frameworks**. Official support for LangChain, LlamaIndex, CrewAI, and others is coming.
* **PaaS Providers**. Official tutorials for hosting ParadeDB on more platform-as-a-service providers like Porter.run and others are coming. [Railway](/docs/deploy/cloud-platforms/railway), [Render](/docs/deploy/cloud-platforms/render), and [DigitalOcean](/docs/deploy/cloud-platforms/digitalocean) are already available.

## Long Term

### Deeper Analytics Improvements

* **Push Postgres visibility rules into the index**. This is currently a filter applied post index scan that adds overhead to large scans.

### Managed Cloud

* Today, you can [deploy ParadeDB](/docs/deploy/overview) self-hosted, on cloud platforms, or with ParadeDB BYOC. We're also building ParadeDB Cloud, a fully managed ParadeDB: first-class search from Postgres, with a developer experience to match. [Join the waitlist](https://www.paradedb.com/cloud) to get notified when it launches.

## Completed

### Vector Search

* **[Native vector search](/docs/documentation/vector/overview) (beta)**. The ParadeDB index natively indexes pgvector's `vector` type, addressing pgvector's limitations around filtered queries — specifically, queries that combine vector similarity with metadata filters or full-text search predicates.

### Analytics

* **A custom scan node for aggregates**. Plain SQL aggregates like `COUNT`, and clauses like `GROUP BY`, go through the same fast execution path as our aggregate UDFs.
* **Aggregate pushdown across joins**. Aggregates over multi-table joins are pushed down into the index when every joined table has a ParadeDB index.
* **Parallel execution for joins and aggregates**. Utilizes an MPP strategy that partitions joins and aggregates into multiple shared-nothing stages executed by parallel workers.

### Write Throughput

* **Background merging**. Improves write performance by merging index segments asynchronously without blocking inserts.
* **Pending list**. Buffers recent write before flushing them to the LSM tree.

### Improved UX

* **More intuitive index configuration**. Overhaul the complicated JSON `WITH` index options.
* **More ORM friendly**. Overhaul the [query builder functions](/docs/documentation/query-builder/overview) to use actual column references instead of string literals.
* **New operators**. In addition to the existing `@@@` operator, introduce new operators for different query types (e.g. phrase, term, conjunction/disjunction).

## We're Hiring

We're tackling some of the hardest and (in our opinion) most impactful problems in Postgres. If you want to be a part of it,
please check out our [open roles](https://paradedb.notion.site)!