Topics

• SQL indexes: what, why and how
  By: Chris Foresman
  Experience Level: Novice
  Length: 10 Minutes
  Description:

  A brief overview of what SQL indexes are, why you need them, and how to add them (using SQL or Django code).

• PyWeek24 - team development
  By: Michael Tamillow
  Experience Level: Advanced
  Length: 30 Minutes
  Description:

  Unicorn Markets has come out with another game. The quality and purpose of this game is a level beyond that of PyWeek 23. I will talk about the development process of working on a team in a short 1 week span, the actual game, the learning experience about the design and architecture of code. And if there is nothing left to discuss, we will just play and investigate video games from the contest. If you want to play the game before just run `>git clone https://github.com/UnicornMarkets/Nightmarotony.git' cd into the directory and run: '>python run_game.py' you will need pygames and python, 2 or 3 should work. And because I forgot to remove the dependency, Python Image Library (PIL) - though it is not necessary for the game.

• Invisible Lightning: The Accidental Discovery that Brought Us Computer Science and Good Sound
  By: Rob Roy Campbell
  Experience Level: Novice
  Length: 30 Minutes
  Description:

  In order to explain the problem I had that prompted my interest in Python (and led me to become a Chipy mentee), I'm going to briefly summarize the history of the electronics industry, beginning with the invention of the light bulb in 1880, to the triode vacuum tube in 1906, to early tube-based digital computers, to the invention of the transistor, to the development of the integrated circuit, to the microprocessor, and finally to the present day. Then I will explain that I use vacuum tubes in modern audio products, and will explain how I overcame a common problem with tubes using Python and accomplished a level of precision that my competitors said was not possible. Unlike most Chipy presentations, mine will focus less on my project and more on the history, with extensive images, video clips, and diagrams of a century of development in the field of electronics and computers. I think I can make it fun and interesting for all.