[GH-ISSUE #75] one to N relations example #62

New issue

Closed

opened 2026-03-31 22:01:54 -06:00 by gitea-mirror · 1 comment

gitea-mirror commented

2026-03-31 22:01:54 -06:00

Owner

Originally created by @horacimacias on GitHub (Apr 12, 2021).
Original GitHub issue: https://github.com/jo/couchdb-best-practices/issues/75

first of all thanks for these notes; there are very helpful.

Regarding the "one to N relations" example, I suggest making a minor update or adding some description of possible side effects.

In the example provided, where artist is "embedded" in the albums ids, between ":" separators, I'd suggest using this:

{
  "include_docs": true,
  "startkey": "artist:tom-waits:",
  "endkey": "artist:tom-waits:\ufff0"
}

instead of this (note there is no ":" after the value on startkey)

{
  "include_docs": true,
  "startkey": "artist:tom-waits",
  "endkey": "artist:tom-waits:\ufff0"
}

The current example would return albums for any artist whose name includes tom-waits; e.g. tom-waitson which is probably not what's intended.
It may not be an extremely common scenario but since the artist is already put between ":" separators in the albums' ids, it may be a good idea to restrict startkey by that separator as well?

Originally created by @horacimacias on GitHub (Apr 12, 2021). Original GitHub issue: https://github.com/jo/couchdb-best-practices/issues/75 first of all thanks for these notes; there are very helpful. Regarding the "one to N relations" example, I suggest making a minor update or adding some description of possible side effects. In the example provided, where `artist` is "embedded" in the `albums` ids, between ":" separators, I'd suggest using this: ```json { "include_docs": true, "startkey": "artist:tom-waits:", "endkey": "artist:tom-waits:\ufff0" } ``` instead of this (note there is no ":" after the value on `startkey`) ```json { "include_docs": true, "startkey": "artist:tom-waits", "endkey": "artist:tom-waits:\ufff0" } ``` The current example would return albums for any artist whose name includes `tom-waits`; e.g. `tom-waitson` which is probably not what's intended. It may not be an extremely common scenario but since the artist is already put between ":" separators in the albums' ids, it may be a good idea to restrict `startkey` by that separator as well?

gitea-mirror closed this issue

2026-03-31 22:01:55 -06:00

gitea-mirror commented

2026-03-31 22:01:56 -06:00

Author

Owner

@jo commented on GitHub (Apr 3, 2022):

fixed with 9a462524e0

Thank you, @horacimacias

@jo commented on GitHub (Apr 3, 2022): fixed with https://github.com/jo/couchdb-best-practices/commit/9a462524e05143c4803ecf6dad73e1c3a68316cb Thank you, @horacimacias

Rows
Columns