Welcome to SQLOJ 👋

A lightweight database system experimental platform that integrates an OJ of SQL and a variety of practical functionalities.

✨ Demo

Install

docker pull ptyin/sqloj

Usage

docker run -d -p 80:80 -v <mongo-db-path>:/data/db -v <mongo-configdb-path>:/data/configdb -v <sqlite-path>:/var/lib/sqloj ptyin/sqloj:latest 

where <mongo-db-path><mongo-configdb-path><sqlite-path> denotes the data persistence directories path in your server. e.g.,

In Windows:

docker run -d -p 80:80 -v D:\SQLOJ\mongodb\data:/data/db -v D:\SQLOJ\mongodb\config:/data/configdb -v D:\SQLOJ\sqlite:/var/lib/sqloj --name test ptyin/sqloj:latest 

In Linux:

docker run -d -p 80:80 -v /opt/SQLOJ/mongodb/data:/data/db -v /opt/SQLOJ/mongodb/config:/data/configdb -v /opt/SQLOJ/sqlite:/var/lib/sqloj --name test ptyin/sqloj:latest 

Run tests

npm run test

Functionality

Module Design

User Management

User Role

• teacher
  • Default teacher username: admin
  • Default teacher password: tsxt-adm1n
• student

Login Panel

Teacher Example Page

Publish an assignment

Add questions in a certain assignment

Upload a database

Student Example Page

View question list

Review uploaded records

Status might be (RUNNING/AC/WA/RE/TLE)。

Check specific information in a record

Author

👤 Peter Yin

• Website: http://ptyin.asia/
• Github: @PTYin

Show your support

Give a ⭐️ if this project helped you!

📝 License

Copyright © 2021 Peter Yin.
This project is MIT licensed.