January 2025 Summaries

Firebase Data Connect, now renamed SQL Connect, supports relational database modeling through schemas that define primary keys, foreign keys, and one-to-one, one-to-many, and many-to-many associations. It can automatically generate primary key fields and store them in `implicit.gql`, while relationship fields create corresponding implicit foreign-key references. One-to-one relationships use the `@unique` directive to ensure each referenced record appears only once, illustrated by a movie and its metadata. One-to-many relationships can combine `@unique` for the single-side constraint with references for the many side, such as users each selecting one favorite movie, and may use composite keys rather than generated IDs. Many-to-many relationships are modeled through join tables with composite keys, allowing records such as actors and movies to be linked while retaining relationship-specific attributes like an actor’s role.