veyepar: Flexing SQLAlchemy's Relational Power

Hi user

Admin Login:

Name: Flexing SQLAlchemy's Relational Power
--client psf --show pycon_2012 --room E2 752 --force
Prev: 6 The Journey to Give Every Scientist a Supercomputer
Next: 6 Hand Coded Applications with SQLAlchemy

show more...

Author(s):	Brandon Rhodes
Location	Track III (E2)
Date	mar Sat 10	Days Raw Files
Start	11:05	First Raw Start	10:59
Duration	00:40:00	Offset	0:05:10
End	11:45	Last Raw End	12:34
Chapters	00:00
Total cuts_time	28 min.

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

final audio

assets release.pdf Flexing_SQLAlchemys_Relational_Power.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:	How do you take the big step from casual SQLAlchemy user, who treats your database as a mysterious object store, to advanced power user, who optimizes critical queries, plans indexing and migrations, and generates efficient reports? This talk will teach you how databases think; why humanity invented the Relational Algebra; and how SQLAlchemy grants you access to relational power. 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="BrandonRhodes" /><ns0:id>http://gdata.youtube.com/feeds/api/videos/399c-ycBvo4</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">Brandon Rhodes How do you take the big step from casual SQLAlchemy user, who treats your database as a mysterious object store, to advanced power user, who optimizes critical queries, plans indexing and migrations, and generates efficient reports? Th</ns0:content><ns0:updated>2012-03-12T04:42:00.000Z</ns0:updated><ns0:published>2012-03-12T04:42:00.000Z</ns0:published><ns1:comments><ns1:feedLink countHint="0" href="https://gdata.youtube.com/feeds/api/videos/399c-ycBvo4/comments?client=ndv" rel="http://gdata.youtube.com/schemas/2007#comments" /></ns1:comments><ns2:group><ns2:keywords>psf, python pycon pycon2012, pycon_2012, BrandonRhodes</ns2:keywords><ns2:description type="plain">Brandon Rhodes How do you take the big step from casual SQLAlchemy user, who treats your database as a mysterious object store, to advanced power user, who optimizes critical queries, plans indexing and migrations, and generates efficient reports? Th</ns2:description><ns2:title type="plain">Flexing SQLAlchemy's Relational Power</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/399c-ycBvo4?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/399c-ycBvo4/0.jpg" width="480" /><ns2:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/399c-ycBvo4/1.jpg" width="120" /><ns2:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/399c-ycBvo4/2.jpg" width="120" /><ns2:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/399c-ycBvo4/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">BrandonRhodes</ns2:category><ns2:player url="https://www.youtube.com/watch?v=399c-ycBvo4&feature=youtube_gdata_player" /></ns2:group><ns0:title type="text">Flexing SQLAlchemy's Relational Power</ns0:title><ns4:control><ns4:draft>yes</ns4:draft><ns3:state name="processing" /></ns4:control><ns0:link href="https://www.youtube.com/watch?v=399c-ycBvo4&feature=youtube_gdata" rel="alternate" type="text/html" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/399c-ycBvo4/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/399c-ycBvo4/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/399c-ycBvo4/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/399c-ycBvo4/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/399c-ycBvo4?client=ndv" rel="self" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/users/nextdayvideo/uploads/399c-ycBvo4?client=ndv" rel="edit" type="application/atom+xml" /></ns0:entry> production notes

2012-03-10/10:59:50.dv Apply: 10:59:50 - 11:08:07 ( 00:08:17 ) S: 10:59:50 - E: 11:08:07 D: 00:08:17 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/E2/2012-03-10/10:59:50.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	10:59:50		seconds: 0.0 Wall: 10:59:50
Duration	00:08:17
	11:08:07		seconds: 0.0 Wall: 10:59:50
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-10/11:08:08.dv Apply: 11:08:08 - 11:36:46 ( 00:28:38 ) S: 11:08:08 - E: 11:36:46 D: 00:28:38 show more...

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

	Raw File	Cut List
	11:08:08		seconds: 0.0 Wall: 11:08:08
Duration	00:28:38
	11:36:46		seconds: 0.0 Wall: 11:08:08
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-10/11:36:47.dv Apply: 11:36:47 - 11:39:53 ( 00:03:06 ) S: 11:36:47 - E: 11:39:53 D: 00:03:06 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/E2/2012-03-10/11:36:47.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:36:47		seconds: 0.0 Wall: 11:36:47
Duration	00:03:06
	11:39:53		seconds: 0.0 Wall: 11:36:47
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-10/11:41:37.dv Apply: 11:41:37 - 11:43:15 ( 00:01:38 ) S: 11:41:37 - E: 11:43:15 D: 00:01:38 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/E2/2012-03-10/11:41:37.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:41:37		seconds: 0.0 Wall: 11:41:37
Duration	00:01:38
	11:43:15		seconds: 0.0 Wall: 11:41:37
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-10/11:44:38.dv Apply: 11:44:38 - 12:34:43 ( 00:50:05 ) S: 11:44:38 - E: 12:34:43 D: 00:50:05 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/E2/2012-03-10/11:44:38.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:44:38		seconds: 0.0 Wall: 11:44:38
Duration	00:50:05
	12:34:43		seconds: 0.0 Wall: 11:44:38
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-10/10:59:50.dv
audio viz

audio viz

2012-03-10/11:08:08.dv
audio viz

audio viz

2012-03-10/11:36:47.dv
audio viz

audio viz

2012-03-10/11:41:37.dv
audio viz

audio viz

2012-03-10/11:44:38.dv
audio viz

audio viz

Veyepar Video Eyeball Processor and Review