I’m just this guy, you know?

  • 4 Posts
  • 26 Comments
Joined 1 year ago
cake
Cake day: June 12th, 2023

help-circle





  • No worries, the other poster was just wasn’t being helpful. And/or doesn’t understand statistics & databases, but I don’t care to speculate on that or to waste more of my time on them.

    The setting above maxes out at 24h in stock builds, but can be extended beyond that if you are willing to recompile the FTL database with different parameters to allow for a deeper look back window for your query log. Even at that point, a second database setting farther down that page sets the max age of all query logs to 1y, so at best you’d get a running tally of up to a year. This would probably at the expense of performance for dashboard page loads since the number is probably computed at page load. The live DB call is intended for relatively short windows vs database lifetime.

    If you want an all-time count, you’ll have to track it off box because FTL doesn’t provide an all-time metric, or deep enough data persistence. I was just offering up a methodology that could be an interesting and beneficial project for others with similar needs.

    Hey, this was fun. See you around.



  • #### MAXLOGAGE=24.0
    Up to how many hours of queries should be imported from the database and logs? Values greater than the hard-coded maximum of 24h need a locally compiled `FTL` with a changed compile-time value.
    

    I assume this is the setting you are suggesting can extend the query count period. It still will only give you the last N hours’ worth of queries, which is not what OP asked. I gather OP wants to see the cumulative total of blocked queries over all time, and I doubt the FTL database tracks the data in a usable way to arrive at that number.














  • Sure that’s easy. All you need is an HX711 sensor load cell amplifier taped to the floor of the chamber where it sits under an edge of your bottle.

    Full, 5 gal (US) jug or water weights 40lbs nominal. If you have the same bottom feed dispenser I have, it starts drawing air with about 16-20oz of water left in the bottom.

    You’d want to calibrate first for the sensor without weight (tare), and then for a full bottle’s weight (40lb) accounting for cosine error of the bottle being slightly tilted by the thickness of the sensor. Or, tape a couple of shims at 120° offset from the sensor to level out the bottle.

    Finally, note the weight of an “empty” bottle with that 18ish oz of water in it, which will probably be close to the zero value.

    Now you can calculate % full by looking at the ratio of the current weight between your full/empty value as:

    %Water = [ (W_full - (W-18oz -W_tare) ) - W_now ] / (W_full - (W_18oz - W_tare) ) x 100