tiennm99/thptqg
1
0 Fork 0
mirror of https://github.com/tiennm99/thptqg.git synced 2026-10-16 08:15:40 +00:00
Code Issues Packages Projects Releases Wiki Activity
50 Commits 3 Branches 0 Tags
chore/migration-backup-260519
Commit Graph
3 Commits
Author SHA1 Message Date
tiennm99 d968459b9d refactor: rename assets/ to data/ for raw Excel inputs 2026-04-14 21:20:10 +07:00
tiennm99 f885aeb6cc feat: add diacritics-insensitive name search 
Add ho_ten_ascii column with normalized names (no diacritics, lowercase)
so users can search "nguyen van a" to find "NGUYỄN VĂN A".

- ASCII input searches against ho_ten_ascii column
- Vietnamese input searches both ho_ten and ho_ten_ascii
- Indexed for fast lookups
 2026-04-14 20:15:20 +07:00
tiennm99 372f1e04fb feat: add GitHub Pages app with custom SQL query support 
- React + Vite + sql.js frontend with two-tab UI:
  - Quick search by exam ID (alphanumeric) or student name
  - Custom SQL query editor with 7 preset queries
- Build script handles all 5 Excel data formats (varied column
  orders, separate score columns, no-header, .xls/.xlsx)
- Database: 877,461 students with exam center, gender, 12 subjects
  (including 4 foreign languages: French, German, Japanese, Chinese)
- GitHub Actions CI/CD: build DB, gzip compress, deploy to Pages
- Safety: read-only queries only, auto LIMIT 1000, Ctrl+Enter shortcut
 2026-04-14 20:05:38 +07:00