veyepar: The SQLAlchemy Session - In Depth

Hi user

Admin Login:

Name: The SQLAlchemy Session - In Depth
--client pyconca --show pyconca2012 --room Main_hall 1529 --force
Prev: 8 PyCon Canada 2012 - Saturday Morning Keynote
Next: 11 Profiling for Performance

show more...

Author(s):	Mike Bayer
Location	Main hall
Date	nov Sat 10	Days Raw Files
Start	10:25	First Raw Start	10:18
Duration	00:45:00	Offset	0:06:34
End	11:10	Last Raw End	11:16
Chapters	00:00 0:15:36 0:21:58 0:36:51
Total cuts_time	41 min.

http://pycon.ca/talk/74
raw-playlist raw-mp4-playlist encoded-files-playlist host archive public tweet mp4 svg png

final audio

assets release.pdf The_SQLAlchemy_Session_In_Depth.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:	A detailed walkthrough of SQLAlchemy's Session, describing the rationale for its existence, its driving philosophies, and finally a walkthrough of Session lifecycle through the use of an animated diagram. We'll cover how the relational database refers to database rows within a transaction, and how the Session has over the years developed a tight, proxied integration with this lifecycle. markdown
Comment:	<?xml version='1.0' encoding='UTF-8'?> <ns0:entry xmlns:ns0="http://www.w3.org/2005/Atom"><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="pyconca" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="pyconca2012" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="MikeBayer" /><ns0:id>http://gdata.youtube.com/feeds/api/videos/r7h63hjKfsQ</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">Mike Bayer A detailed walkthrough of SQLAlchemy's Session, describing the rationale for its existence, its driving philosophies, and finally a walkthrough of Session lifecycle through the use of an animated diagram. We'll cover how the relational dat</ns0:content><ns0:updated>2012-11-11T11:42:58.000Z</ns0:updated><ns0:published>2012-11-11T11:42:58.000Z</ns0:published><ns1:comments xmlns:ns1="http://schemas.google.com/g/2005"><ns1:feedLink countHint="0" href="https://gdata.youtube.com/feeds/api/videos/r7h63hjKfsQ/comments?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#comments" /></ns1:comments><ns1:group xmlns:ns1="http://search.yahoo.com/mrss/"><ns1:keywords>pyconca, pyconca2012, MikeBayer</ns1:keywords><ns1:description type="plain">Mike Bayer A detailed walkthrough of SQLAlchemy's Session, describing the rationale for its existence, its driving philosophies, and finally a walkthrough of Session lifecycle through the use of an animated diagram. We'll cover how the relational dat</ns1:description><ns1:title type="plain">The SQLAlchemy Session - In Depth</ns1:title><ns2:duration seconds="0" xmlns:ns2="http://gdata.youtube.com/schemas/2007" /><ns1:content duration="0" expression="full" isDefault="true" medium="video" type="application/x-shockwave-flash" url="https://www.youtube.com/v/r7h63hjKfsQ?version=3&f=user_uploads&c=NextDayVideo&d=Aarb2r5skm2_yNTuKEinXdAO88HsQjpE1a8d1GxQnGDm&app=youtube_gdata" ns2:format="5" xmlns:ns2="http://gdata.youtube.com/schemas/2007" /><ns1:thumbnail height="360" time="00:00:00" url="http://i.ytimg.com/vi/r7h63hjKfsQ/0.jpg" width="480" /><ns1:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/r7h63hjKfsQ/1.jpg" width="120" /><ns1:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/r7h63hjKfsQ/2.jpg" width="120" /><ns1:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/r7h63hjKfsQ/3.jpg" width="120" /><ns1:category label="Education" scheme="http://gdata.youtube.com/schemas/2007/categories.cat">Education</ns1:category><ns1:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">pyconca</ns1:category><ns1:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">pyconca2012</ns1:category><ns1:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">MikeBayer</ns1:category><ns1:player url="https://www.youtube.com/watch?v=r7h63hjKfsQ&feature=youtube_gdata_player" /></ns1:group><ns0:title type="text">The SQLAlchemy Session - In Depth</ns0:title><ns1:control xmlns:ns1="http://purl.org/atom/app#"><ns1:draft>yes</ns1:draft><ns2:state name="processing" xmlns:ns2="http://gdata.youtube.com/schemas/2007" /></ns1:control><ns0:link href="https://www.youtube.com/watch?v=r7h63hjKfsQ&feature=youtube_gdata" rel="alternate" type="text/html" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/r7h63hjKfsQ/responses?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.responses" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/r7h63hjKfsQ/ratings?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.ratings" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/r7h63hjKfsQ/complaints?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.complaints" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/r7h63hjKfsQ/related?client=NextDayVideo" 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/r7h63hjKfsQ?client=NextDayVideo" rel="self" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/users/nextdayvideo/uploads/r7h63hjKfsQ?client=NextDayVideo" rel="edit" type="application/atom+xml" /></ns0:entry> <?xml version='1.0' encoding='UTF-8'?> <ns0:entry xmlns:ns0="http://www.w3.org/2005/Atom"><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="pyconca" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="pyconca2012" /><ns0:category scheme="http://gdata.youtube.com/schemas/2007/keywords.cat" term="MikeBayer" /><ns0:id>http://gdata.youtube.com/feeds/api/videos/PKAdehPHOMo</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">Mike Bayer A detailed walkthrough of SQLAlchemy's Session, describing the rationale for its existence, its driving philosophies, and finally a walkthrough of Session lifecycle through the use of an animated diagram. We'll cover how the relational dat</ns0:content><ns0:updated>2012-11-13T19:16:33.000Z</ns0:updated><ns0:published>2012-11-13T19:16:33.000Z</ns0:published><ns1:comments xmlns:ns1="http://schemas.google.com/g/2005"><ns1:feedLink countHint="0" href="https://gdata.youtube.com/feeds/api/videos/PKAdehPHOMo/comments?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#comments" /></ns1:comments><ns1:group xmlns:ns1="http://search.yahoo.com/mrss/"><ns1:keywords>pyconca, pyconca2012, MikeBayer</ns1:keywords><ns1:description type="plain">Mike Bayer A detailed walkthrough of SQLAlchemy's Session, describing the rationale for its existence, its driving philosophies, and finally a walkthrough of Session lifecycle through the use of an animated diagram. We'll cover how the relational dat</ns1:description><ns1:title type="plain">The SQLAlchemy Session - In Depth</ns1:title><ns2:duration seconds="0" xmlns:ns2="http://gdata.youtube.com/schemas/2007" /><ns1:content duration="0" expression="full" isDefault="true" medium="video" type="application/x-shockwave-flash" url="https://www.youtube.com/v/PKAdehPHOMo?version=3&f=user_uploads&c=NextDayVideo&d=Aarb2r5skm2_yNTuKEinXdAO88HsQjpE1a8d1GxQnGDm&app=youtube_gdata" ns2:format="5" xmlns:ns2="http://gdata.youtube.com/schemas/2007" /><ns1:thumbnail height="360" time="00:00:00" url="http://i.ytimg.com/vi/PKAdehPHOMo/0.jpg" width="480" /><ns1:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/PKAdehPHOMo/1.jpg" width="120" /><ns1:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/PKAdehPHOMo/2.jpg" width="120" /><ns1:thumbnail height="90" time="00:00:00" url="http://i.ytimg.com/vi/PKAdehPHOMo/3.jpg" width="120" /><ns1:category label="Education" scheme="http://gdata.youtube.com/schemas/2007/categories.cat">Education</ns1:category><ns1:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">pyconca</ns1:category><ns1:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">pyconca2012</ns1:category><ns1:category scheme="http://gdata.youtube.com/schemas/2007/developertags.cat">MikeBayer</ns1:category><ns1:player url="https://www.youtube.com/watch?v=PKAdehPHOMo&feature=youtube_gdata_player" /></ns1:group><ns0:title type="text">The SQLAlchemy Session - In Depth</ns0:title><ns1:control xmlns:ns1="http://purl.org/atom/app#"><ns1:draft>yes</ns1:draft><ns2:state name="processing" xmlns:ns2="http://gdata.youtube.com/schemas/2007" /></ns1:control><ns0:link href="https://www.youtube.com/watch?v=PKAdehPHOMo&feature=youtube_gdata" rel="alternate" type="text/html" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/PKAdehPHOMo/responses?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.responses" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/PKAdehPHOMo/ratings?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.ratings" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/PKAdehPHOMo/complaints?client=NextDayVideo" rel="http://gdata.youtube.com/schemas/2007#video.complaints" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/videos/PKAdehPHOMo/related?client=NextDayVideo" 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/PKAdehPHOMo?client=NextDayVideo" rel="self" type="application/atom+xml" /><ns0:link href="https://gdata.youtube.com/feeds/api/users/nextdayvideo/uploads/PKAdehPHOMo?client=NextDayVideo" rel="edit" type="application/atom+xml" /></ns0:entry> production notes

2012-11-10/10_18_26.dv Apply: 10:18:26 - 10:26:16 ( 00:07:50 ) S: 10:18:26 - E: 10:26:16 D: 00:07:50 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/10_18_26.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	10:18:26		seconds: 0.0 Wall: 10:18:26
Duration	00:07:50
	10:26:16		seconds: 0.0 Wall: 10:18:26
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-10/10_26_17.dv Apply: 10:26:17 - 10:41:53 ( 00:15:36 ) S: 10:26:17 - E: 10:41:53 D: 00:15:36 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/10_26_17.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	10:26:17		seconds: 0.0 Wall: 10:26:17
Duration	00:15:36
	10:41:53		seconds: 0.0 Wall: 10:26:17
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-10/10_42_00.dv Apply: 10:42:00 - 10:48:22 ( 00:06:22 ) S: 10:42:00 - E: 10:48:22 D: 00:06:22 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/10_42_00.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	10:42:00		seconds: 0.0 Wall: 10:42:00
Duration	00:06:22
	10:48:22		seconds: 0.0 Wall: 10:42:00
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-10/10_48_25.dv Apply: 10:48:25 - 11:03:18 ( 00:14:53 ) S: 10:48:25 - E: 11:03:18 D: 00:14:53 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/10_48_25.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	10:48:25		seconds: 0.0 Wall: 10:48:25
Duration	00:14:53
	11:03:18		seconds: 0.0 Wall: 10:48:25
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-10/11_03_19.dv Apply: 11:03:19 - 11:07:28 ( 00:04:09 ) S: 11:03:19 - E: 11:07:28 D: 00:04:09 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/11_03_19.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:03:19		seconds: 0.0 Wall: 11:03:19
Duration	00:04:09
	11:07:28		seconds: 0.0 Wall: 11:03:19
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-10/11_07_29.dv Apply: 11:07:29 - 11:07:44 ( 00:00:15 ) S: 11:07:29 - E: 11:07:44 D: 00:00:15 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/11_07_29.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:07:29		seconds: 0.0 Wall: 11:07:29
Duration	00:00:15
	11:07:44		seconds: 0.0 Wall: 11:07:29
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-10/11_07_44.dv Apply: 11:07:44 - 11:07:58 ( 00:00:14 ) S: 11:07:44 - E: 11:07:58 D: 00:00:14 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/11_07_44.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:07:44		seconds: 0.0 Wall: 11:07:44
Duration	00:00:14
	11:07:58		seconds: 0.0 Wall: 11:07:44
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-10/11_08_00.dv Apply: 11:08:00 - 11:09:21 ( 00:01:21 ) S: 11:08:00 - E: 11:09:21 D: 00:01:21 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/11_08_00.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:08:00		seconds: 0.0 Wall: 11:08:00
Duration	00:01:21
	11:09:21		seconds: 0.0 Wall: 11:08:00
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-10/11_09_26.dv Apply: 11:09:26 - 11:09:26 ( 00:00:00 ) S: 11:09:26 - E: 11:09:26 D: 00:00:00 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/11_09_26.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:09:26		seconds: 0.0 Wall: 11:09:26
Duration	00:00:00
	11:09:26		seconds: 0.0 Wall: 11:09:26
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

audio viz

2012-11-10/11_09_26-1.dv Apply: 11:09:26 - 11:16:16 ( 00:06:50 ) S: 11:09:26 - E: 11:16:16 D: 00:06:50 show more...

vlc ~/Videos/veyepar/pyconca/pyconca2012/dv/Main_hall/2012-11-10/11_09_26-1.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:09:26		seconds: 0.0 Wall: 11:09:26
Duration	00:06:50
	11:16:16		seconds: 0.0 Wall: 11:09:26
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-11-10/10_18_26.dv
audio viz

audio viz

2012-11-10/10_26_17.dv
audio viz

audio viz

2012-11-10/10_42_00.dv
audio viz

audio viz

2012-11-10/10_48_25.dv
audio viz

audio viz

2012-11-10/11_03_19.dv
audio viz

audio viz

2012-11-10/11_07_29.dv
audio viz

audio viz

2012-11-10/11_07_44.dv
audio viz

audio viz

2012-11-10/11_08_00.dv
audio viz

audio viz

2012-11-10/11_09_26-1.dv
audio viz

audio viz

2012-11-10/11_09_26.dv
audio viz

audio viz

Veyepar Video Eyeball Processor and Review