User functionality

[brianfoshee]

Opening a new issue for this since it encapsulates both front and backend issues and may or may not be available for the pitch day.

• [x] User table - email, hashed password
• [x] foreign key on devices table to user
• [ ] Sign up functionality
• [ ] Sign in page
• [ ] Sign in button

Dropping this here as a good reference for user functionality. It's probably a lot more than we'll initially need, but coming from Rails the idea is great. Instead of a library to handle all of the user registration/authentication, let Postgres do it! The example is using node.js, but it just sets up some Postgres tables and runs some tests which I think we could easily convert to Go.

http://rob.conery.io/2015/03/17/membership-in-a-box-with-pg-auth

[nathanprayzo]

@brianfoshee I added email/sms notifications as an user functionality item; I think we should treat this as a top priority. As an MVP it would be sufficient to have static thresholds and a static email/phone number. It looks like heroku has several email/sms add-ons, have you used any of these previously?

https://addons.heroku.com/#email-sms

[brianfoshee]

@letsgitgrowing good idea. Let's make notifications its own issue outside of user functionality since they're different enough domains. Some of the heroku addons are nice but using them through heroku isn't the cheapest option. All of those addons are available standalone with your own account. I'd recommend something like Mandrill for sending emails and Twilio for SMS. Getting a testable notifications interface setup with a mock sender on the server will be a good first step (to simply log messages to stdout), then we can drop in the messaging services when we get them setup.

[brianfoshee]

Moved notifications into its own issue #39

[brianfoshee]

http://stackoverflow.com/questions/23259586/bcrypt-password-hashing-in-golang-compatible-with-node-js

http://godoc.org/golang.org/x/crypto/bcrypt

[nathanprayzo]

@brianfoshee I committed the migrations for the 'users' table, let me know how they look. Going to proceed to implement AddUser and SignIn functions for postgresManager