How linskay/space-sql works
Project type and purpose
• This is a monolithic full-stack web application (“SQL Космический Тренажер”) for interactive SQL training.
• Frontend is plain HTML/CSS/JavaScript (with Thymeleaf templates in /templates and static assets in /static).
• Backend is a Spring Boot REST API with OAuth2 security, database migrations, service/repository layers, and automatic SQL-query checking.
File structure
• Top-level: pom.xml, README.md, src/main/java, src/main/resources
• src/main/java/com/spacesql:
• config: JacksonConfig, SecurityConfig (OAuth2/GitHub), SwaggerConfig
• controller: LessonController, TaskExampleController, QueryController, UserController
• service: LessonService, TaskService, TaskExampleService, QueryService
• repository: LessonRepository, TaskRepository, TaskExampleDataRepository, UserRepository
• entity + dto: domain model vs. API payloads
• exception: GlobalExceptionHandler, custom exceptions
• util: SqlValidator
• src/main/resources:
• application.properties (DB, OAuth, etc.)
• db/changelog: Liquibase XML scripts for schema and seed data
• static: index.html, practice.html, profile.html, JS, CSS, images, 404 page
• templates: Thymeleaf views
README for additional insights
• Confirms frontend stack (HTML/CSS/JS), backend (Java 17 + Spring Web + REST + Lombok), DB (PostgreSQL, H2 for tests), OAuth2 via GitHub.
• Emphasis on interactive lessons, query checking, progress tracking, gamification.