jasonmadigan

Frigate Test Clip

To tune Frigate, it can sometimes be useful to input saved clips in order to see how detection works. I've found the easiest way to accomplish this is by grabbing a clip (say, from your NVR), and streaming this on a loop via RTSP to Frigate. This will let you tune settings with an existing configuration, which is a bit different to using process_clip.py that's included with Frigate.

Pre-requisites

• A sample clip, in a format supported by ffmpeg (.mp4 is good)
• Docker on a machine that'll do the streaming
• A working ffmpeg install. I'm using a mac, so I typically install via Brew: brew install ffmpeg

Jiab77

Real-time PHP-FPM Status

This gist will explain you how to enable an undocumented feature of PHP-FPM which will give a real-time performance stats.

Everybody knows the famous phpinfo() and the page it generates, right? Then the real-time PHP-FPM status page design is very similar.

Some informations from the top are not displayed to avoid security issues.

Enable PHP-FPM Status

steveodom

Useful Links / Sources

PrestoDB Selects Doc

Housekeeping

change column type

ALTER TABLE logs.trades CHANGE recentprice price int;