veyepar: PostgreSQL replication by example

Author(s):	Kobus Wolvaardt
Location	Baobab
Date	oct Tue 09	Days Raw Files
Start	15:00	First Raw Start	14:58
Duration	00:40:00	Offset	0:01:33
End	15:40	Last Raw End	15:58
Chapters	00:00 0:26:35
Total cuts_time	30 min.

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

assets release.pdf Postgres_Replication_by_example.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/14_58_27.ts Apply: 14:58:27 - 15:00:51 ( 00:02:24 ) S: 14:58:27 - E: 15:28:26 D: 00:29:59 (End: 144.0) show more...

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

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

2018-10-09/14_58_27.ts Apply: 15:00:48 - 15:01:17 ( 00:00:28 ) S: 14:58:27 - E: 15:28:26 D: 00:29:59 (Start: 141.714123) (End: 170.0) show more...

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

	Raw File	Cut List
	14:58:27		seconds: 141.714123 Wall: 15:00:48
Duration	00:29:59
	15:28:26		seconds: 170.0 Wall: 15:01:17
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-10-09/14_58_27.ts Apply: 15:01:50 - 15:28:26 ( 00:26:35 ) S: 14:58:27 - E: 15:28:26 D: 00:29:59 (Start: 203.161604) show more...

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

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

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:31 - 15:58:26 ( 00:04:55 ) S: 15:28:27 - E: 15:58:26 D: 00:29:59 (Start: 1504.0) show more...

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

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