{"action":"opened","issue":{"url":"https://api.github.com/repos/chrisjstott/lunchin/issues/2","labels_url":"https://api.github.com/repos/chrisjstott/lunchin/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/chrisjstott/lunchin/issues/2/comments","events_url":"https://api.github.com/repos/chrisjstott/lunchin/issues/2/events","html_url":"https://github.com/chrisjstott/lunchin/issues/2","id":66936896,"number":2,"title":"Overall feedback","user":{"login":"rglassett","id":4405501,"avatar_url":"https://avatars.githubusercontent.com/u/4405501?v=3","gravatar_id":"","url":"https://api.github.com/users/rglassett","html_url":"https://github.com/rglassett","followers_url":"https://api.github.com/users/rglassett/followers","following_url":"https://api.github.com/users/rglassett/following{/other_user}","gists_url":"https://api.github.com/users/rglassett/gists{/gist_id}","starred_url":"https://api.github.com/users/rglassett/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rglassett/subscriptions","organizations_url":"https://api.github.com/users/rglassett/orgs","repos_url":"https://api.github.com/users/rglassett/repos","events_url":"https://api.github.com/users/rglassett/events{/privacy}","received_events_url":"https://api.github.com/users/rglassett/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-04-07T16:55:34Z","updated_at":"2015-04-07T16:55:34Z","closed_at":null,"body":"Yelp is a good project. I like the food truck angle, but you need to be careful that the time component doesn't overcomplicate things. I wouldn't try to do anything fancy like showing/hiding search results based on their availability; instead, stick to something simple like displaying the opening/closing times in the search results page.\r\n\r\nI think search should be your top priority here (possibly even before user signup/login). I typically don't log in when I use Yelp; to me it's more of a search engine than anything. Move this to an earlier phase (immediately after businesses).\r\n\r\nSchema stuff:\r\nThe `businesses.rating` column seems extraneous. You should be able to make a query for the average of all reviews for a business. Let me know if you need a SQL refresher."}}