Charles Leifer
Principal Engineer at Paperless Pipeline
Topeka Metropolitan Area United States
Summary
🤩
Rockstar🎓
Top SchoolCharles Leifer is a Principal Engineer with 16 years of experience building developer-focused software and running a one-person engineering organization for a production SaaS serving 1,800+ real estate brokerages. He is the author of popular Python projects including peewee, huey, and sqlite-web (22K+ combined GitHub stars) and co-creator of Read the Docs, reflecting deep expertise in developer tooling, databases, and backend systems. At Paperless Pipeline he owns the full lifecycle—architecture, infrastructure, AI integration, and operations—and recently shipped production AI features like a prompt-evaluation harness, structured data extraction from contracts, and an AI document review workflow. His background includes large migrations (Python 2->3), PDF processing and document-signing platforms, and high-throughput monitoring tools for financial markets, showing a knack for pragmatic, reliability-focused engineering. He also writes about software internals and databases, and enjoys discussing the realities of running a SaaS and building production AI systems.
16 years of coding experience
11 years of employment as a software developer
University of Kansas
Github Skills (30)
api-rest10
sqlite10
sphinx-doc10
admin10
python10
mysql10
api-design10
restful-api10
django10
tsql10
databases10
database-administration10
flask-ask10
sql10
database-design10
Programming languages (15)
Github contributions (5)
coleifer/peewee
Oct 2010 - Jan 2023
a small, expressive orm -- supports postgresql, mysql, sqlite, now with asyncio
Role in this project:
Back-end Developer & Database Engineer
Back-end Developer & Database EngineerContributions:118 releases, 3927 commits, 348 PRs in 12 years 4 months
Contributions summary:Charles focused on enhancing the encode/decode functionalities within a SQLite C extension to improve data handling. They worked on integrating and testing MySQL database support with the codebase, including testing operations and the utilization of MySQL connector. Further contributions involved the implementation of features like automatic constraint generation and a new method for table truncation. They also made various bug fixes related to subquery handling and ensuring proper use of column names.
asynciomysqlormpostgresqlsqlite
coleifer/sqlite-web
Nov 2014 - Dec 2022
Web-based SQLite database browser written in Python
Role in this project:Back-end Developer
Back-end DeveloperContributions:101 commits, 32 PRs, 139 pushes in 8 years 2 months
Contributions summary:Charles primarily contributed to the back-end functionality of the web-based SQLite database browser. Their work involved implementing features for database schema management, including the ability to rename columns, drop triggers, and manage indexes. They also addressed issues related to data display and the overall user experience, such as adding a permalink to the query page. Furthermore, they made enhancements to the codebase to improve Py3 compatibility and overall code cleanup.
pythonsqlite-databasesqliteflaskdatabase
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.