veyepar: SQL for Python Developers

Hi user

Admin Login:

Name: SQL for Python Developers
--client psf --show pycon_2012 --room H2 670 --force
Prev: (none, at start of list)
Next: 6 MongoDB and Python

show more...

Author(s):	Brandon Rhodes
Location	H2-Tutorials VII
Date	mar Wed 07	Days Raw Files
Start	09:00	First Raw Start	09:01
Duration	03:20:00	Offset	0:01:34
End	12:20	Last Raw End	12:31
Chapters	00:00 0:36:11 0:48:32 0:49:05 0:50:20 1:25:26 2:09:58 2:48:59
Total cuts_time	170 min.

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

final audio

assets release.pdf SQL_for_Python_Developers.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:	Relational databases are often the bread-and-butter of large-scale data storage, yet they are often poorly understood by Python programmers. Organizations even split programmers into SQL and front-end teams, each of which jealously guards its turf. These tutorials will take what you already know about Python programming, and advance into a new realm: SQL programming and database design. 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/Thd8yoBou7k</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 Relational databases are often the bread-and-butter of large-scale data storage, yet they are often poorly understood by Python programmers. Organizations even split programmers into SQL and front-end teams, each of which jealously gua</ns0:content><ns0:updated>2012-03-15T20:34:47.000Z</ns0:updated><ns0:published>2012-03-15T20:34:47.000Z</ns0:published><ns1:comments><ns1:feedLink countHint="0" href="https://gdata.youtube.com/feeds/api/videos/Thd8yoBou7k/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 Relational databases are often the bread-and-butter of large-scale data storage, yet they are often poorly understood by Python programmers. Organizations even split programmers into SQL and front-end teams, each of which jealously gua</ns2:description><ns2:title type="plain">SQL for Python Developers</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/Thd8yoBou7k?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/Thd8yoBou7k/0.jpg" width="480" /><ns2:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/Thd8yoBou7k/1.jpg" width="120" /><ns2:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/Thd8yoBou7k/2.jpg" width="120" /><ns2:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/Thd8yoBou7k/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=Thd8yoBou7k&feature=youtube_gdata_player" /></ns2:group><ns0:title type="text">SQL for Python Developers</ns0:title><ns4:control><ns4:draft>yes</ns4:draft><ns3:state name="processing" /></ns4:control><ns0:link href="https://www.youtube.com/watch?v=Thd8yoBou7k&feature=youtube_gdata" rel="alternate" type="text/html" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/Thd8yoBou7k/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/Thd8yoBou7k/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/Thd8yoBou7k/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/Thd8yoBou7k/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/Thd8yoBou7k?client=ndv" rel="self" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/users/nextdayvideo/uploads/Thd8yoBou7k?client=ndv" rel="edit" type="application/atom+xml" /></ns0:entry> production notes

2012-03-07/09:01:34.dv Apply: 09:01:34 - 09:02:17 ( 00:00:43 ) S: 09:01:34 - E: 09:02:17 D: 00:00:43 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/09:01:34.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	09:01:34		seconds: 0.0 Wall: 09:01:34
Duration	00:00:43
	09:02:17		seconds: 0.0 Wall: 09:01:34
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/09:02:18.dv Apply: 09:02:18 - 09:38:29 ( 00:36:11 ) S: 09:02:18 - E: 09:38:29 D: 00:36:11 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/09:02:18.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	09:02:18		seconds: 0.0 Wall: 09:02:18
Duration	00:36:11
	09:38:29		seconds: 0.0 Wall: 09:02:18
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/09:38:30.dv Apply: 09:38:30 - 09:47:06 ( 00:08:36 ) S: 09:38:30 - E: 09:47:06 D: 00:08:36 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/09:38:30.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	09:38:30		seconds: 0.0 Wall: 09:38:30
Duration	00:08:36
	09:47:06		seconds: 0.0 Wall: 09:38:30
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/09:47:07.dv Apply: 09:47:07 - 09:59:28 ( 00:12:21 ) S: 09:47:07 - E: 09:59:28 D: 00:12:21 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/09:47:07.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	09:47:07		seconds: 0.0 Wall: 09:47:07
Duration	00:12:21
	09:59:28		seconds: 0.0 Wall: 09:47:07
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/09:59:29.dv Apply: 10:05:11 - 10:05:44 ( 00:00:33 ) S: 09:59:29 - E: 10:05:44 D: 00:06:15 (Start: 5:42) show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/09:59:29.dv :start-time=0342.0 --audio-desync=0

	Raw File	Cut List
	09:59:29		seconds: 342.0 Wall: 10:05:11
Duration	00:06:15
	10:05:44		seconds: 0.0 Wall: 09:59:29
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/10:05:44.dv Apply: 10:05:44 - 10:06:59 ( 00:01:15 ) S: 10:05:44 - E: 10:06:59 D: 00:01:15 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/10:05:44.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	10:05:44		seconds: 0.0 Wall: 10:05:44
Duration	00:01:15
	10:06:59		seconds: 0.0 Wall: 10:05:44
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/10:07:00.dv Apply: 10:07:00 - 10:08:58 ( 00:01:58 ) S: 10:07:00 - E: 10:08:58 D: 00:01:58 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/10:07:00.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	10:07:00		seconds: 0.0 Wall: 10:07:00
Duration	00:01:58
	10:08:58		seconds: 0.0 Wall: 10:07:00
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/10:08:58.dv Apply: 10:08:58 - 10:44:04 ( 00:35:06 ) S: 10:08:58 - E: 10:44:04 D: 00:35:06 show more...

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

	Raw File	Cut List
	10:08:58		seconds: 0.0 Wall: 10:08:58
Duration	00:35:06
	10:44:04		seconds: 0.0 Wall: 10:08:58
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/10:44:05.dv Apply: 10:44:05 - 11:06:21 ( 00:22:16 ) S: 10:44:05 - E: 11:06:21 D: 00:22:16 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/10:44:05.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	10:44:05		seconds: 0.0 Wall: 10:44:05
Duration	00:22:16
	11:06:21		seconds: 0.0 Wall: 10:44:05
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/11:06:22.dv Apply: 11:06:22 - 11:50:54 ( 00:44:32 ) S: 11:06:22 - E: 11:50:54 D: 00:44:32 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/11:06:22.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:06:22		seconds: 0.0 Wall: 11:06:22
Duration	00:44:32
	11:50:54		seconds: 0.0 Wall: 11:06:22
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/11:50:56.dv Apply: 11:50:56 - 12:29:57 ( 00:39:01 ) S: 11:50:56 - E: 12:29:57 D: 00:39:01 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/11:50:56.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:50:56		seconds: 0.0 Wall: 11:50:56
Duration	00:39:01
	12:29:57		seconds: 0.0 Wall: 11:50:56
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-03-07/12:29:58.dv Apply: 12:29:58 - 12:31:36 ( 00:01:38 ) S: 12:29:58 - E: 12:31:36 D: 00:01:38 show more...

vlc ~/Videos/veyepar/psf/pycon_2012/dv/H2/2012-03-07/12:29:58.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	12:29:58		seconds: 0.0 Wall: 12:29:58
Duration	00:01:38
	12:31:36		seconds: 0.0 Wall: 12:29:58
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-07/09:01:34.dv
audio viz

audio viz

2012-03-07/09:02:18.dv
audio viz

audio viz

2012-03-07/09:38:30.dv
audio viz

audio viz

2012-03-07/09:47:07.dv
audio viz

audio viz

2012-03-07/09:59:29.dv
audio viz

audio viz

2012-03-07/10:05:44.dv
audio viz

audio viz

2012-03-07/10:07:00.dv
audio viz

audio viz

2012-03-07/10:08:58.dv
audio viz

audio viz

2012-03-07/10:44:05.dv
audio viz

audio viz

2012-03-07/11:06:22.dv
audio viz

audio viz

2012-03-07/11:50:56.dv
audio viz

audio viz

2012-03-07/12:29:58.dv
audio viz

audio viz

Veyepar Video Eyeball Processor and Review