{"action":"created","issue":{"url":"https://api.github.com/repos/benetech/MathShare/issues/171","repository_url":"https://api.github.com/repos/benetech/MathShare","labels_url":"https://api.github.com/repos/benetech/MathShare/issues/171/labels{/name}","comments_url":"https://api.github.com/repos/benetech/MathShare/issues/171/comments","events_url":"https://api.github.com/repos/benetech/MathShare/issues/171/events","html_url":"https://github.com/benetech/MathShare/issues/171","id":334251575,"node_id":"MDU6SXNzdWUzMzQyNTE1NzU=","number":171,"title":"Implement database solution","user":{"login":"johnhbenetech","id":12927553,"node_id":"MDQ6VXNlcjEyOTI3NTUz","avatar_url":"https://avatars3.githubusercontent.com/u/12927553?v=4","gravatar_id":"","url":"https://api.github.com/users/johnhbenetech","html_url":"https://github.com/johnhbenetech","followers_url":"https://api.github.com/users/johnhbenetech/followers","following_url":"https://api.github.com/users/johnhbenetech/following{/other_user}","gists_url":"https://api.github.com/users/johnhbenetech/gists{/gist_id}","starred_url":"https://api.github.com/users/johnhbenetech/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johnhbenetech/subscriptions","organizations_url":"https://api.github.com/users/johnhbenetech/orgs","repos_url":"https://api.github.com/users/johnhbenetech/repos","events_url":"https://api.github.com/users/johnhbenetech/events{/privacy}","received_events_url":"https://api.github.com/users/johnhbenetech/received_events","type":"User","site_admin":false},"labels":[{"id":952834676,"node_id":"MDU6TGFiZWw5NTI4MzQ2NzY=","url":"https://api.github.com/repos/benetech/MathShare/labels/architect","name":"architect","color":"1d76db","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-20T21:13:13Z","updated_at":"2018-06-26T15:24:27Z","closed_at":null,"author_association":"MEMBER","body":"We need to choose a database solution for saving of user work/problem sets.\r\n\r\nI guess I would lean towards a relational database (preferably Postgres), but if you guys have a strong reason to use something more NoSQL/Document just let me know the justification."},"comment":{"url":"https://api.github.com/repos/benetech/MathShare/issues/comments/400350571","html_url":"https://github.com/benetech/MathShare/issues/171#issuecomment-400350571","issue_url":"https://api.github.com/repos/benetech/MathShare/issues/171","id":400350571,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMDM1MDU3MQ==","user":{"login":"pgesek","id":1384169,"node_id":"MDQ6VXNlcjEzODQxNjk=","avatar_url":"https://avatars2.githubusercontent.com/u/1384169?v=4","gravatar_id":"","url":"https://api.github.com/users/pgesek","html_url":"https://github.com/pgesek","followers_url":"https://api.github.com/users/pgesek/followers","following_url":"https://api.github.com/users/pgesek/following{/other_user}","gists_url":"https://api.github.com/users/pgesek/gists{/gist_id}","starred_url":"https://api.github.com/users/pgesek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pgesek/subscriptions","organizations_url":"https://api.github.com/users/pgesek/orgs","repos_url":"https://api.github.com/users/pgesek/repos","events_url":"https://api.github.com/users/pgesek/events{/privacy}","received_events_url":"https://api.github.com/users/pgesek/received_events","type":"User","site_admin":false},"created_at":"2018-06-26T15:24:27Z","updated_at":"2018-06-26T15:24:27Z","author_association":"COLLABORATOR","body":"@johnhbenetech as I mention on our call last week, a nosql solution would fit nicely with the initial architecture, where we pretty much only store the math steps and the generated url. We could store these steps in the form of a json document - so whatever the user would create on the UI we would store in the database with minimal modification.\r\n\r\nThe further we will go with teacher, assigning problems and so on, an SQL solution will start to fit more and more. I think all around we also have more experience with relational databases, so I am fine with using Postgres. \r\n\r\nHow do we move forward with this?  Should we design a backend architecture/stack and once approved proceed with the implementation?"}}
{"actor":{"display_login":"pgesek"}}