Hongyu Guo is an experimental physicist and Associate Professor with over 18 years in condensed matter research and deep expertise in synchrotron X-ray and neutron scattering techniques. He has a strong track record from Johns Hopkins and NIST to the Chinese Academy of Sciences studying structure and dynamics of soft and complex materials, bridging hands-on beamline experiments with rheology and theory. Beyond academia, he contributes to open-source backend development—enhancing SQL support and string functions in the widely used Apache Calcite project—demonstrating fluency in both scientific instrumentation and production-grade software. Based in the Washington DC–Baltimore area, he combines long-form experimental programs with pragmatic software contributions that improve data processing and query capabilities for broader research and engineering workflows.
3 years of coding experience
5 years of employment as a software developer
Johns Hopkins University
Master of Science (M.S.), Physics, Master of Science (M.S.), Physics at Peking University
Contributions:93 reviews, 51 PRs, 24 pushes in 2 years 6 months
Contributions summary:Hongyu primarily contributed to the back-end logic and SQL query validation aspects of the Apache Calcite project. Their work included implementing support for new SQL features like `CREATE TABLE ... LIKE` and the `MERGE` statement, as well as addressing issues related to specific SQL dialects like MySQL and Spark SQL. The user also added new functions, such as `CODE_POINTS_TO_BYTES`, `CODE_POINTS_TO_STRING`, and `TO_CODE_POINTS`, which enhanced the project's string handling capabilities. These changes demonstrate a focus on expanding Calcite's SQL support and functionality.
Contributions:11 PRs, 196 pushes, 28 branches in 8 months
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.