apache / apache/couchdb

Support JOINs in Mango

Open
#1,510 4 comments 4 reactions 0 assignees View on GitHub
api feature mango roadmap
Dominant language
Erlang
Stars
7k
Forks
1.1k
Avg merge
1d 16h
Merged PRs (30d)
9

Description

@davisp:
> JOINs make me squeamish.

@janl:
> I hear ya, but devs love em :) — And a native API would simplify a lot of app and library code.
>
> I’d definitely say it shouldn’t be full SQL JOIN semantics, but a simple LEFT JOIN on a key over two views should be fine and address a good bunch of use-cases. Basically, anything that isn’t conceptually different from merging multiple shard-view results on the top node, just with two views.

@nolanlawson:
> Relevant pouchdb-find discussion: https://github.com/nolanlawson/pouchdb-find/issues/157

Contributor guide

Open the contributing guide

Research direction

Start by reading the Mango implementation and the linked pouchdb-find discussion to understand the proposed JOIN scope and existing constraints. This issue is ready only once the JOIN behavior and API are defined, implemented, and covered by appropriate tests; the payload names no specific files or test entry points.

Written by the indexing model from the issue text.

Assessment

Tech stack
erlang
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.