Materials Database App
What: Built a proof-of-concept Flask/Jinja app with SQLite+Google-drive backend; admin CRUD, role-based access, secure file delivery (via drive API), metadata tracking, and keyword search.
Why: Provide governed, reproducible management of research files and tabular datasets for collaborative work & a practice-project of RDBMS through serving as a documentation platform of my works with materials data & music.
How: Automated ETL (CSV/NPY → pandas → SQL), type validation, normalized schemas, idempotent imports, and Google Drive API integration for ingestion, preview, and download.
Results: Provenance & timestamps on every dataset, facilitating FAIR principle on the data and potential dependable data hub for the team once eveolved and scaled-up. -->> Demo
