Database Nested sets

Storing, Querying binary trees in a relational database and building a REST api from it. More about the exercise here

Visual sketch of data representation

Project Specs

Installations and Setup

• Execute the SQL queries inside tables.sql to setup the database and it's tables
• Execute the SQL queries inside data.sql to insert data
• clone/download this project and put the folder inside your server hosting folder (www, htdocs etc..)
• configure your database access inside the file config/config.php
• launch your Webserver and open the project via your favourite browser

Testing the app

This app is deployed and availaible online here

Demo videos

Sample search string = https://nested-sets.herokuapp.com/api.php/?node_id=2&language=italian&search=helpdesk&page_size=210&page_num=0

• VIDEO 1 - PROJECT PRESENTATION
• VIDEO 2 - PROJECT PRESENTATION

Code walk-through video

• VIDEO 3 - HOW THE CODE WORKS

Tools used

• phpMyAdmin (DBMS tool)
• MAMP (web server)
• Postman (testing API calls)
• Curl (command line tool to test API calls)
• MySQL WorkBench (DBMS tool)
• Bash terminal (for typing commands)
• Heroku (deployment)
• VSCode (coding tool)

Future ameliorations

• populate the database with more data (more complex tree) to play with
• Build a React-App (front-end) to fetch the data and display on a compelling responsive UI

Contributor

👤 SHEY Louis CHIA

• Github: shloch
• Twitter: @shloch
• Linkedin: /in/shey-louis-chia
• Email: shloch2007@yahoo.fr

Acknowledgements

• https://www.youtube.com/watch?v=RswtHsz4v-0
• http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/
• https://code.tutsplus.com/tutorials/how-to-paginate-data-with-php--net-2928