Putting Python in PostgreSQL

A session at PyCon US 2012

Friday 9th March, 2012

3:20pm to 4:05pm (PST)

PostgreSQL is pretty powerful all on it's own, but did you know you can use Python as a stored procedure language? Not only does using a familiar language make development easier, but you get the power of the standard library and PyPi to boot. Come learn the ins and outs of putting Python in your DB.

Pushing logic in your database can be a blessing or a curse. While these techniques aren't appropriate for most users in most situations, it's good to know what kind of power you have at your disposal with PL/Python if the need ever arises.

Learn about how to: - Use triggers to off load data processing tasks - Fire off email and log alerts based on what is happening in your tables - Create more granular and detailed constraints such as verifying email address or credit card checksums at the database level - Replace batch jobs with in database triggers - Learn when and when NOT to use these techniques - Debugging techniques - Security concerns

About the speaker

This person is speaking at this event.
Frank Wiles

Open Source Consultant specializing in scaling and performance. Python, Django, PostgreSQL. President and Founder of @revsys bio from Twitter

Next session in E2

4:40pm Sage: Open Source Math in Python by Christopher Swenson

Coverage of this session

Sign in to add slides, notes or videos to this session

Tell your friends!

When

Time 3:20pm4:05pm PST

Date Fri 9th March 2012

Short URL

lanyrd.com/spcbb

Official session page

us.pycon.org/…e/presentation/77/

View the schedule

Share

Topics

See something wrong?

Report an issue with this session