I’m listing here a selection of projects I’ve worked on (and can be shared publicly), as a quick snapshot.

• sat-evaluation-framework - An automated static applicaiton security testing (SAST). Evaluating CodeQL, CodeChecker, CppCheck, Infer, and Flawfinder. Code changes warning-based prioritization experiment, annotated dataset, and replication package for this paper.
• code-review-fuzzing-invariant - A dynamic analysis framework for detecting program behavioral changes using likely invariants, with replication package for this paper (AFL++, HonggFuzz, libFuzzer, LLDB, DIG).
• secure-code-review-mining - A semi-automated security-related code review comment mining framework (word-embedding similarity ranker & manual annotation on CWE taxomony) and annotated dataset, corresponding to this paper.
• patchwork-mining-tool-suite - A large email-based code review dataset and tool suite for mining Patchwork, an email code review platform used by many OSS projects (including Linux Kernel, FFMpeg), corresponding to this paper.
• github-api-rate-limit-watcher - A script to pause (and resume) repository mining process when GitHub API's rate limit is reached.

• diary-rag - Revisiting my Smithnosian blog posts using open-source lightweight RAG and LLM (LangChain, Chroma, Ollama), with explanation.
• sstm-projection - Shanghai Science and Technology Museum - Visitor Prediction (ML Deployment) (R, Shiny).

• mysql-nth-position-within-group - Selecting N^th position within a designated group. schema & test data, top position, N^th position.
• blog-r-time-series-map, blog-tableau-time-series-map - A series of blog posts visualizing time-series data on geographic map using R and Tableau (in Thai).
• blog-r-eda-1, blog-r-eda-2 - A series of blog posts performing in-depth exploratory data analysis on an ultramarathon event (in Thai).

• biologic - A suite of web applications that take a new approach to teaching and assessing scientific concepts (Python, VueJS, AWS, Vercel).
• firebase-class-consensus - A realtime classroom consensus vote & monitoring system with Firebase, explained in medium.
• museum-collection-database - A Dublin Core–compliant metadata management database, built on top of OmekaCMS.
• museum-rfid-activity-station - A local network client–server checkpoint system for walk-rally activities, built with Raspberry PI clients and a NodeJS backend.
• building-sensor-iot - An IoT dashboard project for building's environment monitoring system (Arduino & Firebase).
• arduino-bootcamp - A microcontroller / Arduino tutorial for amateur micro satellite (CanSat) bootcamp.