FaceFlix

It's a GraphQL and Falcor personal experiment. The goal is to make a comparison between those technologies.

Because GraphQL and Falcor have been developed by Facebook and Netflix respectively, the experiment consists of a social network mix with a movie catalog, where users can create posts and comments about the movies they're watching.

• GraphQL REPL
• Falcor REPL

Setup

Dependencies:

• Node.js
• Yarn
• PostgreSQL

Creating database:

  $ psql
  $ CREATE DATABASE faceflix_development;

Setup Node:

  $ yarn
  $ yarn dbsetup

Running:

  $ yarn dev

GraphQL Schema

enum Gender {
  male
  female
}

Celebrity {
  name: String
  gender: Gender
  birthday: Date
  biography: String
  works: [Credit]
  avatar: Media
}

Comment {
  body: String
  user: User
  post: Post
  movie: Movie
  reactions: [Reaction]
}

Company {
  name: String
  movies: [Movie]
}

enum Role {
  director
  writer
  actor
}

Credit {
  movie: Movie
  celebrity: Celebrity
  role: Role
}

Favorite {
  user: User
  movie: Movie
}

Genre {
  name: String
  movies: [Movie]
}

enum FileType {
  image
  video
}

Media {
  videoUrl: String
  imageUrl: String
  type: FileType
  owner: User | Celebrity | Movie
}

Post {
  body: String
  author: User
  movie: Movie
  comments: [Comment]
  reactions: [Reaction]
}

enum ReactionType {
  like
  dislike
}

Reaction {
  user: User
  type: ReactionType
  reactionable: Post | Comment
}

Recommendation {
  user: User
  movie: Movie
}

Movie {
  budget: Int
  rating: Float
  overview: String
  releaseDate: Date
  revenue: Int
  runtime: Int
  tagline: String
  title: String
  poster: Media
  trailer: Media
  crew: [Credit]
  director: Celebrity
  companies: [Company]
  genres: [Genre]
  posts: [Post]
  recommendations: [Recommendation]
  favorites: [Favorite]
}

User {
  name: String
  email: String
  gender: Gender
  avatar: Media
  comments: [Comment]
  posts: [Post]
  favorites: [Favorite]
  recommendations: [Recommendation]
  reactions: [Reaction]
  friends: [User]
}

Querying DB

// $ node

User = require('./models/user')
Media = require('./models/media')

User.where({id: 1})
  .fetch({withRelated: ['avatar']})
  .then((user) => user.serialize().avatar)

Media.where({id: 8})
  .fetch({withRelated: ['owner']})
  .then((media) => media.serialize().attachable.name)

Query GraphQL

• Go to /graphql/repl

query {
  post(id: 1) {
    id
    body
    author {
      name
      avatar {
        imageUrl
      }
    }
    movie {
      title
      rating
      tagline
      poster {
        imageUrl
      }
      trailer {
        videoUrl
      }
      director {
        name
        avatar {
          imageUrl
        }
      }
      crew {
        role
      	celebrity {
          name
          avatar {
            imageUrl
          }
        }
      }
      recommendations {
        user {
          name
        }
      }
    }
    comments(first: 3) {
      body
      user {
        name
        avatar {
          imageUrl
        }
      }
      reactions {
        type
        user {
          name
        }
      }
    }
    reactions {
      type
      user {
        name
      }
    }
  }
}

Query Falcor

• Go to /falcor/repl

[
  ["postById", 1, ["body", "id"]],
  ["postById", 1, "author", "name"],
  ["postById", 1, "author", "avatar", "image_url"],
  ["postById", 1, "movie", ["rating", "tagline", "title"]],
  ["postById", 1, "movie", "poster", "image_url"],
  ["postById", 1, "movie", "trailer", "video_url"],
  ["postById", 1, "comments", {"from": 0, "to": 2}, "body"],
  ["postById", 1, "comments", {"from": 0, "to": 2}, "user", "name"],
  ["postById", 1, "comments", {"from": 0, "to": 2}, "user", "avatar", "image_url"]
]

DER

celebrities:
  id
  name
  gender
  biography
  birthday
  created_at
  updated_at

comments:
  id
  body
  user_id
  post_id
  created_at
  updated_at

companies:
  id
  name
  created_at
  updated_at

credits:
  id
  movie_id
  celebrity_id
  role
  created_at
  updated_at

favorites:
  id
  movie_id
  user_id
  created_at
  updated_at

friendships:
  id
  user_one_id
  user_two_id
  status
  created_at
  updated_at

genres:
  id
  name
  created_at
  updated_at

medias:
  id
  video_url
  image_url
  attachable_id
  attachable_type
  type
  created_at
  updated_at

movies:
  id
  title
  overview
  tagline
  budget
  release_date
  revenue
  runtime
  rating
  created_at
  updated_at

posts:
  id
  body
  user_id
  movie_id
  created_at
  updated_at

reactions:
  id
  user_id
  type
  reactionable_id
  reactionable_type
  created_at
  updated_at

recommendations:
  id
  movie_id
  user_id
  created_at
  updated_at

users:
  id
  name
  email
  gender
  created_at
  updated_at