Loading repository dataβ¦
Loading repository dataβ¦
mezentsevs / repository
π‘ A full-stack SPA platform for learning database querying. Offers secure sandboxes with various databases, free exploration, and structured exercises. Features an AI mentor (cloud/local) for query analysis and optimization. Built with PHP, Symfony, MySQL, PostgreSQL, SQLite, TypeScript, Vue, Tailwindcss, Docker.
A transparent discovery signal based on current public GitHub metadata.
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
Please be aware that this application is in active development. The project is continuously evolving with planned fixes, improvements, and additional capabilities. Thank you for your understanding and support.
This is a query play studio, written in and for educational and demonstrational purposes.
A full-stack SPA platform for mastering database query writing across various database systems. Provides secure sandbox environments with different databases for hands-on experimentation. Supports both free exploration and structured exercise modes. Features an AI mentor using cloud or local models for intelligent query analysis, performance optimization, and guidance on advanced query language constructs.
Based on tech stack:
git clone [repository-url]
cd /path/to/query-play-studio/
Add file .env.local with your parameters
Run Docker Desktop (with wsl - for Windows only)
Run wsl (for Windows only):
wsl
docker-compose --env-file .env.local up -d
or
./docker/run.sh
./docker/build.sh
./docker/stop.sh
./docker/kill.sh
docker compose exec php bin/console secrets:generate-keys
docker compose exec php bin/console secrets:set APP_SECRET
or
docker compose exec php php -r "echo 'APP_SECRET=' . bin2hex(random_bytes(32)) . PHP_EOL;"
docker exec -it qps-php bash
composer install
npm install
npm run build
npm run devfrontend directory, so the command runs from /app/frontend in the container.http://localhost:3000/ for HMR.http://localhost to see the application.npm run buildfrontend directory, so the command runs from /app/frontend in the container.public/build/ directory (in the project root, one level up from frontend).app.js (JavaScript bundle), app.css (all CSS styles in one file), and chunk files in the chunks/ folder.APP_ENV=prod and APP_DEBUG=0 in your .env.local file.php bin/console cache:clear --env=prodpublic/build/ directory) and open http://localhost.APP_ENV=prod, and clear the cache.public/build/ folder, set APP_ENV=dev, and start the Vite dev server again.http://localhost:3000/.public/build/ directory (located at the project root) and served by Caddy.APP_ENV (in .env.local): Controls which scripts are included by Twig (dev for Vite HMR, prod for compiled assets).NODE_ENV: Automatically set by Vite (development when running npm run dev, production when building).That's it! Thank you!
If this project helped you - whether it saved you time, taught you something, or gave you an idea - please consider leaving a star or a like. A β, π, β€οΈ, or π tells me that the work matters. It's a small gesture that genuinely fuels my motivation to keep improving the project and building new tools.
Thanks for your interest in this project!
The 'Query play studio' is open-sourced software licensed under the MIT license.