veyepar: Putting Python in PostgreSQL

Hi user

Admin Login:

Name: Putting Python in PostgreSQL
--client psf --show pycon_2012 --room E2 727 --force
Prev: 6 Apache Cassandra and Python
Next: 6 Sage: Open Source Math in Python

show more...

Author(s):	Frank Wiles
Location	Track III (E2)
Date	mar Fri 09	Days Raw Files
Start	March 9, 2012, 3:20 p.m.	First Raw Start	March 8, 2012, 3:12 p.m.
Duration	00:45:00	Offset	1 day, 0:07:30
End	March 9, 2012, 4:05 p.m.	Last Raw End	March 8, 2012, 4:39 p.m.
Chapters	00:00
Total cuts_time	35 min.

http://us.pycon.org/2012/schedule/presentation/77/
raw-playlist raw-mp4-playlist encoded-files-playlist host public mp4 svg png

final audio

assets release.pdf Putting_Python_in_PostgreSQL.json
logs
Admin: episode episode list cut list raw files day marks day marks day image_files

State:
Locked:	clear this to unlock
Locked by:	user/process that locked.
Start:	initially scheduled time from master, adjusted to match reality
Duration:	length in hh:mm:ss
Name:	Video Title (shows in video search results)
Emails:	email(s) of the presenter(s)
Released:	has someone authorised pubication
Normalise:
Channelcopy:	m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:	filename.png
Description:	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. markdown
Comment:	<?xml version='1.0' encoding='UTF-8'?> <ns0:entry xmlns:ns0="http://www.w3.org/2005/Atom" xmlns:ns1="http://schemas.google.com/g/2005" xmlns:ns2="http://search.yahoo.com/mrss/" xmlns:ns3="http://gdata.youtube.com/schemas/2007" xmlns:ns4="http://purl.org/atom/app#"><ns0:category scheme="http://schemas.google.com/g/2005#kind" term="http://gdata.youtube.com/schemas/2007#video" /><ns0:category label="Education" scheme="http://gdata.youtube.com/schemas/2007/categories.cat" term="Education" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="psf" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="python pycon pycon2012" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="pycon_2012" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="FrankWiles" /><ns0:id>http://gdata.youtube.com/feeds/api/videos/3dMq_3UUPxg</ns0:id><ns0:author><ns0:name>NextDayVideo</ns0:name><ns0:uri>https://gdata.youtube.com/feeds/api/users/NextDayVideo</ns0:uri></ns0:author><ns0:content type="text">Frank Wiles 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</ns0:content><ns0:updated>2012-03-12T07:23:32.000Z</ns0:updated><ns0:published>2012-03-12T07:23:32.000Z</ns0:published><ns1:comments><ns1:feedLink countHint="0" href="https://gdata.youtube.com/feeds/api/videos/3dMq_3UUPxg/comments?client=ndv" rel="http://gdata.youtube.com/schemas/2007#comments" /></ns1:comments><ns2:group><ns2:keywords>psf, python pycon pycon2012, pycon_2012, FrankWiles</ns2:keywords><ns2:description type="plain">Frank Wiles 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</ns2:description><ns2:title type="plain">Putting Python in PostgreSQL</ns2:title><ns3:duration seconds="0" /><ns2:content duration="0" expression="full" isDefault="true" medium="video" type="application/x-shockwave-flash" url="https://www.youtube.com/v/3dMq_3UUPxg?version=3&f=user_uploads&c=ndv&d=Aarb2r5skm2_yNTuKEinXdAO88HsQjpE1a8d1GxQnGDm&app=youtube_gdata" ns3:format="5" /><ns2:thumbnail height="360" time="00:00:00" url="http://i.ytimg.com/vi/3dMq_3UUPxg/0.jpg" width="480" /><ns2:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/3dMq_3UUPxg/1.jpg" width="120" /><ns2:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/3dMq_3UUPxg/2.jpg" width="120" /><ns2:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/3dMq_3UUPxg/3.jpg" width="120" /><ns2:category label="Education" scheme="http://gdata.youtube.com/schemas/2007/categories.cat">Education</ns2:category><ns2:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">psf</ns2:category><ns2:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">python pycon pycon2012</ns2:category><ns2:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">pycon_2012</ns2:category><ns2:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">FrankWiles</ns2:category><ns2:player url="https://www.youtube.com/watch?v=3dMq_3UUPxg&feature=youtube_gdata_player" /></ns2:group><ns0:title type="text">Putting Python in PostgreSQL</ns0:title><ns4:control><ns4:draft>yes</ns4:draft><ns3:state name="processing" /></ns4:control><ns0:link href="https://www.youtube.com/watch?v=3dMq_3UUPxg&feature=youtube_gdata" rel="alternate" type="text/html" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/3dMq_3UUPxg/responses?client=ndv" rel="http://gdata.youtube.com/schemas/2007#video.responses" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/3dMq_3UUPxg/ratings?client=ndv" rel="http://gdata.youtube.com/schemas/2007#video.ratings" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/3dMq_3UUPxg/complaints?client=ndv" rel="http://gdata.youtube.com/schemas/2007#video.complaints" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/3dMq_3UUPxg/related?client=ndv" rel="http://gdata.youtube.com/schemas/2007#video.related" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/users/nextdayvideo/uploads/3dMq_3UUPxg?client=ndv" rel="self" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/users/nextdayvideo/uploads/3dMq_3UUPxg?client=ndv" rel="edit" type="application/atom+xml" /></ns0:entry> production notes

2012-03-08/15:12:30.dv Apply: 15:12:30 - 15:20:11 ( 00:07:41 ) S: 15:12:30 - E: 15:20:11 D: 00:07:41 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/E2/2012-03-08/15:12:30.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	March 8, 2012, 3:12 p.m.		seconds: 0.0 Wall: 15:12:30
Duration	00:07:41
	March 8, 2012, 3:20 p.m.		seconds: 0.0 Wall: 15:12:30
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-08/15:18:57.dv Apply: 15:18:57 - 16:37:49 ( 01:18:52 ) S: 15:18:57 - E: 16:37:49 D: 01:18:52 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/E2/2012-03-08/15:18:57.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	March 8, 2012, 3:18 p.m.		seconds: 0.0 Wall: 15:18:57
Duration	01:18:52
	March 8, 2012, 4:37 p.m.		seconds: 0.0 Wall: 15:18:57
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-08/15:20:12.dv Apply: 15:20:12 - 15:55:45 ( 00:35:33 ) S: 15:20:12 - E: 15:55:45 D: 00:35:33 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/E2/2012-03-08/15:20:12.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	March 8, 2012, 3:20 p.m.		seconds: 0.0 Wall: 15:20:12
Duration	00:35:33
	March 8, 2012, 3:55 p.m.		seconds: 0.0 Wall: 15:20:12
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-08/15:55:46.dv Apply: 15:55:46 - 16:39:39 ( 00:43:53 ) S: 15:55:46 - E: 16:39:39 D: 00:43:53 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/E2/2012-03-08/15:55:46.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	March 8, 2012, 3:55 p.m.		seconds: 0.0 Wall: 15:55:46
Duration	00:43:53
	March 8, 2012, 4:39 p.m.		seconds: 0.0 Wall: 15:55:46
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

Rf filename:	root is .../show/dv/location/, example: 2013-03-13/13:13:30.dv
Sequence:
get this:	check and save to add this

2012-03-08/15:12:30.dv
audio viz

audio viz

2012-03-08/15:18:57.dv
audio viz

audio viz

2012-03-08/15:20:12.dv
audio viz

audio viz

2012-03-08/15:55:46.dv
audio viz

audio viz

Veyepar Video Eyeball Processor and Review