Basic video processing in Linux

As I became responsible for recording and processing videos from regular CZJUG meetings, I had to learn how to perform basic video processing in Linux - years ago I did this on Windows in Adobe Premiere, so I have been looking fro a similarly comfortable and flexible solution. I guess you are trying to solve about the same problem, so lets review my solution based on ffmpeg and kdenlive.

Basic principles of database indexes

Are you using relational databases but the indexes are closed book for you? You absolutely don't know what the indexes are and how they work, or you are confused by various types of indexes (B-Tree, Hash, Bitmap) and you're not sure about their advantages or disadvantages? Or you just can't find out why a particular index is not used when evaluating a query? Maybe this article will help you to answer these questions ...

1