Need to split and send high-quality video signals across multiple screens?

Cheap splitters can degrade signal strength and image clarity.
Versitron video signal distribution boxes provide reliable, distortion-free video output for security and broadcast systems.

What’s your biggest challenge with distributing video signals? Tell us below!

#Versitron #SignalDistribution #VideoBox #FiberNetworking #MissionReady

Yesterday I’ve managed to implement the #Videobox filters on the series detail page of the new web UI. You can filter the single torrent files for resolution and/or size. This allows to quickly trim down the number of torrent files for every episode.

It took me quite a while to figure out the correct SQL query because I’m not good at it. I have an intuitive approach to SQL that makes me write the most simple queries, but when stuff like sub-queries and aggregate functions (sum, min, max, etc.) come into play the confusion begins. Plus I’m using the Python Peewee ORM so there’s an extra step to take.

So in a desperate attempt I’ve asked Bing (It’s also inside Skype now) to figure out a solution. I described the table structure I already have in Videobox and Bing suggested a mostly correct SQL representation for them.

Then I asked to write the query I was having issues with. The prompt I gave was vague and the query wasn’t really usable but it had the misterious “rank” function in the code. So I googled for it and landed on this page https://docs.peewee-orm.com/en/latest/peewee/querying.html#common-table-expressions of the Peewee docs that talks about the common table expressions (CTE). And that did the trick! I had to use min and max functions to get the smallest and largest file respectively, and a max function to grab the most seeded torrent as default filter. This is the code: https://github.com/passiomatic/videobox/blob/185a57db3611c1f31abe096b3ec3f158ffa75102/videobox/main/queries.py#L42

I can now focus on the other parts of the UI that need some polish. 🤓

#DevDiary