For August's presentation night on 8/28, we will stray from Python technologies a bit. We will learn about how the database layer works to help you to be more well rounded in your programming.
To many application developers the database is a black box. You expect to be able to put data into your database, have it to stay there, and get it out when you query it... hopefully in a performant manner. When its not performant enough the two options are usually add some indexes or throw some hardware at it. We'll walk through a bit of a clearer guide of how you can understand how database is doing from a 30,000 foot perspective as well as analyze specific problematic queries and how to tune them. In particular we'll cover:
* Postgres Caching
* Postgres Indexing
* Explain Plans
* Some packages that can help
Craig Kerstiens works at Heroku and has worn a variety of hats from engineering to product management, as well as launching their support for Python. He currently runs product for the Heroku Postgres team. He has been working with both Python and Postgres off and on for many years and curates a variety of Postgres channels today such as http://postgresguide.com and postgresweekly. He also blogs about Python at http://craigkerstiens.com
6:15p - Check-in and mingle, with Pizza and Beer provided by our generous sponsor Yelp!
7:00p - Welcome and announcements
7:10p - 3-4 Lightning Talks (5 minutes each)
7:30p - Featured Talk
8:15p - Q & A and more mingling, ping pong, pool
9:30p - Doors close. Late owls continue on to Thirsty Bear
*Please take note of the important check-in details at Yelp*
*** important logistics***
If you've encountered something cool recently, please submit a topic for your lightning talk (http://goo.gl/9LM4ct) when you RSVP for the event. Please note that recruiting pitches are not acceptable as lightning talks. Don't know what lightning talks are? Learn more: http://en.wikipedia.org/wiki/Lightning_Talk
Doors will open at 6:15pm to allow enough time for the check-in process.
Please update the name on your account to reflect your FIRST NAME and LAST NAME. Yelp Security and Hy will be checking IDs at the door. *Please note: You WILL ONLY be allowed into the event if we have your first and last name (that matches the name on your ID) prior to the event.
Since alcohol will be served at the event, we ask that any underage attendees RSVP directly to the meetup host.
If you will be bringing a guest, please provide us with their first and last name as well.
Waiting list folks will be allowed into the event AFTER we admit all confirmed attendees.
Yelp is generously providing pizza, drinks, and beer in addition to their venue space. Please respect and abide by the event terms/guidelines: YELP EVENT GUIDELINES (https://marakana.com/static/community/2012%20Yelp%20Property%20Event%20Terms.pdf).
As usual, looking forward to meeting you and feel free to ping me with questions or suggestions -