Hi
user
Admin Login:
Username:
Password:
Name:
Putting Python in PostgreSQL
--client
psf
--show
pycon_2012
--room E2 727 --force
Next: 6 Sage: Open Source Math in Python
show more...
Marks
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
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:
---------
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
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.
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="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>
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
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
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
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
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
2012-03-08/15:18:57.dv
2012-03-08/15:20:12.dv
2012-03-08/15:55:46.dv
Veyepar
Video Eyeball Processor and Review