Constantine Peresypkin
Founder And CTO at Airfold
San Francisco, California, United States
Summary
👤
Senior🎓
Top SchoolConstantine Peresypkin is a founder and CTO with 14 years of engineering leadership experience building secure sandboxing, isolation, and data platforms from the hypervisor up through cloud databases. Based in San Francisco, he has repeatedly turned research-grade isolation tech into production products—ZeroVM, ClickHouse-based CaspianDB, and now Airfold—while leading engineering teams and shaping architecture, security, and operational tooling. He combines low-level systems expertise (live hypervisor patching, gVisor integration) with data platform work (real-time apps, SQL parsing and transpilation contributions to sqlglot including ClickHouse features). Known for contributing back to upstream projects and for pragmatic security-first designs, he also has a track record of enabling legacy systems (e.g., modern TensorFlow on old Linux) to run modern workloads.
14 years of coding experience
20 years of employment as a software developer
B.Sc. Aerospace Engineering, B.Sc. Aerospace Engineering at Technion - Israel Institute of Technology
English, Hebrew, Japanese
Github Skills (11)
parserator10
parser10
sql10
python10
transpiler10
clickhouse10
postgresql7
mysql7
postgrest7
bigquery6
duckdb6
Programming languages (21)
Github contributions (5)
tobymao/sqlglot
May 2023 - Feb 2025
Python SQL Parser and Transpiler
Role in this project:
Back-end Developer
Back-end DeveloperContributions:54 reviews, 17 PRs, 110 comments in 1 year 9 months
Contributions summary:Constantine primarily contributed to the `sqlglot` repository by implementing and refining SQL parsing and transpilation capabilities for various SQL dialects, with a strong focus on ClickHouse. They addressed join type/kind ordering issues, improved support for the `USING` clause, and added features like `CREATE DICTIONARY` support, enhancing the parser's functionality. Furthermore, the user incorporated aggregate function parsing and data type support, solidifying the project's ability to handle a wider range of SQL constructs.
pythontranslationtsqlparserredshift
pkit/duckdb
Jun 2021 - Feb 2024
DuckDB is an in-process SQL OLAP Database Management System
Contributions:1 PR, 38 pushes, 10 branches in 2 years 8 months
management-systemduckdbmysqldatabase-management-systemsql
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.