Fullstack Boilerplate Proof-of-Concept

This is a project that connects MySQL database with React client via GraphQL-powered endpoint under one hood.

Please note, this project is not suitable for production for many features are still to be improved. However, at the time of writing this document, all features checked below are fully workable.

Initial Setup

Examine .sql to see if this is compliant with your development possibilities. Add .my file to the root of the project containing the admin settings for your development database.

[client]
user=admin
password=YOUR_PASSWORD

Start MySQL server.

Install

yarn install && cd client && yarn install && cd ..
yarn run init-db

Start development

yarn run dev

Check http://localhost:4000/ if you can see the list of high scores. Finally, check the React client part at http://localhost:8080/.

Features

Milestone 1

• Designs a simple game
• Run back-end and front-end as one application

Milestone 2

• Pull high scores by other players from server

Milestone 3

• Auth for player
• Save high scores on server in a database

Milestone 4

• Implement realtime high score polling from multiple players
• Implement dynamic rules for bonuses

Milestone 5

• Boost security
• Dockerize

Under the Hood

• Vanilla ES6
• git flow
• nodejs
• Webpack
• concurrently
• MySQL
• GraphQL
• Apollo
• Less
• React
• Redux
• Redux Saga
• Reselect
• Material UI
• Router
• RabbitMQ
• Web Workers + Web Sockets + GraphQL
• Redis
• Unit tests, integration tests and end-to-end tests
• UI testing using puppeteer
• Docker