Relationships in the Database

[adityaoberai]

Hey folks 👋

Lately, we have been working on one of the most requested features to improve our Databases service: Relationships 🥳

We've created an RFC for database relationships to explain the purpose and implementation of this feature: Database Relationships - RFC

Additionally, this feature requires some changes in the Appwrite Console. To see how this new feature might work, we are inviting you to try the Figma prototype below. The prototype simulates the creation of a many-to-one relationship between a collection called Review to a collection called Movie.

https://www.figma.com/proto/WxczFR7RG5OLKMnC0EW9YD/Databases?node-id=2283%3A140215&scaling=scale-down&page-id=2283%3A136756&starting-point-node-id=2283%3A140215

We would love for you folks to have a look at the RFC and the prototype and share your thoughts and feedback here 🙏

[squallsama]

What about cascade delete when parent doc removed ? For example if Movie will be removed - Appwrite should remove Reviews associated with this Movie or at least give this option to set this in attributes.

[abnegate]

@squallsama Yep this will be an option for the relationship attribute

[rhengles]

Who is self:: here ?

Creating a relationship with an SDK:

$client = new Client();
$databases = new Databases(client);

$relationship = $databases->createRelationship(
    databaseId: 'music',
    collectionId: 'albums',
    relatedCollectionId: 'artists',
    type: Relationship.ManyToOne,
    key: 'artist',
    twoWay: true,
    twoWayId: 'albums',
    onUpdate: self::CASCADE,
    onDelete: self::RESTRICT
);

[abnegate]

These should be Database::CASCADE and Database::RESTRICT, they are just constants for 'cascade' and 'restrict'. Will update 😁

[squallsama]

Also would be great to have Row Level Security with ability to use allowed userIds from different collections

[stnguyen90]

What do you mean by this? Our permission system should already support row level security 🧐

[squallsama]

You can specify user ids in permission section, but you can't use queries inside Permission object.

[stnguyen90]

@squallsama, I see. That's quite unrelated to this topic. I would suggest creating an issue to request this type of feature.

[maciej-sz]

Are you also planning to support the relationships in nested queries of the GraphQL API?

[rafagazani]

@abnegate Will the Relationship type attributes have some protection to prevent the sdk client from updating these fields?

[JamieBradders]

Just wanted to say that I love the proposed UX (Figma Designs). Really can't wait to see this feature. Well done team and thank you! 🎉

[eldadfux]

Everyone, we're excited to share database relationships are now available as a beta feature in Appwrite 1.3!
You can learn more on our full announcement: https://dev.to/appwrite/join-celebrations-appwrite-13-ships-relationships-57fc

We're excited to here what you all think!

[racingfoxs]

On the new version,

Only 3rd level of relation data is shown. (listDocuments from 1st)

I'll get all four level data if I listDocuments from 2nd Level.

Can we do one more level 4th?****

[hortigado]

Same i need 4 levels or more

[ikanindustries]

Is there a way to upgrade my appwrite cloud version?