veyepar: Handling Database Updates

Author(s):	Daniel Scherzer
Location	B7141
Date	may Thu 15	Days Raw Files
Start	14:35	First Raw Start	14:17
Duration	00:24:00	Offset	0:17:56
End	14:59	Last Raw End	15:17
Chapters	00:00 0:12:04 0:17:32
Total cuts_time	25 min.

raw-playlist raw-mp4-playlist encoded-files-playlist host mp4 svg png

assets release.pdf handling_database_updates.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:	WikiTeq has recently onboarded multiple clients that were upgrading from a much older version of MediaWiki. Specifically, they were upgrading from a version more than 2 LTS releases previously, meaning that just running update.php was not going to be supported. In this talk, I'll lay out how we worked to update these databases, including lessons learned and pitfalls to watch out for. markdown
Comment:	production notes

2025-05-15/14_17_12.ts Apply: 14:17:12 - 14:19:52 ( 00:02:40 ) S: 14:17:12 - E: 14:47:12 D: 00:30:00 (End: 160.0) show more...

vlc ~/Videos/veyepar/smwc/smwcon_spring_2025/dv/b7141/2025-05-15/14_17_12.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:17:12		seconds: 0.0 Wall: 14:17:12
Duration	00:30:00
	14:47:12		seconds: 160.0 Wall: 14:19:52
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-05-15/14_17_12.ts Apply: 14:19:52 - 14:20:43 ( 00:00:51 ) S: 14:17:12 - E: 14:47:12 D: 00:30:00 (Start: 160.0) (End: 211.0) show more...

vlc ~/Videos/veyepar/smwc/smwcon_spring_2025/dv/b7141/2025-05-15/14_17_12.ts :start-time=0160.0 --audio-desync=0

	Raw File	Cut List
	14:17:12		seconds: 160.0 Wall: 14:19:52
Duration	00:30:00
	14:47:12		seconds: 211.0 Wall: 14:20:43
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-05-15/14_17_12.ts Apply: 14:20:43 - 14:33:18 ( 00:12:35 ) S: 14:17:12 - E: 14:47:12 D: 00:30:00 (Start: 211.0) (End: 966.0) show more...

vlc ~/Videos/veyepar/smwc/smwcon_spring_2025/dv/b7141/2025-05-15/14_17_12.ts :start-time=0211.0 --audio-desync=0

	Raw File	Cut List
	14:17:12		seconds: 211.0 Wall: 14:20:43
Duration	00:30:00
	14:47:12		seconds: 966.0 Wall: 14:33:18
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-05-15/14_17_12.ts Apply: 14:33:18 - 14:35:08 ( 00:01:50 ) S: 14:17:12 - E: 14:47:12 D: 00:30:00 (Start: 966.0) (End: 1076.0) show more...

vlc ~/Videos/veyepar/smwc/smwcon_spring_2025/dv/b7141/2025-05-15/14_17_12.ts :start-time=0966.0 --audio-desync=0

	Raw File	Cut List
	14:17:12		seconds: 966.0 Wall: 14:33:18
Duration	00:30:00
	14:47:12		seconds: 1076.0 Wall: 14:35:08
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-05-15/14_17_12.ts Apply: 14:35:08 - 14:47:12 ( 00:12:04 ) S: 14:17:12 - E: 14:47:12 D: 00:30:00 (Start: 1076.0) show more...

vlc ~/Videos/veyepar/smwc/smwcon_spring_2025/dv/b7141/2025-05-15/14_17_12.ts :start-time=01076.0 --audio-desync=0

	Raw File	Cut List
	14:17:12		seconds: 1076.0 Wall: 14:35:08
Duration	00:30:00
	14:47:12		seconds: 0.0 Wall: 14:17:12
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-05-15/14_47_12.ts Apply: 14:47:12 - 14:52:40 ( 00:05:28 ) S: 14:47:12 - E: 15:17:12 D: 00:30:00 (End: 328.0) show more...

vlc ~/Videos/veyepar/smwc/smwcon_spring_2025/dv/b7141/2025-05-15/14_47_12.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:47:12		seconds: 0.0 Wall: 14:47:12
Duration	00:30:00
	15:17:12		seconds: 328.0 Wall: 14:52:40
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-05-15/14_47_12.ts Apply: 14:52:40 - 15:01:01 ( 00:08:21 ) S: 14:47:12 - E: 15:17:12 D: 00:30:00 (Start: 328.0) (End: 829.0) show more...

vlc ~/Videos/veyepar/smwc/smwcon_spring_2025/dv/b7141/2025-05-15/14_47_12.ts :start-time=0328.0 --audio-desync=0

	Raw File	Cut List
	14:47:12		seconds: 328.0 Wall: 14:52:40
Duration	00:30:00
	15:17:12		seconds: 829.0 Wall: 15:01:01
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2025-05-15/14_47_12.ts Apply: 15:01:01 - 15:17:12 ( 00:16:11 ) S: 14:47:12 - E: 15:17:12 D: 00:30:00 (Start: 829.0) show more...

vlc ~/Videos/veyepar/smwc/smwcon_spring_2025/dv/b7141/2025-05-15/14_47_12.ts :start-time=0829.0 --audio-desync=0

	Raw File	Cut List
	14:47:12		seconds: 829.0 Wall: 15:01:01
Duration	00:30:00
	15:17:12		seconds: 0.0 Wall: 14:47:12
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