veyepar: How to optimize Postgres queries for Python developers

Author(s):	Lukas Fittl
Location	Reis River Ranch
Date	jun Sat 29	Days Raw Files
Start	11:25	First Raw Start	10:51
Duration	00:25:00	Offset	0:33:46
End	11:50	Last Raw End	12:01
Chapters	00:00 0:22:14
Total cuts_time	25 min.

https://pretalx.northbaypython.org/nbpy-2024/talk/DQMNE3
raw-playlist raw-mp4-playlist encoded-files-playlist host archive mp4 svg png

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

barn/2024-06-29/10_51_14.ts Apply: 10:51:14 - 11:02:38 ( 00:11:24 ) S: 10:51:14 - E: 11:21:13 D: 00:29:59 (End: 684.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/10_51_14.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	10:51:14		seconds: 0.0 Wall: 10:51:14
Duration	00:29:59
	11:21:13		seconds: 684.0 Wall: 11:02:38
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

barn/2024-06-29/10_51_14.ts Apply: 11:02:38 - 11:03:35 ( 00:00:57 ) S: 10:51:14 - E: 11:21:13 D: 00:29:59 (Start: 684.0) (End: 741.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/10_51_14.ts :start-time=0684.0 --audio-desync=0

	Raw File	Cut List
	10:51:14		seconds: 684.0 Wall: 11:02:38
Duration	00:29:59
	11:21:13		seconds: 741.0 Wall: 11:03:35
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

barn/2024-06-29/10_51_14.ts Apply: 11:03:35 - 11:21:13 ( 00:17:38 ) S: 10:51:14 - E: 11:21:13 D: 00:29:59 (Start: 741.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/10_51_14.ts :start-time=0741.0 --audio-desync=0

	Raw File	Cut List
	10:51:14		seconds: 741.0 Wall: 11:03:35
Duration	00:29:59
	11:21:13		seconds: 0.0 Wall: 10:51:14
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

barn/2024-06-29/11_21_14.ts Apply: 11:21:14 - 11:24:45 ( 00:03:31 ) S: 11:21:14 - E: 11:51:14 D: 00:30:00 (End: 211.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/11_21_14.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:21:14		seconds: 0.0 Wall: 11:21:14
Duration	00:30:00
	11:51:14		seconds: 211.0 Wall: 11:24:45
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

barn/2024-06-29/11_21_14.ts Apply: 11:24:45 - 11:25:11 ( 00:00:26 ) S: 11:21:14 - E: 11:51:14 D: 00:30:00 (Start: 211.0) (End: 237.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/11_21_14.ts :start-time=0211.0 --audio-desync=0

	Raw File	Cut List
	11:21:14		seconds: 211.0 Wall: 11:24:45
Duration	00:30:00
	11:51:14		seconds: 237.0 Wall: 11:25:11
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

barn/2024-06-29/11_21_14.ts Apply: 11:25:11 - 11:28:22 ( 00:03:11 ) S: 11:21:14 - E: 11:51:14 D: 00:30:00 (Start: 237.0) (End: 428.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/11_21_14.ts :start-time=0237.0 --audio-desync=0

	Raw File	Cut List
	11:21:14		seconds: 237.0 Wall: 11:25:11
Duration	00:30:00
	11:51:14		seconds: 428.0 Wall: 11:28:22
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

barn/2024-06-29/11_21_14.ts Apply: 11:28:22 - 11:29:00 ( 00:00:38 ) S: 11:21:14 - E: 11:51:14 D: 00:30:00 (Start: 428.0) (End: 466.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/11_21_14.ts :start-time=0428.0 --audio-desync=0

	Raw File	Cut List
	11:21:14		seconds: 428.0 Wall: 11:28:22
Duration	00:30:00
	11:51:14		seconds: 466.0 Wall: 11:29:00
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

barn/2024-06-29/11_21_14.ts Apply: 11:29:00 - 11:51:14 ( 00:22:14 ) S: 11:21:14 - E: 11:51:14 D: 00:30:00 (Start: 466.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/11_21_14.ts :start-time=0466.0 --audio-desync=0

	Raw File	Cut List
	11:21:14		seconds: 466.0 Wall: 11:29:00
Duration	00:30:00
	11:51:14		seconds: 0.0 Wall: 11:21:14
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

barn/2024-06-29/11_51_14.ts Apply: 11:51:14 - 11:54:55 ( 00:03:41 ) S: 11:51:14 - E: 12:01:21 D: 00:10:07 (End: 221.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/11_51_14.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	11:51:14		seconds: 0.0 Wall: 11:51:14
Duration	00:10:07
	12:01:21		seconds: 221.0 Wall: 11:54:55
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

barn/2024-06-29/11_51_14.ts Apply: 11:54:55 - 12:01:21 ( 00:06:26 ) S: 11:51:14 - E: 12:01:21 D: 00:10:07 (Start: 221.0) show more...

vlc ~/Videos/veyepar/nbpy/NBPy2024/dv/barn/barn/2024-06-29/11_51_14.ts :start-time=0221.0 --audio-desync=0

	Raw File	Cut List
	11:51:14		seconds: 221.0 Wall: 11:54:55
Duration	00:10:07
	12:01:21		seconds: 0.0 Wall: 11:51:14
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete