r/PythonLearning • u/ThriVelo • 2d ago
built a full multi-user CRM using zero third-party dependencies, thoughts?
I challenged myself to build a production-ready, multi-user CRM for small agencies using strictly the Python 3.9+ standard library; zero pip packages, zero frameworks, and zero frontend build steps.
49 Second Walkthrough: https://www.loom.com/share/ee9b8507bf6c4811b6f2b6b267e90547
A few interesting standard-library implementation details:
Auth & Security: Password hashing with hashlib.scrypt + per-user random salts and hmac.compare_digest, account lockout after failed attempts, and RFC-compliant TOTP 2FA + backup codes written with hmac, struct, and time.
Database Layer: Raw sqlite3 running in WAL mode with foreign keys enforced, integer-cent currency storage (value_cents) using decimal.Decimal to avoid float rounding bugs, automated schema migrations via PRAGMA table_info, and a 200-row audit trail.
CRM Features: Multi-pipeline Kanban boards, stage-duration tracking (stage_at) to flag stale deals, duplicate contact merging, CSV import/export, role/field-level visibility masking (HIDEABLE fields), outbound webhooks, and automated daily .db backups.
Would love feedback from other Python devs on what else you'd expect in a zero-dependency internal tool!
Thank you ahead, for your time!
1
u/riklaunim 2d ago
No code, so hard to tell. "No dependencies" is not always beneficial - you had to implement a lot of features already handled by well-tested and proven libraries, you have additional maintenance cost and I doubt your test coverage is as good as for those existing projects.
1
u/ThriVelo 2d ago
That's completely fair! Using proven libraries definitely saves you from having to maintain everything yourself.
Honestly, I mostly just enjoyed the challenge of seeing how much I could build using plain Python, and I liked the idea that a small local shop could run it two years from now without packages breaking or needing constant updates.
I did write a full test suite for the login, permissions, and backups to keep it solid, though I hear you on keeping things simple so it doesn't become a headache to maintain. Thanks so much for the honest feedback!
2
u/riklaunim 2d ago
As a challenge, it's pretty neat ;)
eMudhra did require a quick update of pip and certifi... Pretty fun times.
2
u/ThriVelo 2d ago
Haha right? Half the fun is just seeing how far you can push it before you actually need to touch pip. Appreciate the chat man, have a great weekend!
2
u/notyboy01 1d ago
Using the standard library for all of that is genuinely unhinged behavior in the best way possible.