Discover how a non-developer successfully introduced Python into a large organization in this EuroPython 2012 conference talk. Learn from Michael Pedersen's experience as a business developer with a PHP background who leveraged Python to solve complex banking IT challenges. Explore strategies for implementing Python without administrative rights, including using Portable Python and py2exe for distribution. Gain insights on optimizing SQL queries, utilizing threading and multiprocessing, and creating conversion tools to streamline workflows. Understand the importance of focusing on low-hanging fruit, measuring value, and building grassroots support among colleagues. Pick up valuable tips on navigating organizational constraints and demonstrating the benefits of Python in a corporate environment.
How Did You Do That or How a Non-Developer Snuck Python Into a Large Organization
EuroPython Conference via YouTube
Overview
Syllabus
Intro
Hobby developer With 7 years professional experience... in PHP!
Business Developer
"Don't ask for forgiveness. Ask for a raise" - Drunk EuroPython Attendee
Banking IT
Limit all lines to a maximum of 79 characters.
Smuggling Python A case study
Assignment: Test cash flows, bookkeepings, interest calculation and risk reporting for 200k+ loans
Oh, by the way ALMOST NO AUTOMATIC TESTING
Get some data
20 SQL queries Don't blame me... I didn't design the indexing
Format data
So... What does a lazy python programmer do?
No administrator rights on work pc
Solution: Portable Python! Hint: Install it while your manager isn't looking
DB2? Is there even a driver for that?
Getting data into .xlsx format
Input
txt file Hint: Make a simple syntax
Distribution (and avoiding detection)
Solution: py2exe Hint: Put the output in a dist/folder and include a bat file for easy launching, Distribute as a zip file
Problems solved Time to get coding
Low hanging fruit Step 1 and Step 2
Queries are hugely expensive • Run as few as possible • Hit the right indexes this gets nasty • Use threading to run queries in parallel • Multiprocessing py2exe is a no-go Schedule expensive queries first
Conversion Tools Made conversions from old to new system a one man job. Used to take 2-3 people. On weekend overtime pay.
Routing Checker
Do it for yourself And don't tell anyone
Do it on your own time
Go for the low-hanging fruit And don't over-reach
Measure the value
No really. Measure!
Get grass-level support Involve your colleagues
Be patient ... and honest
Taught by
EuroPython Conference
