testSQL

A dynamic SQL problem generator application to test your knowledge on SQL. Can be build to run in either client or server mode.

Built using

• ReactJS
• create-react-app
• MaterialUI

Screenshots

Demo

Currently there are two versions of testSQL hosted as a demo.

Website	Detail
https://react-testsql.herokuapp.com/	Full version.
https://joshualicense.github.io/react-testsql/	Client-only version.

Still here? Good. Want to run it yourself?

Prerequisites

Make sure you have git, and yarn or npm installed.

For the full version, a MongoDB container is required, the URI should be set inside .env. See mLab for a free option.

Getting started

1. Clone this repository locally.
   git clone https://github.com/JoshuaLicense/react-testsql.git
2. Change directory.
   cd react-testsql
3. Install all depedancies for testSQL.
   yarn
4. Configured a .env file using env-example as a template.
5. Start testSQL.
   yarn start
   or
   yarn start:client
6. Open localhost:3001 or localhost:3000 (client only) in your browser.

See a full list of commands here

FAQ

Why is the payload so large?

To ensure the application runs solely in the browser, react testSQL uses SQL.js which is SQLite compiled into JavaScript.

How can I add a new question?

See here.

Please find additional help in the wiki. Questions that are not found please raise an issue.