Bookcase 📚

An app for posting your book recommendations 👍

User Stories 👩‍💻

Note: - is partially done

• A form for users to submit data
• A page showing all the data
• Semantic form elements with correctly associated labels
• A Postgres database hosted on Heroku
• A schema describing your database in your README
• [-] Tests for server routes and database access
• [-] Not process user input as SQL commands
• Hidden environment variables (i.e. not on GitHub)

What we learnt 🧠

• How to create an SQL database
• How to query our database from within our app
• How to connect to our database running on a local server
• How to use a model.js file to hold our SQL queries
• How to store our database connection string in an environment variable

Future improvements 🤞

• A page showing all books added to the app and the user who added them.
• A way to see all books added by a specific user.
• GitHub Actions CI setup running tests when we push
• Finish app deloyment to Heroku
• A way for users to login and see their books.
• A way for users to rate books and recommend them to each other.

Project board

Database