A simple social network example in Node.js for the HackYourFuture course.
To install and run the project, follow these steps:
- Clone the Git project off of GitHub:
git clone [email protected]:Mickael-van-der-Beek/instabook.git
- Browse to the project folder in your terminal
cd instabook
- Build the Docker image
docker-compose build node
- Start the Docker container
docker-compose up node
Every time you add a Node.js dependency, you'll need to rerun the step 3. and 4.
For this project, the following technologies will be used:
- Node.js, back-end language
- Express, web server
- PostgreSQL, database server
- PG, database client
- users table
- user(s) retrieval functions and database queries
- user creation function and database query
- user modification function and database query
- user deletion function and database query
- posts table
- post(s) retrieval functions and database queries
- post creation function and database query
- post modification function and database query
- post deletion function and database query
- comments table
- comment(s) retrieval functions and database queries
- comment creation function and database query
- comment modification function and database query
- comment deletion function and database query
- filter users by handle
- filter posts by user
- filter comments by post
- sort users by id
- sort posts by likes
- sort comments by creation date
- paginate users retrieval
- paginate posts retrieval
- paginate comments retrieval
- Index user queries
- Index post queries
- Index comment queries
- Prevent SQL injections
- Prevent race conditions
- aggregation queries
- sub-queries and CTEs
- LIKE and RegExp operators
- array operators