We launched Convex Components to make adding features to your app easier! 🎉

Relational Data

Represent & navigate relationships between db tables

The vast majority of apps need some kind of relational data model, connecting the dots between different entities represented as documents in a different db tables. In Convex, relational data can easily be modeled by means of document IDs, which enable references between documents stored anywhere in Convex, regardless of whether those relationships are 1:1, 1:many, or many:many. When it comes time to traverse those relationships while querying data, in Convex you just write code, instead of JOIN statements. Open-source helper functions written by the Convex team make it even easier to quickly define & navigate relational data with Convex.

Resources

Walkthrough: Modeling data relationships in Convex schemas

stack.convex.dev/relationship-structures-let-s-talk-about-schemas

Walkthrough: Helper functions for traversing data relationships

stack.convex.dev/functional-relationships-helpers

Sample code demonstrating relational data in Convex

github.com/get-convex/convex-demos/tree/main/relational-data-modeling

Import relationship helper functions from 'convex-helpers'

www.npmjs.com/package/convex-helpers#relationship-helpers

Read up on how & why Convex differs from traditional relational DBs

stack.convex.dev/convex-vs-relational-databases

Learn how to use document IDs to link data across Convex tables

docs.convex.dev/database/document-ids#references-and-relationships

Watch a short about why & how to model data relationships

www.youtube.com/shorts/ALW6_y79HU0

Get your app up and running in minutes

DevelopersDocs Developer Portal Templates Changelog Open Source Components Podcast Champions

ProductSync Realtime Actions Transactions Auth AI & Search Pricing Startups

CompanyAbout Us Brand Investors Jobs News Terms of Service Security

SocialTwitter Discord YouTube Luma Bluesky GitHub

A Trusted Solution

SOC 2 Type 1 Compliant
HIPAA Compliant
GDPR Verified

©2024 Convex, Inc.