Completed
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…
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
How Did You Do That or How a Non-Developer Snuck Python Into a Large Organization
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Hobby developer With 7 years professional experience... in PHP!
- 3 Business Developer
- 4 "Don't ask for forgiveness. Ask for a raise" - Drunk EuroPython Attendee
- 5 Banking IT
- 6 Limit all lines to a maximum of 79 characters.
- 7 Smuggling Python A case study
- 8 Assignment: Test cash flows, bookkeepings, interest calculation and risk reporting for 200k+ loans
- 9 Oh, by the way ALMOST NO AUTOMATIC TESTING
- 10 Get some data
- 11 20 SQL queries Don't blame me... I didn't design the indexing
- 12 Format data
- 13 So... What does a lazy python programmer do?
- 14 No administrator rights on work pc
- 15 Solution: Portable Python! Hint: Install it while your manager isn't looking
- 16 DB2? Is there even a driver for that?
- 17 Getting data into .xlsx format
- 18 Input
- 19 txt file Hint: Make a simple syntax
- 20 Distribution (and avoiding detection)
- 21 Solution: py2exe Hint: Put the output in a dist/folder and include a bat file for easy launching, Distribute as a zip file
- 22 Problems solved Time to get coding
- 23 Low hanging fruit Step 1 and Step 2
- 24 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…
- 25 Conversion Tools Made conversions from old to new system a one man job. Used to take 2-3 people. On weekend overtime pay.
- 26 Routing Checker
- 27 Do it for yourself And don't tell anyone
- 28 Do it on your own time
- 29 Go for the low-hanging fruit And don't over-reach
- 30 Measure the value
- 31 No really. Measure!
- 32 Get grass-level support Involve your colleagues
- 33 Be patient ... and honest
