Hi
user
Admin Login:
Username:
Password:
Name:
Window Functions
--client
pgza
--show
pgza18
--room baobab 14381 --force
Next: 11 Big Data Machine Learning in SQL for Developers
show more...
Marks
Author(s):
Willem Booysen
Location
Baobab
Date
oct Tue 09
Days Raw Files
Start
11:20
First Raw Start
10:53
Duration
00:40:00
Offset
0:26:45
End
12:00
Last Raw End
11:55
Chapters
00:00
0:03:25
0:33:24
Total cuts_time
33 min.
https://postgresconf.org/conferences/SouthAfrica2018/program/proposals/294
raw-playlist
raw-mp4-playlist
encoded-files-playlist
host
archive
tweet
mp4
svg
png
assets
release.pdf
Window_Functions.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
Window Functions are easy...ish once you understand the syntax and how one needs to approach your data.
Comment:
production notes
2018-10-09/10_53_15.ts
Apply:
10:53:15 - 11:09:47 ( 00:16:32 )
S:
10:53:15 -
E:
11:23:15
D:
00:30:00
(
End:
992.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/10_53_15.ts :start-time=00.0 --audio-desync=0
Raw File
Cut List
10:53:15
seconds: 0.0
Wall: 10:53:15
Duration
00:30:00
11:23:15
seconds: 992.0
Wall: 11:09:47
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/10_53_15.ts
Apply:
11:09:47 - 11:19:43 ( 00:09:56 )
S:
10:53:15 -
E:
11:23:15
D:
00:30:00
(
Start:
992.0) (
End:
1588.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/10_53_15.ts :start-time=0992.0 --audio-desync=0
Raw File
Cut List
10:53:15
seconds: 992.0
Wall: 11:09:47
Duration
00:30:00
11:23:15
seconds: 1588.0
Wall: 11:19:43
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/10_53_15.ts
Apply:
11:19:49 - 11:23:15 ( 00:03:25 )
S:
10:53:15 -
E:
11:23:15
D:
00:30:00
(
Start:
1594.183956)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/10_53_15.ts :start-time=01594.183956 --audio-desync=0
Raw File
Cut List
10:53:15
seconds: 1594.183956
Wall: 11:19:49
Duration
00:30:00
11:23:15
seconds: 0.0
Wall: 10:53:15
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/11_23_15.ts
Apply:
11:23:15 - 11:53:14 ( 00:29:59 )
S:
11:23:15 -
E:
11:53:14
D:
00:29:59
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/11_23_15.ts :start-time=00.0 --audio-desync=0
Raw File
Cut List
11:23:15
seconds: 0.0
Wall: 11:23:15
Duration
00:29:59
11:53:14
seconds: 0.0
Wall: 11:23:15
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/11_53_15.ts
Apply:
11:53:15 - 11:53:28 ( 00:00:13 )
S:
11:53:15 -
E:
11:55:00
D:
00:01:45
(
End:
13.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/11_53_15.ts :start-time=00.0 --audio-desync=0
Raw File
Cut List
11:53:15
seconds: 0.0
Wall: 11:53:15
Duration
00:01:45
11:55:00
seconds: 13.0
Wall: 11:53:28
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2018-10-09/11_53_15.ts
Apply:
11:53:28 - 11:55:00 ( 00:01:32 )
S:
11:53:15 -
E:
11:55:00
D:
00:01:45
(
Start:
13.0)
show more...
vlc ~/Videos/veyepar/pgza/pgza18/dv/baobab/2018-10-09/11_53_15.ts :start-time=013.0 --audio-desync=0
Raw File
Cut List
11:53:15
seconds: 13.0
Wall: 11:53:28
Duration
00:01:45
11:55:00
seconds: 0.0
Wall: 11:53:15
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/10_53_15.ts
2018-10-09/11_23_15.ts
2018-10-09/11_53_15.ts
Veyepar
Video Eyeball Processor and Review