Hi
user
Admin Login:
Username:
Password:
Name:
Constraints in PostgreSQL
--client
pgza
--show
pgza18
--room cedarwood 14385 --force
Next: 11 Row Level Security
show more...
Marks
Author(s):
George Nel
Location
Cedarwood
Date
oct Tue 09
Days Raw Files
Start
13:00
First Raw Start
12:39
Duration
00:40:00
Offset
0:20:10
End
13:40
Last Raw End
14:09
Chapters
00:00
0:11:05
Total cuts_time
28 min.
https://postgresconf.org/conferences/SouthAfrica2018/program/proposals/777
raw-playlist
raw-mp4-playlist
encoded-files-playlist
host
archive
tweet
mp4
svg
png
assets
release.pdf
Constraints_in_Postgres.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
Comment:
production notes
2018-10-09/12_39_50.ts
Apply:
12:39:50 - 12:58:44 ( 00:18:54 )
S:
12:39:50 -
E:
13:09:49
D:
00:29:59
(
End:
1134.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/cedarwood/2018-10-09/12_39_50.ts :start-time=00.0 --audio-desync=0
Raw File
Cut List
12:39:50
seconds: 0.0
Wall: 12:39:50
Duration
00:29:59
13:09:49
seconds: 1134.0
Wall: 12:58:44
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/12_39_50.ts
Apply:
12:58:44 - 13:09:49 ( 00:11:05 )
S:
12:39:50 -
E:
13:09:49
D:
00:29:59
(
Start:
1134.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/cedarwood/2018-10-09/12_39_50.ts :start-time=01134.0 --audio-desync=0
Raw File
Cut List
12:39:50
seconds: 1134.0
Wall: 12:58:44
Duration
00:29:59
13:09:49
seconds: 0.0
Wall: 12:39:50
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/13_09_50.ts
Apply:
13:09:50 - 13:27:44 ( 00:17:54 )
S:
13:09:50 -
E:
13:39:50
D:
00:30:00
(
End:
1074.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/cedarwood/2018-10-09/13_09_50.ts :start-time=00.0 --audio-desync=0
Raw File
Cut List
13:09:50
seconds: 0.0
Wall: 13:09:50
Duration
00:30:00
13:39:50
seconds: 1074.0
Wall: 13:27:44
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/13_09_50.ts
Apply:
13:27:44 - 13:39:50 ( 00:12:06 )
S:
13:09:50 -
E:
13:39:50
D:
00:30:00
(
Start:
1074.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/cedarwood/2018-10-09/13_09_50.ts :start-time=01074.0 --audio-desync=0
Raw File
Cut List
13:09:50
seconds: 1074.0
Wall: 13:27:44
Duration
00:30:00
13:39:50
seconds: 0.0
Wall: 13:09:50
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/13_39_50.ts
Apply:
13:39:50 - 13:49:59 ( 00:10:09 )
S:
13:39:50 -
E:
14:09:50
D:
00:30:00
(
End:
609.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/cedarwood/2018-10-09/13_39_50.ts :start-time=00.0 --audio-desync=0
Raw File
Cut List
13:39:50
seconds: 0.0
Wall: 13:39:50
Duration
00:30:00
14:09:50
seconds: 609.0
Wall: 13:49:59
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/13_39_50.ts
Apply:
13:49:59 - 14:09:50 ( 00:19:51 )
S:
13:39:50 -
E:
14:09:50
D:
00:30:00
(
Start:
609.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/cedarwood/2018-10-09/13_39_50.ts :start-time=0609.0 --audio-desync=0
Raw File
Cut List
13:39:50
seconds: 609.0
Wall: 13:49:59
Duration
00:30:00
14:09:50
seconds: 0.0
Wall: 13:39:50
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
2018-10-09/12_39_50.ts
2018-10-09/13_09_50.ts
2018-10-09/13_39_50.ts
Veyepar
Video Eyeball Processor and Review