veyepar: Real-Life PostgreSQL JSON

Author(s):	Christophe Pettus
Location	K.3.401
Date	feb Sat 01	Days Raw Files
Start	12:00	First Raw Start	11:59
Duration	00:50:00	Offset	0:00:35
End	12:50	Last Raw End	13:00
Chapters	00:00 0:00:03 0:00:03
Total cuts_time	0 min.

https://fosdem.org/2014/schedule/event/real_life_postgresql_json/
raw-playlist raw-mp4-playlist encoded-files-playlist public mp4 svg png

assets release.pdf RealLife_PostgreSQL_JSON.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:	<p>PostgreSQL has added some wonderful new JSON features in 9.2 and 9.3. They look fascinating, exciting, and should have all kinds of great applications...</p> <p>Like what?</p> <p>We'll talk about some real-life use-cases that actual companies are deploying, and what the trade-offs, performance issues, and challenges they've faced are.</p> markdown
Comment:	missing first 40 minutes of file. production notes

2014-02-01/10_59_25.dv Apply: 11:59:34 - 11:59:37 ( 00:00:03 ) S: 11:59:25 - E: 11:59:37 D: 00:00:12 (Start: 9) show more... cruft, then few seconds of intro

vlc ~/Videos/veyepar/fosdem/fosdem_2014/dv/K3401/2014-02-01/10_59_25.dv :start-time=09.0 --audio-desync=0

	Raw File	Cut List
	11:59:25		seconds: 9.0 Wall: 11:59:34
Duration	00:00:12
	11:59:37		seconds: 0.0 Wall: 11:59:25
Comments:		cruft, then few seconds of intro
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2014-02-01/10_59_38.dv Apply: 11:59:38 - 11:59:38 ( 00:00:00 ) S: 11:59:38 - E: 11:59:38 D: 00:00:00 show more...

vlc ~/Videos/veyepar/fosdem/fosdem_2014/dv/K3401/2014-02-01/10_59_38.dv :start-time=00.0 --audio-desync=0

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

2014-02-01/11_39_53.dv Apply: 12:39:53 - 12:39:57 ( 00:00:04 ) S: 12:39:53 - E: 13:00:57 D: 00:21:04 (End: 4) show more... end of clapping, then between talk cruft

vlc ~/Videos/veyepar/fosdem/fosdem_2014/dv/K3401/2014-02-01/11_39_53.dv :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	12:39:53		seconds: 0.0 Wall: 12:39:53
Duration	00:21:04
	13:00:57		seconds: 4.0 Wall: 12:39:57
Comments:		end of clapping, then between talk cruft
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