Hi
user
Admin Login:
Username:
Password:
Name:
SQL for Python Developers
--client
psf
--show
pycon_2012
--room H2 670 --force
Next: 6 MongoDB and Python
show more...
Marks
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
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:
---------
borked
edit
encode
push to queue
post
richard
review 1
email
review 2
make public
tweet
to-miror
conf
done
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
Unknown
Yes
No
Normalise:
Channelcopy:
m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:
filename.png
Description:
markdown
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.
Comment:
production notes
<?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>
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
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
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
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
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
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
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
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
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
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
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
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
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
2012-03-07/09:02:18.dv
2012-03-07/09:38:30.dv
2012-03-07/09:47:07.dv
2012-03-07/09:59:29.dv
2012-03-07/10:05:44.dv
2012-03-07/10:07:00.dv
2012-03-07/10:08:58.dv
2012-03-07/10:44:05.dv
2012-03-07/11:06:22.dv
2012-03-07/11:50:56.dv
2012-03-07/12:29:58.dv
Veyepar
Video Eyeball Processor and Review
