A message board web application I made to study REST endpoints, postgreSQL, cloud deployment, and user authentication + authorization.
- Password
- First Name
- Last Name
- Session ID
- User ID
- User First Name
- Timestamp
- Sender
- Message Text
CREATE TABLE messages (
id INTEGER PRIMARY KEY,
timestamp VARCHAR(255) NOT NULL,
sender VARCHAR(255) NOT NULL,
message VARCHAR NOT NULL,
);
CREATE TABLE users (
id INTEGER PRIMARY KEY,
email VARCHAR NOT NULL,
encpass VARCHAR NOT NULL,
firstname VARCHAR(255) NOT NULL,
lastname VARCHAR(255) NOT NULL
);
| Name | Path | HTTP Method |
|---|---|---|
| Register User | /users | POST |
| Login User | /session | POST |
| Retrieve Messages | /messages | GET |
| Post Message | /messages | POST |
encpass = bcrypt.encrypt(parsed_data['encpass'][0])
# encpass is the form data key for a password
# uses random salt