Skip to content

About

No description, website, or topics provided.

Resources

Stars

1 star

Watchers

1 watching

Forks

Latest commit

 

History

17 Commits

Folders and files

Repository files navigation

Optimizing sql-queries exercise

  • added basic bootstrap and UI
  • implemented auth0 authentication
  • after login, user sees the answers table
  • with required columns
  • table is paginated
  • filtering by form
  • click on header to sort
  • data for table is eager loaded
  • indexes added:
  :learners, :full_name
  :learners, :email, unique: true
  :quizzes, :name
  :questions, :title
  # Assuming people are learning to pass, so there will be much less incorrect answers, hence partial index on them is reasonable
  :possible_answers, :value, where: "value = 'Possible Answer Incorrect'"
  # As above, partial index is reasonable on not correct answers(as soon as I correctly understood meaning of these columns)
  :possible_answers, :correct, where: "correct = FALSE"
  # change autogenerated :answers, :possible_answer_id to (since there are only two possible values of :possible_answer):
  :answers, [:possible_answer_id, :learner_id]
  • sensitive data in dotenv and envied
  • bin/setup improvement

About

No description, website, or topics provided.

Resources

Stars

1 star

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages