AI Course Assistant
Flagship
A local, AI-powered learning platform. Admins create courses and upload
documents; students chat with a course-aware assistant, auto-generate
summaries and quizzes, reveal answers, export to PDF and review history —
all running offline through a local LLM (LM Studio). No data leaves the machine.
- Course-aware chat over uploaded docs — chunk retrieval → local model as context
- Multilingual document summaries: English · Vietnamese · 繁體中文
- Auto quiz generator with click-to-reveal answers + DB caching by doc/lang/count
- PDF export, chat history in Taiwan time, MathJax formula rendering
- Admin dashboard with live course / document / quiz statistics
PythonFastAPISQLAlchemyMySQL
DockerLM Studio · local LLMJinja2MathJax
View repo →
Local build · FastAPI · Docker · LM Studio
★
LINE OpenAI Chatbot
Public
A context-aware LINE chatbot using Flask, the LINE Messaging API,
OpenAI integration, per-user conversation history, RESTful history
endpoints, and Cloudflare Tunnel for webhook testing.
Python
Flask
LINE API
OpenAI API
REST
View repo →
01
CSV Database & Query Engine
C++ · CS351
A lightweight CSV-backed mini-database: parses files into memory and runs
SQL-like queries — SELECT columns with WHERE filters — from a console REPL.
Simulates how a DBMS works internally, with no external engine.
C++ParsingQuery EngineIn-memory DB
View repo →
02
Two Sum — Algorithms
C++ · CS351
The classic Two Sum done properly: an O(n) hash-map solution backed by a
20-case test suite (negatives, zeros, duplicates, huge ints), a CMake build
and GitHub Actions CI across Linux, macOS and Windows.
C++AlgorithmsCMakeCI/CDUnit tests
View repo →
03
IMDb Sentiment Baseline
Public
An ML baseline for IMDb sentiment classification using BoW / TF-IDF and
Logistic Regression — training, model saving, evaluation metrics included.
PythonMLscikit-learnNLP
View repo →
04
Hotel Management DB
Public
A MySQL database for hotel ops — booking, payment, cleaning, maintenance.
Schema design, triggers, procedures, views and demo scripts.
MySQLSchemaProceduresTriggers
View repo →
05
Smart File Organizer
Public
A Python tool that classifies and moves files automatically by type or
rule — local file management that stops being a mess.
PythonAutomationFile System
View repo →
06
CS351 Course Repo
Coursework
The home base for CS351 — assignments, project docs, file organisation and
a GitHub-based workflow, linking out to Project 0 and Project B.
CourseworkGitHubDocsC++ · Python
View repo →
07