(View Raw will give you the markdown that you can copy to your repos!)
SQL To-Do List
Duration: 2 Days
I aimed to create a To-Do list using a Postgres database.
For my browser I used html and Bootstrap CSS to style my inputs and to-do list table. I used jQuery to take user input from the DOM, ajax calls to post the information to the express server. I used a get route to append the information to the DOM, a delete route to remove tasks, and two put routes to update the completion of tasks and edit the time tasks were completed.
In order to delete a task I used an svg image for my icon and a sweetalert message to confirm with the user that they wanted to delete the task. I used a checkbox to allow users to determine when a task was complete and there was a sweetalert confirming completion. Once completed I used moment.js to append the time completed to the DOM. If the task was completed earlier, I used an svg edit icon to allow users to change the time.
- Create a database named
weekend-to-do-app, - The queries in the
database.sqlfile are set up to create all the necessary tables and populate the needed data to allow the application to run correctly. The project is built on Postgres, so you will need to make sure to have that installed. We recommend using Postico to run those queries as that was used to create the queries, - Open up your editor of choice and run an
npm install - Run
npm startin your terminal - Open brower at localhost:5000
- Add tasks to your database
- Complete or Delete tasks
- Update time of completion if necessary
- Express
- Node.js
- Moment.js
- Node-postgres
- Bootstrap CSS
Thanks to Prime Digital Academy who equipped and helped me to make this application a reality, my brother Graham Gabrielson and wife Jaclyn Gabrielson for input on the usability.
If you have suggestions or issues, please email me at lucas.c.gabrielson@gmail.com