Is there any log / db focused video surveillance querying system?

Hi,

I setup my first video surveillance system in 2024. I tried a bunch of software and ended up with Frigate.

Frigate is great: fantastic UI and a lot of features but in practice here is what I need to know from the system 90% of the time:

  1. Were there any cat detection between 1AM and 6AM and when?
  2. Were there any dog barking between 9PM and 11PM and when?
  3. Did anybody walked in the hallway today?

I can setup alerts but it is inefficient since I mostly need to review thing afterward (like I do not need to be alerted every time someone walk in the hallway, only if something was stolen or I only need to know if a cat was there if there is a poo).

Reviewing in the UI is ok but time consuming.

I was thinking about it and honestly the best system could just be a plain text logfile or a database I could query with SQL. Like:

20250121-06:21:30 [Cam2] Detection Dog file:///nvr/20250121-06:21:05_Cam2.mpg

Ultimately I would not even need a web ui, a log or db of detection events with timestamps and link to recorded video files would be enough !

Right now I haven't found such system or feature and the only solution I see is doing it myself with either

The problem is it doesn't include link to the webui or video file recorded what will be a hassle to do.

I guess this is a quite efficient way to work with a video surveillance system, especially for those with dozen of cameras. Do you know of any system I could use in such way?

Many thanks