Live app - Double relationship

[hacker]

Hey,

I don’t know if having double relationship between 2 Data Types have advantages?

Let me explain:
I have 2 Data Types with some fields

1. Album
   a. name (type text)
   b. songs (list of Songs)

2. Song
   a. name (type text)
   b. file (type file)
   c. album (type Album)

Is there any benefit that Album has the field songs?

Thanks in advance

[hacker]

Thanks, @cmarchan,

Lists of things questions

Hi @hacker Think of a data type entry as an entity. If it is deleted from the dB it is deleted everywhere. It is gone. So … if this entity was deleted from the dB and was part of a list of another different entity … it is gone now. Double relationship. Lots of stuff to talk about here. One simple comment on the situation you present is that the song being related to the album makes the list of songs of the album pretty much irrelevant. Unless … there is a purpose for that list of songs other t…

One simple comment on the situation you present is that the song being related to the album makes the list of songs of the album pretty much irrelevant. Unless … there is a purpose for that list of songs other than just being part of the album.

Yes, I really think that having the Album as a field on the Song is the only relation that I need.

Except for only one Data Type that I have to have a list of things because of the Privacy Rules don’t letting me have a "This Thing's X's Y" can't grant search access right now

Thanks again

[hacker]

Anyone?

[adamhholmes]

@hacker

Is there any benefit that Album has the field songs?

Yes there are…

For one it will be easier to work with data (and probably faster to load compared to doing a search for songs).

For another, there may be certain privacy rules you might want to use which (as you’ve already seen) will only be possible linking the data that way.

And besides, there are zero downsides (aside from the extra ‘effort’ of adding an additional workflow step to do it, and making sure any future changes to the data run both ways).

[hacker]

@adamhholmes

Yes there are…

I believe they are but only for lists that are supposed to stay as short as possible.

---

@adamhholmes

For one it will be easier to work with data (and probably faster to load compared to doing a search for songs).

Because doing a search for 1 000+ things is faster than having the list of the 1 000+.

---

@adamhholmes

For another, there may be certain privacy rules you might want to use which (as you’ve already seen) will only be possible linking the data that way.

Yes, unfortunately that is true. Hope Bubble implements better privacy rules:

---

@adamhholmes

zero downsides

Yes there is a very big one, lists are limited to 10 000 entries.

[adamhholmes]

I’ve never heard of an Album with 10,000 songs!!!…