veyepar: Migrating away from Oracle to PostgreSQL

Author(s):	Abhinav Singh
Location	Baobab
Date	oct Tue 09	Days Raw Files
Start	15:50	First Raw Start	15:28
Duration	00:40:00	Offset	0:21:33
End	16:30	Last Raw End	16:58
Chapters	00:00 0:04:52 0:34:51 0:35:14
Total cuts_time	35 min.

https://postgresconf.org/conferences/SouthAfrica2018/program/proposals/881
raw-playlist raw-mp4-playlist encoded-files-playlist host archive tweet mp4 svg png

assets release.pdf Migrating_away_from_Oracle_to_PostgreSQL.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:

markdown

Comment:

production notes

2018-10-09/15_28_27.ts Apply: 15:28:27 - 15:32:32 ( 00:04:05 ) S: 15:28:27 - E: 15:58:26 D: 00:29:59 (End: 245.0) show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/15_28_27.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	15:28:27		seconds: 0.0 Wall: 15:28:27
Duration	00:29:59
	15:58:26		seconds: 245.0 Wall: 15:32:32
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/15_28_27.ts Apply: 15:32:32 - 15:53:31 ( 00:20:59 ) S: 15:28:27 - E: 15:58:26 D: 00:29:59 (Start: 245.0) (End: 1504.0) show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/15_28_27.ts :start-time=0245.0 --audio-desync=0

	Raw File	Cut List
	15:28:27		seconds: 245.0 Wall: 15:32:32
Duration	00:29:59
	15:58:26		seconds: 1504.0 Wall: 15:53:31
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/15_28_27.ts Apply: 15:53:33 - 15:58:26 ( 00:04:52 ) S: 15:28:27 - E: 15:58:26 D: 00:29:59 (Start: 1506.918979) show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/15_28_27.ts :start-time=01506.918979 --audio-desync=0

	Raw File	Cut List
	15:28:27		seconds: 1506.918979 Wall: 15:53:33
Duration	00:29:59
	15:58:26		seconds: 0.0 Wall: 15:28:27
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/15_58_27.ts Apply: 15:58:27 - 16:28:26 ( 00:29:59 ) S: 15:58:27 - E: 16:28:26 D: 00:29:59 show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/15_58_27.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	15:58:27		seconds: 0.0 Wall: 15:58:27
Duration	00:29:59
	16:28:26		seconds: 0.0 Wall: 15:58:27
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/16_28_27.ts Apply: 16:28:27 - 16:28:50 ( 00:00:23 ) S: 16:28:27 - E: 16:58:26 D: 00:29:59 (End: 23.0) show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/16_28_27.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	16:28:27		seconds: 0.0 Wall: 16:28:27
Duration	00:29:59
	16:58:26		seconds: 23.0 Wall: 16:28:50
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/16_28_27.ts Apply: 16:28:50 - 16:29:09 ( 00:00:19 ) S: 16:28:27 - E: 16:58:26 D: 00:29:59 (Start: 23.0) (End: 42.225499) show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/16_28_27.ts :start-time=023.0 --audio-desync=0

	Raw File	Cut List
	16:28:27		seconds: 23.0 Wall: 16:28:50
Duration	00:29:59
	16:58:26		seconds: 42.225499 Wall: 16:29:09
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/16_28_27.ts Apply: 16:29:04 - 16:29:09 ( 00:00:05 ) S: 16:28:27 - E: 16:58:26 D: 00:29:59 (Start: 37.0) (End: 42.0) show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/16_28_27.ts :start-time=037.0 --audio-desync=0

	Raw File	Cut List
	16:28:27		seconds: 37.0 Wall: 16:29:04
Duration	00:29:59
	16:58:26		seconds: 42.0 Wall: 16:29:09
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/16_28_27.ts Apply: 16:29:09 - 16:40:55 ( 00:11:46 ) S: 16:28:27 - E: 16:58:26 D: 00:29:59 (Start: 42.0) (End: 748.0) show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/16_28_27.ts :start-time=042.0 --audio-desync=0

	Raw File	Cut List
	16:28:27		seconds: 42.0 Wall: 16:29:09
Duration	00:29:59
	16:58:26		seconds: 748.0 Wall: 16:40:55
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/16_28_27.ts Apply: 16:40:55 - 16:41:06 ( 00:00:11 ) S: 16:28:27 - E: 16:58:26 D: 00:29:59 (Start: 748.0) (End: 759.0) show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/16_28_27.ts :start-time=0748.0 --audio-desync=0

	Raw File	Cut List
	16:28:27		seconds: 748.0 Wall: 16:40:55
Duration	00:29:59
	16:58:26		seconds: 759.0 Wall: 16:41:06
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/16_28_27.ts Apply: 16:41:06 - 16:58:26 ( 00:17:20 ) S: 16:28:27 - E: 16:58:26 D: 00:29:59 (Start: 759.0) show more...

vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/16_28_27.ts :start-time=0759.0 --audio-desync=0

	Raw File	Cut List
	16:28:27		seconds: 759.0 Wall: 16:41:06
Duration	00:29:59
	16:58:26		seconds: 0.0 Wall: 16:28:27
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete