Profile

Cover photo
John Mitchell
Works at John Tells All
Attended University of Maryland Baltimore County
Lives in Venice, CA
125 followers|97,784 views
AboutPostsPhotosYouTube

Stream

John Mitchell

Shared publicly  - 
 
calling programs/REST URLs from Postgres
Postgres already has good JSON support. It can copy to/from external files, which is great for easily exporting a table or three, or importing data from a CSV file.  As of 9.3, it can copy from a program or URL ! Example: # CREATE TABLE worldbank_json (data...
1
Add a comment...

John Mitchell

Shared publicly  - 
 
slides: Practical Python Testing
The talk at The Black Tux last night went really well!  Here are the slides: - Practical Python Testing (google docs) and me:
2
Add a comment...

John Mitchell

Shared publicly  - 
 
talk: Practical Python Testing
I'm speaking at this month's SoCal Python Meetup!  I'll post slides and notes here soon. http://www.meetup.com/socalpython/events/224586741/
1
Add a comment...

John Mitchell

Shared publicly  - 
1
Ian Douglas's profile photoJohn Mitchell's profile photo
2 comments
 
thanks Ian!  Raw Selenium can be kind of rough, Splinter sounds easier -- thanks for the ref.

Internally we might be adding or switching to Robot Framework.  Our QA guy Rene -- not a programmer -- was able to get it installed and running real, business-valuable tests pretty easily. Check it out!
Add a comment...

John Mitchell

Shared publicly  - 
 
DevOps in Southern California
If you're a networking/DevOps person in Southern California, here is a meetup I recommend: UUASC - on Meetup The UNIX Users Association of Southern California is mostly about DevOps and system administration.  The last talk I attended was on Google's Kubern...
1
Add a comment...

John Mitchell

Shared publicly  - 
 
Testing Patterns
Testing code is hard. As a developer, I want to write cool code to solve interesting, real-world problems. I don't want to be "smart" and write "smart tests" that are inscrutable, rather than spending time on writing more (feature) code. Here an article tha...
1
Add a comment...

John Mitchell

Shared publicly  - 
 
<3
1
Add a comment...
Have him in circles
125 people
mike mitchell's profile photo
petter mate's profile photo
Rob Maigret's profile photo
Kyle Partridge's profile photo
Ian Douglas's profile photo
Stella Louise's profile photo
David Oleynik's profile photo
José Alves's profile photo
Loren Brindze's profile photo

John Mitchell

Shared publicly  - 
 
Learning Python Programming
I give a number of talks on Python and other subjects. The two universal questions I get are: - how can I... learn Python? get better at Python? learn programming? - which web framework should I use? There's a number of resources for learning programming wi...
1
Add a comment...

John Mitchell

Shared publicly  - 
 
Django: speed up Sqlite 1000x!
I'm working on a project analyzing large code bases. For just messing around, I'm using Sqlite. A strange thing happened when updating ~10,000 rows: they were really slow! Sqlite was updating about 10 records a second. It turns out Sqlite correctly cares ab...
1
Add a comment...

John Mitchell

Shared publicly  - 
 
tip: easily run Postgres administration commands
TIP:  on Linux it helps to be the Postgres user to do administration stuff with the database.  Either do some configuration twiddling, or run commands as the postgres user: sudo su c 'dropdb mydb' postgres In Ansible, this is:   name: database -- zap data...
1
Add a comment...

John Mitchell

Shared publicly  - 
 
TIP: tweak number of Gunicorn workers
Count number of Gunicorn workers $ pgrep gunicorn.*work | wc -l 5 Add another worker by signaling the Gunicorn master $ sudo pkill -TTIN  gunicorn.*mast Verify another worker has appeared $ pgrep gunicorn.*work | wc -l 6 Decrease the number of workers, veri...
1
Ian Douglas's profile photoJohn Mitchell's profile photo
2 comments
 
it's unclear if "more workers" means cloning an old worker (old code), or loading a new worker from scratch (new code). If you find out let me know!

Our production server has Nginx and Gunicorn. I asked The Interwebs about how many workers for each one, and they said "2N+1", but that is for Nginx or Gunicorn alone, not necessarily together. Fortunately apachebench is working well for us, so given enough coffee all bugs are shallow. ;)

cheers Ian
Add a comment...

John Mitchell

Shared publicly  - 
 
networking with the Ant-ernet
Harvester ants and the Internet protocol TCP both have the same goal: maximize transfer of bits/food in as efficient a manner as possible. It turns out they use the same protocol! http://priceonomics.com/the-independent-discovery-of-tcpip-by-ants/
1
Robert Banz's profile photo
 
Except that harvester ants don't have to deal with buffer bloat.
Add a comment...
People
Have him in circles
125 people
mike mitchell's profile photo
petter mate's profile photo
Rob Maigret's profile photo
Kyle Partridge's profile photo
Ian Douglas's profile photo
Stella Louise's profile photo
David Oleynik's profile photo
José Alves's profile photo
Loren Brindze's profile photo
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Venice, CA
Previously
Baltimore,MD - Dallas,TX - San Antonio,TX
Links
Other profiles
Contributor to
Work
Occupation
Trainer and Consultant
Skills
Asynchronous programming, Django, Python, DevOps
Employment
  • John Tells All
    2014 - present
  • Enventum
    Senior Programmer, 2012 - 2013
  • SendGrid
    Senior Programmer, 4 - 2013
  • Enventum
    Chief Technical Officer, 2013 - 2014
Education
  • University of Maryland Baltimore County
    Computer Science
Basic Information
Gender
Male
Apps with Google+ Sign-in
  • Fallout Shelter