Database-Playground
Description
Database Playground is an online platform for learning different databases. You can go to the playground and start learning right away without installing anything. We have pre-made templates with different scenaries with support of PostgreSQL and MongoDB. In the future we will add classrooms and assignments, as well as support for SQLite and MySQL.
Goal of the project is to provide a easy to use platform for education in the field of databases.
Project Context Diagram
Feature Roadmap
Usage instructions
- open https://dbpg.ru in your favorite browser
- hover the menu in the top right corner
- select playground
- select the template you want to use
- press the start button
- you are now in the playground (in case of weird stuff or bugs reload the page)
- in case you selected Postgres template:
- top left is the query input, you can type your queries there and submit by the send button
- top right is the schema panel, you can see your database tables and their schemas in it (switch tabs by clicking them)
- bottom is the results panel, once you run a query it should display its execution result
- in case you selected MongoDB template:
- left is the query input
- right is the results panel
- via top bar you can return to the main page or change the template
- in case you selected Postgres template:
Launch/Access instructions
You can visit deployed version
Or you can build the app yourself:
- Clone the repo:
$ git clone https://github.com/Delta-Software-Innopolis/Database-Playground
$ cd Database-Playground
- In order for app to run you need
.envanddb.sqlite3, you can take sample data from thedeploydirectory:
$ cp deploy/db.sqlite backend/core/db.sqlite3
$ cp deploy/.env.sample .env
- Install frontend dependencies via npm:
$ cd frontend-37
$ npm install
- Run the app via
Docker Compose(Install it here):
$ docker compose up --build
- Working version should be available at http://localhost:5173