Justin Swanhart
Senior Platform Engineer (Databases)
Johnstown, Pennsylvania, United States
Summary
👤
SeniorJustin Swanhart is a Senior Platform Engineer specialized in databases with 15+ years of experience scaling MySQL for companies from Yahoo and Etsy to startups he founded. As founder of LeapDB and chief engineer of WarpSQL, he built columnar storage and materialized-view capabilities directly inside MySQL to eliminate data latency and keep data local for customers. A prolific open-source contributor, his projects include WarpSQL, ShardQuery, Flexviews and the widely used PHP-SQL-Parser, reflecting deep expertise in query processing and MPP-style tooling. He combines hands-on engineering with public speaking and consulting in the MySQL community, bringing both product-facing SaaS experience and low-level database internals knowledge. Based in Johnstown, PA, Justin focuses on making databases faster and more operationally efficient at scale.
15 years of coding experience
20 years of employment as a software developer
Stackoverflow
1,846reputation
445kreached
79answers
0questions
mysql
top-5%
Github Skills (19)
sql-parser10
mysql10
php10
parsing10
sql10
database-administration9
database-design9
window-functions9
database6
left-join6
synchronization6
materialized-view6
sharding6
multithreading6
data-structures5
Programming languages (6)
Github contributions (5)
greenlion/swanhart-tools
Sep 2013 - Aug 2022
Swanhart Toolkit - MySQL tools for MPP query, Materialized Views, Async queries, and JSON UDF
Role in this project:
Back-end Developer & Database Engineer
Back-end Developer & Database EngineerContributions:169 commits, 16 PRs, 94 pushes in 9 years
Contributions summary:Justin primarily worked on the back-end of the project, specifically focusing on the MySQL database tools within the Swanhart Toolkit. Their contributions include bug fixes to arithmetic UDFs, specifically addressing division-by-zero errors and length issues. The user also implemented and improved support for various SQL features such as CREATE TABLE .. SELECT, INSERT, REPLACE, and window functions within the shard-query module. They demonstrated proficiency in SQL and related technologies.
materialized-viewsmppquerymysqlsql
greenlion/PHP-SQL-Parser
Oct 2010 - Feb 2022
A pure PHP SQL (non validating) parser w/ focus on MySQL dialect of SQL
Role in this project:Back-end Developer
Back-end DeveloperContributions:9 releases, 124 commits, 105 PRs in 11 years 5 months
Contributions summary:Justin contributed to the development of a PHP SQL parser focused on the MySQL dialect. The commits primarily involve improvements to the parsing logic, including fixing issues with alias handling and parsing of special characters. The user made several revisions to the code, including bug fixes, optimization, and new features to accurately parse various SQL syntax elements. These efforts appear to enhance the parser's ability to handle different SQL constructs within the targeted MySQL context.
sql-parsersql-builderdialectsqlservermysql
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.