Skip to content

Docs: what relation types will work well with my database? #2341

Description

@bajtos

Create a new section (or even a new page) in our docs for relations and explain users what relation type to choose depending on which database they use.·

We should verify that our recommended solution is actually a good one that works well for the target database. This will most likely require research on our side, as we don't have deep knowledge of different NoSQL databases. Such research is out of scope of this story, there will be follow-up spike stories. While creating the first version of the guide, we should simply label the entries that we are not confident about.

An example for illustration:

SQL databases

Relation type LoopBack flavor
1-N HasMany
N-1 BelongsTo
1-1 HasOne

MongoDB

Relation type LoopBack flavor
1-N EmbedsMany
N-1 n/a
1-1 EmbedsOne

The suggestions above are an initial proposal. See the spike story #2342 for discussion about which LoopBack relations work best for MongoDB.

Cloudant & CouchDB

Relation type LoopBack flavor
1-N ReferencesMany
N-1 n/a
1-1 ReferencesOne

The suggestions above are an initial proposal. See the spike story #2343 for discussion about which LoopBack relations work best for MongoDB.

(etc. for other databases that have an LoopBack official connector)

See the discussion in #2127 to better understand the wider context and also #2340 for related work.

Acceptance criteria

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions