/

/

sql-trainer

Обзор ДокументацияВойти

/

/

sql-trainer

Аналитика

Безопасность

sql-trainer

Описание

SQL Trainer — это комплексная веб-платформа для интерактивного изучения SQL и работы с базами данных

20.56 MiB

Лицензия

Правила участия

История изменений

В избранном0

Языки

TypeScript96,2%
JavaScript3,2%
CSS0,3%
Shell0,2%
Остальные0,1%

Сообщить о нарушении

Коммиты:

MD

dupleymi-amp

fix: replace placeholder verification queries with real checks

03 авг 2026, 17:40

03 авг 2026, 17:4099f9916

chore: update gigaide properties

3 месяца назад

fix: export filename extension bug, add dev scripts, harden CI

3 месяца назад

chore: add commitlint and fix ESLint errors in hook

3 месяца назад

fix: rename unused context param to _context in e2e test

3 месяца назад

Refactor sql-editor imports and add UI screenshots

5 месяцев назад

deleted: .qwen/settings.json deleted: IMPROVEMENTS.md deleted: IMPROVEMENTS_SESSION.md modified: public/offline.html

2 месяца назад

feat: configure Amvera Cloud deployment & fix remaining TypeScript errors

3 месяца назад

fix: replace placeholder verification queries with real checks

2 месяца назад

fix: security hardening, CSRF protection, soft-delete filtering, i18n, and lint fixes

3 месяца назад

feat: complete Amvera Cloud deployment setup

3 месяца назад

refactor: extract keyboard shortcuts hook, type-safe perf route, env cleanup

3 месяца назад

.eslint-results.json

new file: .eslint-results.json modified: package-lock.json modified: package.json modified: src/components/landing-page.tsx modified: src/lib/logger.ts modified: src/lib/rate-limiter-distributed.ts

3 месяца назад

5 месяцев назад

modified: .gitignore modified: eslint.config.mjs new file: src/__tests__/safe-fetch.test.ts modified: src/app/(main)/app/page.tsx new file: src/app/api/sql-performance/route.ts new file: src/app/api/web-vitals/analytics/route.ts modified: src/app/api/web-vitals/route.ts modified: src/app/layout.tsx modified: src/components/admin/create-deadline-dialog.tsx modified: src/components/admin/deadline-manager.tsx new file: src/components/admin/performance-dashboard.tsx modified: src/components/admin/user-table.tsx modified: src/components/auth/register-form.tsx modified: src/components/auth/reset-password-form.tsx modified: src/components/locale-selector.tsx modified: src/components/teacher/deadline-manager.tsx modified: src/components/teacher/group-management.tsx new file: src/components/theme-init-script.tsx modified: src/components/ui/table.tsx modified: src/components/web-vitals.tsx new file: src/components/widget-error-boundary.tsx modified: src/lib/db/schema.ts modified: src/lib/pdf-report.ts new file: src/lib/safe-fetch.ts modified: src/lib/sql-engine.ts new file: src/lib/sql-performance-monitor.ts modified: src/lib/store/index.ts modified: src/lib/theme-provider.tsx modified: src/proxy.ts modified: vitest.config.ts

3 месяца назад

.prettierignore

chore: add Prettier formatter, format entire codebase, integrate with ESLint and lint-staged

4 месяца назад

chore: add Prettier formatter, format entire codebase, integrate with ESLint and lint-staged

4 месяца назад

i18n: convert all hardcoded Russian strings to English across API routes and lib

4 месяца назад

docs: update CHANGELOG with recent improvements - parseAndValidate, code splitting, dead code removal, date-utils

3 месяца назад

CONTRIBUTING.md

test: add password-strength unit tests, update CONTRIBUTING.md

3 месяца назад

chore: code quality, security hardening, and infrastructure improvements

3 месяца назад

fix: password validation consistency, health API cleanup, Docker improvements, copyright update

3 месяца назад

docs: mark Phase 5 items #5-#10 complete in PLAN.md

3 месяца назад

fix: password validation consistency, health API cleanup, Docker improvements, copyright update

3 месяца назад

feat: configure Amvera Cloud deployment & fix remaining TypeScript errors

3 месяца назад

feat: configure Amvera Cloud deployment & fix remaining TypeScript errors

3 месяца назад

feat: configure Amvera Cloud deployment & fix remaining TypeScript errors

3 месяца назад

commitlint.config.js

chore: add commitlint and fix ESLint errors in hook

3 месяца назад

docker-compose.yml

chore: code quality, security hardening, and infrastructure improvements

3 месяца назад

eslint.config.mjs

modified: eslint.config.mjs modified: next.config.ts new file: src/__tests__/admin-api.test.ts modified: src/__tests__/api-routes-integration.test.ts modified: src/__tests__/db-admin.test.ts new file: src/__tests__/dump-adapted.tmp.test.ts new file: src/__tests__/dump-tasks.tmp.test.ts new file: src/__tests__/dump-tasks2.tmp.test.ts modified: src/__tests__/export-utils.test.ts modified: src/__tests__/student-dashboard.test.tsx new file: src/__tests__/task-content-audit.test.ts modified: src/__tests__/teacher-api.test.ts modified: src/app/(main)/app/page.tsx modified: src/app/api/admin/analytics/student/[id]/academic-summary/route.ts modified: src/app/api/admin/analytics/student/[id]/route.ts modified: src/app/api/admin/analytics/student/[id]/streak/route.ts modified: src/app/api/admin/analytics/student/[id]/timeline/route.ts modified: src/app/api/admin/deadlines/[id]/route.ts modified: src/app/api/admin/users/[id]/ban/route.ts modified: src/app/api/admin/users/[id]/restore/route.ts modified: src/app/api/admin/users/[id]/role/route.ts modified: src/app/api/admin/users/[id]/route.ts modified: src/app/api/admin/users/[id]/unban/route.ts modified: src/app/api/performance/analytics/route.ts modified: src/app/api/performance/route.ts modified: src/app/api/sql-performance/route.ts modified: src/app/api/sql/explain/route.ts modified: src/app/api/sql/route.ts modified: src/app/api/teacher/groups/[id]/deadlines/route.ts modified: src/app/api/teacher/groups/[id]/members/route.ts modified: src/app/api/teacher/groups/[id]/notify/route.ts modified: src/app/api/teacher/groups/[id]/route.ts modified: src/app/api/teacher/groups/route.ts modified: src/app/api/teacher/student/[id]/activity/route.ts modified: src/app/api/teacher/student/[id]/route.ts modified: src/app/api/web-vitals/analytics/route.ts modified: src/components/action-bar.tsx modified: src/components/admin/analytics/achievement-analytics.tsx modified: src/components/admin/analytics/student-academic-profile.tsx modified: src/components/admin/analytics/student-detail-dialog.tsx modified: src/components/admin/analytics/time-to-complete-chart.tsx modified: src/components/admin/extended-performance-dashboard.tsx modified: src/components/admin/performance-dashboard.tsx modified: src/components/admin/system-health.tsx modified: src/components/er-diagram.tsx modified: src/components/landing-page.tsx modified: src/components/locale-selector.tsx modified: src/components/profile/achievements-grid.tsx modified: src/components/query-history.tsx modified: src/components/task-panel.tsx modified: src/components/teacher/teacher-student-dialog.tsx modified: src/components/theme-toggle.tsx modified: src/components/web-vitals.tsx modified: src/hooks/use-keyboard-shortcuts.ts modified: src/lib/api-auth.ts modified: src/lib/auth-internal.ts modified: src/lib/auth.ts modified: src/lib/db-monitor.ts modified: src/lib/db/analytics.ts deleted: src/lib/db/analytics/activity.ts deleted: src/lib/db/analytics/core.ts new file: src/lib/db/analytics/deadlines.ts new file: src/lib/db/analytics/groups.ts deleted: src/lib/db/analytics/index.ts new file: src/lib/db/analytics/notifications.ts new file: src/lib/db/analytics/reminders.ts deleted: src/lib/db/analytics/student-analytics.ts modified: src/lib/db/progress.ts modified: src/lib/db/recommendations.ts modified: src/lib/db/users.ts modified: src/lib/email.ts modified: src/lib/export-utils.ts modified: src/lib/i18n.ts modified: src/lib/logger.ts modified: src/lib/mongodb-engine.ts modified: src/lib/performance-export.ts modified: src/lib/performance-monitor.ts new file: src/lib/performance-types.ts modified: src/lib/postgresql-adapter.ts modified: src/lib/rate-limit.ts modified: src/lib/sql-engine.ts modified: src/lib/store/gamification-slice.ts modified: src/lib/store/practice-mode-slice.ts modified: src/lib/use-polling.ts modified: src/locales/en.json modified: src/locales/ru.json modified: src/locales/zh.json modified: todo.md modified: tsconfig.json

2 месяца назад

modified: eslint.config.mjs modified: next.config.ts new file: src/__tests__/admin-api.test.ts modified: src/__tests__/api-routes-integration.test.ts modified: src/__tests__/db-admin.test.ts new file: src/__tests__/dump-adapted.tmp.test.ts new file: src/__tests__/dump-tasks.tmp.test.ts new file: src/__tests__/dump-tasks2.tmp.test.ts modified: src/__tests__/export-utils.test.ts modified: src/__tests__/student-dashboard.test.tsx new file: src/__tests__/task-content-audit.test.ts modified: src/__tests__/teacher-api.test.ts modified: src/app/(main)/app/page.tsx modified: src/app/api/admin/analytics/student/[id]/academic-summary/route.ts modified: src/app/api/admin/analytics/student/[id]/route.ts modified: src/app/api/admin/analytics/student/[id]/streak/route.ts modified: src/app/api/admin/analytics/student/[id]/timeline/route.ts modified: src/app/api/admin/deadlines/[id]/route.ts modified: src/app/api/admin/users/[id]/ban/route.ts modified: src/app/api/admin/users/[id]/restore/route.ts modified: src/app/api/admin/users/[id]/role/route.ts modified: src/app/api/admin/users/[id]/route.ts modified: src/app/api/admin/users/[id]/unban/route.ts modified: src/app/api/performance/analytics/route.ts modified: src/app/api/performance/route.ts modified: src/app/api/sql-performance/route.ts modified: src/app/api/sql/explain/route.ts modified: src/app/api/sql/route.ts modified: src/app/api/teacher/groups/[id]/deadlines/route.ts modified: src/app/api/teacher/groups/[id]/members/route.ts modified: src/app/api/teacher/groups/[id]/notify/route.ts modified: src/app/api/teacher/groups/[id]/route.ts modified: src/app/api/teacher/groups/route.ts modified: src/app/api/teacher/student/[id]/activity/route.ts modified: src/app/api/teacher/student/[id]/route.ts modified: src/app/api/web-vitals/analytics/route.ts modified: src/components/action-bar.tsx modified: src/components/admin/analytics/achievement-analytics.tsx modified: src/components/admin/analytics/student-academic-profile.tsx modified: src/components/admin/analytics/student-detail-dialog.tsx modified: src/components/admin/analytics/time-to-complete-chart.tsx modified: src/components/admin/extended-performance-dashboard.tsx modified: src/components/admin/performance-dashboard.tsx modified: src/components/admin/system-health.tsx modified: src/components/er-diagram.tsx modified: src/components/landing-page.tsx modified: src/components/locale-selector.tsx modified: src/components/profile/achievements-grid.tsx modified: src/components/query-history.tsx modified: src/components/task-panel.tsx modified: src/components/teacher/teacher-student-dialog.tsx modified: src/components/theme-toggle.tsx modified: src/components/web-vitals.tsx modified: src/hooks/use-keyboard-shortcuts.ts modified: src/lib/api-auth.ts modified: src/lib/auth-internal.ts modified: src/lib/auth.ts modified: src/lib/db-monitor.ts modified: src/lib/db/analytics.ts deleted: src/lib/db/analytics/activity.ts deleted: src/lib/db/analytics/core.ts new file: src/lib/db/analytics/deadlines.ts new file: src/lib/db/analytics/groups.ts deleted: src/lib/db/analytics/index.ts new file: src/lib/db/analytics/notifications.ts new file: src/lib/db/analytics/reminders.ts deleted: src/lib/db/analytics/student-analytics.ts modified: src/lib/db/progress.ts modified: src/lib/db/recommendations.ts modified: src/lib/db/users.ts modified: src/lib/email.ts modified: src/lib/export-utils.ts modified: src/lib/i18n.ts modified: src/lib/logger.ts modified: src/lib/mongodb-engine.ts modified: src/lib/performance-export.ts modified: src/lib/performance-monitor.ts new file: src/lib/performance-types.ts modified: src/lib/postgresql-adapter.ts modified: src/lib/rate-limit.ts modified: src/lib/sql-engine.ts modified: src/lib/store/gamification-slice.ts modified: src/lib/store/practice-mode-slice.ts modified: src/lib/use-polling.ts modified: src/locales/en.json modified: src/locales/ru.json modified: src/locales/zh.json modified: todo.md modified: tsconfig.json

2 месяца назад

package-lock.json

new file: .eslint-results.json modified: package-lock.json modified: package.json modified: src/components/landing-page.tsx modified: src/lib/logger.ts modified: src/lib/rate-limiter-distributed.ts

3 месяца назад

feat: configure Amvera Cloud deployment & fix remaining TypeScript errors

3 месяца назад

playwright.config.ts

feat: add Firefox + WebKit to Playwright, write 3 new E2E scenarios (navigation, dialect switching, export)

4 месяца назад

postcss.config.mjs

chore: add Prettier formatter, format entire codebase, integrate with ESLint and lint-staged

4 месяца назад

setup-remotes.sh

chore: add script to configure dual remote push

4 месяца назад

modified: eslint.config.mjs modified: next.config.ts new file: src/__tests__/admin-api.test.ts modified: src/__tests__/api-routes-integration.test.ts modified: src/__tests__/db-admin.test.ts new file: src/__tests__/dump-adapted.tmp.test.ts new file: src/__tests__/dump-tasks.tmp.test.ts new file: src/__tests__/dump-tasks2.tmp.test.ts modified: src/__tests__/export-utils.test.ts modified: src/__tests__/student-dashboard.test.tsx new file: src/__tests__/task-content-audit.test.ts modified: src/__tests__/teacher-api.test.ts modified: src/app/(main)/app/page.tsx modified: src/app/api/admin/analytics/student/[id]/academic-summary/route.ts modified: src/app/api/admin/analytics/student/[id]/route.ts modified: src/app/api/admin/analytics/student/[id]/streak/route.ts modified: src/app/api/admin/analytics/student/[id]/timeline/route.ts modified: src/app/api/admin/deadlines/[id]/route.ts modified: src/app/api/admin/users/[id]/ban/route.ts modified: src/app/api/admin/users/[id]/restore/route.ts modified: src/app/api/admin/users/[id]/role/route.ts modified: src/app/api/admin/users/[id]/route.ts modified: src/app/api/admin/users/[id]/unban/route.ts modified: src/app/api/performance/analytics/route.ts modified: src/app/api/performance/route.ts modified: src/app/api/sql-performance/route.ts modified: src/app/api/sql/explain/route.ts modified: src/app/api/sql/route.ts modified: src/app/api/teacher/groups/[id]/deadlines/route.ts modified: src/app/api/teacher/groups/[id]/members/route.ts modified: src/app/api/teacher/groups/[id]/notify/route.ts modified: src/app/api/teacher/groups/[id]/route.ts modified: src/app/api/teacher/groups/route.ts modified: src/app/api/teacher/student/[id]/activity/route.ts modified: src/app/api/teacher/student/[id]/route.ts modified: src/app/api/web-vitals/analytics/route.ts modified: src/components/action-bar.tsx modified: src/components/admin/analytics/achievement-analytics.tsx modified: src/components/admin/analytics/student-academic-profile.tsx modified: src/components/admin/analytics/student-detail-dialog.tsx modified: src/components/admin/analytics/time-to-complete-chart.tsx modified: src/components/admin/extended-performance-dashboard.tsx modified: src/components/admin/performance-dashboard.tsx modified: src/components/admin/system-health.tsx modified: src/components/er-diagram.tsx modified: src/components/landing-page.tsx modified: src/components/locale-selector.tsx modified: src/components/profile/achievements-grid.tsx modified: src/components/query-history.tsx modified: src/components/task-panel.tsx modified: src/components/teacher/teacher-student-dialog.tsx modified: src/components/theme-toggle.tsx modified: src/components/web-vitals.tsx modified: src/hooks/use-keyboard-shortcuts.ts modified: src/lib/api-auth.ts modified: src/lib/auth-internal.ts modified: src/lib/auth.ts modified: src/lib/db-monitor.ts modified: src/lib/db/analytics.ts deleted: src/lib/db/analytics/activity.ts deleted: src/lib/db/analytics/core.ts new file: src/lib/db/analytics/deadlines.ts new file: src/lib/db/analytics/groups.ts deleted: src/lib/db/analytics/index.ts new file: src/lib/db/analytics/notifications.ts new file: src/lib/db/analytics/reminders.ts deleted: src/lib/db/analytics/student-analytics.ts modified: src/lib/db/progress.ts modified: src/lib/db/recommendations.ts modified: src/lib/db/users.ts modified: src/lib/email.ts modified: src/lib/export-utils.ts modified: src/lib/i18n.ts modified: src/lib/logger.ts modified: src/lib/mongodb-engine.ts modified: src/lib/performance-export.ts modified: src/lib/performance-monitor.ts new file: src/lib/performance-types.ts modified: src/lib/postgresql-adapter.ts modified: src/lib/rate-limit.ts modified: src/lib/sql-engine.ts modified: src/lib/store/gamification-slice.ts modified: src/lib/store/practice-mode-slice.ts modified: src/lib/use-polling.ts modified: src/locales/en.json modified: src/locales/ru.json modified: src/locales/zh.json modified: todo.md modified: tsconfig.json

2 месяца назад

modified: eslint.config.mjs modified: next.config.ts new file: src/__tests__/admin-api.test.ts modified: src/__tests__/api-routes-integration.test.ts modified: src/__tests__/db-admin.test.ts new file: src/__tests__/dump-adapted.tmp.test.ts new file: src/__tests__/dump-tasks.tmp.test.ts new file: src/__tests__/dump-tasks2.tmp.test.ts modified: src/__tests__/export-utils.test.ts modified: src/__tests__/student-dashboard.test.tsx new file: src/__tests__/task-content-audit.test.ts modified: src/__tests__/teacher-api.test.ts modified: src/app/(main)/app/page.tsx modified: src/app/api/admin/analytics/student/[id]/academic-summary/route.ts modified: src/app/api/admin/analytics/student/[id]/route.ts modified: src/app/api/admin/analytics/student/[id]/streak/route.ts modified: src/app/api/admin/analytics/student/[id]/timeline/route.ts modified: src/app/api/admin/deadlines/[id]/route.ts modified: src/app/api/admin/users/[id]/ban/route.ts modified: src/app/api/admin/users/[id]/restore/route.ts modified: src/app/api/admin/users/[id]/role/route.ts modified: src/app/api/admin/users/[id]/route.ts modified: src/app/api/admin/users/[id]/unban/route.ts modified: src/app/api/performance/analytics/route.ts modified: src/app/api/performance/route.ts modified: src/app/api/sql-performance/route.ts modified: src/app/api/sql/explain/route.ts modified: src/app/api/sql/route.ts modified: src/app/api/teacher/groups/[id]/deadlines/route.ts modified: src/app/api/teacher/groups/[id]/members/route.ts modified: src/app/api/teacher/groups/[id]/notify/route.ts modified: src/app/api/teacher/groups/[id]/route.ts modified: src/app/api/teacher/groups/route.ts modified: src/app/api/teacher/student/[id]/activity/route.ts modified: src/app/api/teacher/student/[id]/route.ts modified: src/app/api/web-vitals/analytics/route.ts modified: src/components/action-bar.tsx modified: src/components/admin/analytics/achievement-analytics.tsx modified: src/components/admin/analytics/student-academic-profile.tsx modified: src/components/admin/analytics/student-detail-dialog.tsx modified: src/components/admin/analytics/time-to-complete-chart.tsx modified: src/components/admin/extended-performance-dashboard.tsx modified: src/components/admin/performance-dashboard.tsx modified: src/components/admin/system-health.tsx modified: src/components/er-diagram.tsx modified: src/components/landing-page.tsx modified: src/components/locale-selector.tsx modified: src/components/profile/achievements-grid.tsx modified: src/components/query-history.tsx modified: src/components/task-panel.tsx modified: src/components/teacher/teacher-student-dialog.tsx modified: src/components/theme-toggle.tsx modified: src/components/web-vitals.tsx modified: src/hooks/use-keyboard-shortcuts.ts modified: src/lib/api-auth.ts modified: src/lib/auth-internal.ts modified: src/lib/auth.ts modified: src/lib/db-monitor.ts modified: src/lib/db/analytics.ts deleted: src/lib/db/analytics/activity.ts deleted: src/lib/db/analytics/core.ts new file: src/lib/db/analytics/deadlines.ts new file: src/lib/db/analytics/groups.ts deleted: src/lib/db/analytics/index.ts new file: src/lib/db/analytics/notifications.ts new file: src/lib/db/analytics/reminders.ts deleted: src/lib/db/analytics/student-analytics.ts modified: src/lib/db/progress.ts modified: src/lib/db/recommendations.ts modified: src/lib/db/users.ts modified: src/lib/email.ts modified: src/lib/export-utils.ts modified: src/lib/i18n.ts modified: src/lib/logger.ts modified: src/lib/mongodb-engine.ts modified: src/lib/performance-export.ts modified: src/lib/performance-monitor.ts new file: src/lib/performance-types.ts modified: src/lib/postgresql-adapter.ts modified: src/lib/rate-limit.ts modified: src/lib/sql-engine.ts modified: src/lib/store/gamification-slice.ts modified: src/lib/store/practice-mode-slice.ts modified: src/lib/use-polling.ts modified: src/locales/en.json modified: src/locales/ru.json modified: src/locales/zh.json modified: todo.md modified: tsconfig.json

2 месяца назад

vitest.config.ts

modified: scripts/test.mjs modified: src/__tests__/api-timing.test.ts modified: src/app/(auth)/login/page.tsx modified: src/app/(auth)/register/page.tsx modified: src/app/(auth)/reset-password/page.tsx modified: src/app/(main)/layout.tsx modified: src/app/(main)/not-found.tsx modified: src/lib/api-auth.ts modified: src/lib/api-timing.ts modified: src/lib/auth-internal.ts modified: src/lib/auth.ts modified: src/types/next-auth.d.ts modified: vitest.config.ts

3 месяца назад

Притча.jpg

5 месяцев назад

README_RU.md

(RU)