Comment system example with Laravel8 / MariaDB

This project is a test project that contains a nested comment example.

Tech Stack

Client: Vue.js

Server: PHP8, Laravel 8

Database: MariaDB

Run Locally (manually)

Clone the project

  git clone https://github.com/metinagaoglu/Laravel-Nested-Comment-SPA

Go to the project directory

  cd Laravel-Nested-Comment-SPA/src

  composer install

  php artisan key:generate

  edit .env file related your database credentials

Migrate your tables

  php artisan migrate

For sample data

  php artisan db:seed

For client side

  npm run dev

  php artisan serve --host=0.0.0.0

Run Locally (automatic with docker composer)

  git clone https://github.com/metinagaoglu/Laravel-Nested-Comment-SPA

Go to the project directory

  cd Laravel-Nested-Comment-SPA

  docker-composer up

Running Tests

To run tests, run the following command

  cd src/
  php artisan test

Roadmap

• Optimize SQL queries

• Improve validation

• Don't use root account for database

Useful resource

• Nested set model
• Hierarchical and recursive queries in SQL
• Laravel nestedset