Get earliest query timestamp from database by PromoFaux · Pull Request #2706 · pi-hole/FTL

PromoFaux · 2025-11-09T14:15:27Z

What does this PR aim to accomplish?:

Retrieves the the earliest timestamp found in the database for both in memory and on disk databses. Will be utilised on the web interface for determining the "all time" range in the datetimepicker of the query page.

We reuse the existing get_number_of_queries_in_DB function and add an optional pointer to determine if we actually need the earliest timestamp or not. Maybe the function should be renamed, now. Not sure - I'll leave that up to @DL6ER

By submitting this pull request, I confirm the following:

I have read and understood the contributors guide, as well as this entire template. I understand which branch to base my commits and Pull Requests against.
I have commented my proposed changes within the code and I have tested my changes.
I am willing to help maintain this change if there are issues with it later.
It is compatible with the EUPL 1.2 license
I have squashed any insignificant commits. (git rebase)

I have read the above and my PR is ready for review. Check this box to confirm

PromoFaux · 2025-11-09T14:18:26Z

Ah. I didn't run the tests locally.. I'll go do that now. New info/database object example:

{
    "size": 984428544,
    "type": "Regular file",
    "mode": "rw-r-----",
    "atime": 1762697238,
    "mtime": 1762697238,
    "ctime": 1762697256,
    "owner": {
        "user": {
            "uid": 1000,
            "name": "pihole",
            "info": ""
        },
        "group": {
            "gid": 1000,
            "name": "pihole"
        }
    },
    "queries": 18405,
    "earliest_timestamp": 1762611067.3585176,
    "queries_disk": 2066976,
    "earliest_timestamp_disk": 1754835075.8952453,
    "sqlite_version": "3.50.4",
    "took": 0.9984595775604248
}

the earliest timestamp found in the database. Also gets number of queries/earliest timestamp in on-disk database Useful for determining the "All Time" range on the web interface Signed-off-by: Adam Warner <me@adamwarner.co.uk>

Signed-off-by: Adam Warner <me@adamwarner.co.uk>

pralor-bot · 2025-11-27T20:00:30Z

This pull request has been mentioned on Pi-hole Userspace. There might be relevant details there:

https://discourse.pi-hole.net/t/pi-hole-ftl-v6-4-web-v6-4-and-core-v6-3-released/83680/1

This PR contains the following updates: | Package | Update | Change | |---|---|---| | [pihole/pihole](https://redirect.github.com/pi-hole/docker-pi-hole) | patch | `2025.11.0` -> `2025.11.1` | --- ### Release Notes <details> <summary>pi-hole/docker-pi-hole (pihole/pihole)</summary> ### [`v2025.11.1`](https://redirect.github.com/pi-hole/docker-pi-hole/releases/tag/2025.11.1) [Compare Source](https://redirect.github.com/pi-hole/docker-pi-hole/compare/2025.11.0...2025.11.1)  #### What's Changed (Docker Specific) - Fix build status badge in readme by [@nol166](https://redirect.github.com/nol166) in [#1938](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1938) - Add RISCV back by [@yubiuser](https://redirect.github.com/yubiuser) in [#1939](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1939) - Improve FTL startup detection and log tailing by [@PromoFaux](https://redirect.github.com/PromoFaux) in [#1940](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1940) - Set DNS listening mode to 'ALL' in docker-compose.yml example by [@cornshakes](https://redirect.github.com/cornshakes) in [#1946](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1946) - Add instructions for excluding Pi-hole from Watchtower updates by [@chippy01](https://redirect.github.com/chippy01) in [#1949](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1949) #### New Contributors - [@nol166](https://redirect.github.com/nol166) made their first contribution in [#1938](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1938) - [@cornshakes](https://redirect.github.com/cornshakes) made their first contribution in [#1946](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1946) - [@chippy01](https://redirect.github.com/chippy01) made their first contribution in [#1949](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1949) **Full Changelog**: <pi-hole/docker-pi-hole@2025.11.0...2025.11.1> ***  #### What's Changed (FTL v6.4.1) - Fix API specs and example for dns.upstreams in config.yaml by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/FTL#2696](https://redirect.github.com/pi-hole/FTL/pull/2696) - gravity update - silently discard unicode BOM if present by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/FTL#2702](https://redirect.github.com/pi-hole/FTL/pull/2702) - Update embedded SQLite to 3.51.0 by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2704](https://redirect.github.com/pi-hole/FTL/pull/2704) - Get earliest query timestamp from database by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/FTL#2706](https://redirect.github.com/pi-hole/FTL/pull/2706) - Increase buffer length for query string by [@mwoolweaver](https://redirect.github.com/mwoolweaver) in [pi-hole/FTL#2709](https://redirect.github.com/pi-hole/FTL/pull/2709) - Reduce DNS resolver locking during database interaction by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2700](https://redirect.github.com/pi-hole/FTL/pull/2700) - Make colour output optional in streaming gravity API call by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/FTL#2718](https://redirect.github.com/pi-hole/FTL/pull/2718) - api/dhcp/leases Allow for hwaddr > 48 bits by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/FTL#2724](https://redirect.github.com/pi-hole/FTL/pull/2724) - Add rate-limiting for TOTP validation by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2719](https://redirect.github.com/pi-hole/FTL/pull/2719) - Implement simple partial matching for regex in /api/search/{domain} by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2705](https://redirect.github.com/pi-hole/FTL/pull/2705) - Performance optimizations: string processing, memory management, and compiler flags by [@Copilot](https://redirect.github.com/Copilot) in [pi-hole/FTL#2571](https://redirect.github.com/pi-hole/FTL/pull/2571) - Fix authentication redirect when webhome is / (fixes [#2518](https://redirect.github.com/pi-hole/docker-pi-hole/issues/2518)) by [@averyvigolo](https://redirect.github.com/averyvigolo) in [pi-hole/FTL#2610](https://redirect.github.com/pi-hole/FTL/pull/2610) - Reduce database locking and add timing debug setting by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2688](https://redirect.github.com/pi-hole/FTL/pull/2688) #### New Contributors - [@mwoolweaver](https://redirect.github.com/mwoolweaver) made their first contribution in [pi-hole/FTL#2709](https://redirect.github.com/pi-hole/FTL/pull/2709) - [@Copilot](https://redirect.github.com/Copilot) made their first contribution in [pi-hole/FTL#2571](https://redirect.github.com/pi-hole/FTL/pull/2571) - [@averyvigolo](https://redirect.github.com/averyvigolo) made their first contribution in [pi-hole/FTL#2610](https://redirect.github.com/pi-hole/FTL/pull/2610) **Full Changelog**: <pi-hole/FTL@v6.3.3...v6.4>   #### What's Changed (Web v6.4) - Start using commented tags for editorconfig-checker by [@yubiuser](https://redirect.github.com/yubiuser) in [pi-hole/web#3643](https://redirect.github.com/pi-hole/web/pull/3643) - Remove some unused code (leftover from v5) by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/web#3636](https://redirect.github.com/pi-hole/web/pull/3636) - Make sure the table is redrawn after the dnssec API call returns by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/web#3645](https://redirect.github.com/pi-hole/web/pull/3645) - Add hint that partial matching may not return all possible results by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/web#3654](https://redirect.github.com/pi-hole/web/pull/3654) - Enable one-time code autofill for TOTP input by [@sebastianlivoni](https://redirect.github.com/sebastianlivoni) in [pi-hole/web#3658](https://redirect.github.com/pi-hole/web/pull/3658) - Set "All Time " range for query log datepicker based on Database ranges (moment) by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/web#3657](https://redirect.github.com/pi-hole/web/pull/3657) - Request ANSI colour codes when calling gravity API by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/web#3662](https://redirect.github.com/pi-hole/web/pull/3662) - Pi-hole Web v6.4 by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/web#3670](https://redirect.github.com/pi-hole/web/pull/3670) #### New Contributors - [@sebastianlivoni](https://redirect.github.com/sebastianlivoni) made their first contribution in [pi-hole/web#3658](https://redirect.github.com/pi-hole/web/pull/3658) **Full Changelog**: <pi-hole/web@v6.3...v6.4> #### What's Changed (Core v6.3) - Add Fedora 43 to test suite by [@yubiuser](https://redirect.github.com/yubiuser) in [pi-hole/pi-hole#6453](https://redirect.github.com/pi-hole/pi-hole/pull/6453) - Fix libcap capabilities not being granted on OpenRC distros by [@Sparronator9999](https://redirect.github.com/Sparronator9999) in [pi-hole/pi-hole#6456](https://redirect.github.com/pi-hole/pi-hole/pull/6456) - systemd service - don't use deprecated PermissionsStartOnly by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/pi-hole#6465](https://redirect.github.com/pi-hole/pi-hole/pull/6465) - debug - speed up processing and display of file contents and services by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/pi-hole#6469](https://redirect.github.com/pi-hole/pi-hole/pull/6469) - Use port from dns.port in piholeDebug.sh by [@darkexplosiveqwx](https://redirect.github.com/darkexplosiveqwx) in [pi-hole/pi-hole#6475](https://redirect.github.com/pi-hole/pi-hole/pull/6475) - Improve gravity tables presentation on the debug log by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/pi-hole#6460](https://redirect.github.com/pi-hole/pi-hole/pull/6460) #### New Contributors - [@Sparronator9999](https://redirect.github.com/Sparronator9999) made their first contribution in [pi-hole/pi-hole#6456](https://redirect.github.com/pi-hole/pi-hole/pull/6456) **Full Changelog**: <pi-hole/pi-hole@v6.2.2...v6.3> </details> --- ### Configuration 📅 **Schedule**: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined). 🚦 **Automerge**: Enabled. ♻ **Rebasing**: Whenever PR is behind base branch, or you tick the rebase/retry checkbox. 🔕 **Ignore**: Close this PR and you won't be reminded about this update again. --- - [ ] If you want to rebase/retry this PR, check this box --- This PR was generated by [Mend Renovate](https://mend.io/renovate/). View the [repository job log](https://developer.mend.io/github/bigbeartechworld/big-bear-universal-apps).

This PR contains the following updates: | Package | Update | Change | |---|---|---| | [jacklul/pihole](https://redirect.github.com/pi-hole/docker-pi-hole) | patch | `2025.11.0` -> `2025.11.1` | --- ### Release Notes <details> <summary>pi-hole/docker-pi-hole (jacklul/pihole)</summary> ### [`v2025.11.1`](https://redirect.github.com/pi-hole/docker-pi-hole/releases/tag/2025.11.1) [Compare Source](https://redirect.github.com/pi-hole/docker-pi-hole/compare/2025.11.0...2025.11.1)  #### What's Changed (Docker Specific) - Fix build status badge in readme by [@nol166](https://redirect.github.com/nol166) in [#1938](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1938) - Add RISCV back by [@yubiuser](https://redirect.github.com/yubiuser) in [#1939](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1939) - Improve FTL startup detection and log tailing by [@PromoFaux](https://redirect.github.com/PromoFaux) in [#1940](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1940) - Set DNS listening mode to 'ALL' in docker-compose.yml example by [@cornshakes](https://redirect.github.com/cornshakes) in [#1946](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1946) - Add instructions for excluding Pi-hole from Watchtower updates by [@chippy01](https://redirect.github.com/chippy01) in [#1949](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1949) #### New Contributors - [@nol166](https://redirect.github.com/nol166) made their first contribution in [#1938](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1938) - [@cornshakes](https://redirect.github.com/cornshakes) made their first contribution in [#1946](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1946) - [@chippy01](https://redirect.github.com/chippy01) made their first contribution in [#1949](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1949) **Full Changelog**: <pi-hole/docker-pi-hole@2025.11.0...2025.11.1> ***  #### What's Changed (FTL v6.4.1) - Fix API specs and example for dns.upstreams in config.yaml by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/FTL#2696](https://redirect.github.com/pi-hole/FTL/pull/2696) - gravity update - silently discard unicode BOM if present by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/FTL#2702](https://redirect.github.com/pi-hole/FTL/pull/2702) - Update embedded SQLite to 3.51.0 by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2704](https://redirect.github.com/pi-hole/FTL/pull/2704) - Get earliest query timestamp from database by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/FTL#2706](https://redirect.github.com/pi-hole/FTL/pull/2706) - Increase buffer length for query string by [@mwoolweaver](https://redirect.github.com/mwoolweaver) in [pi-hole/FTL#2709](https://redirect.github.com/pi-hole/FTL/pull/2709) - Reduce DNS resolver locking during database interaction by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2700](https://redirect.github.com/pi-hole/FTL/pull/2700) - Make colour output optional in streaming gravity API call by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/FTL#2718](https://redirect.github.com/pi-hole/FTL/pull/2718) - api/dhcp/leases Allow for hwaddr > 48 bits by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/FTL#2724](https://redirect.github.com/pi-hole/FTL/pull/2724) - Add rate-limiting for TOTP validation by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2719](https://redirect.github.com/pi-hole/FTL/pull/2719) - Implement simple partial matching for regex in /api/search/{domain} by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2705](https://redirect.github.com/pi-hole/FTL/pull/2705) - Performance optimizations: string processing, memory management, and compiler flags by [@Copilot](https://redirect.github.com/Copilot) in [pi-hole/FTL#2571](https://redirect.github.com/pi-hole/FTL/pull/2571) - Fix authentication redirect when webhome is / (fixes [#2518](https://redirect.github.com/pi-hole/docker-pi-hole/issues/2518)) by [@averyvigolo](https://redirect.github.com/averyvigolo) in [pi-hole/FTL#2610](https://redirect.github.com/pi-hole/FTL/pull/2610) - Reduce database locking and add timing debug setting by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2688](https://redirect.github.com/pi-hole/FTL/pull/2688) #### New Contributors - [@mwoolweaver](https://redirect.github.com/mwoolweaver) made their first contribution in [pi-hole/FTL#2709](https://redirect.github.com/pi-hole/FTL/pull/2709) - [@Copilot](https://redirect.github.com/Copilot) made their first contribution in [pi-hole/FTL#2571](https://redirect.github.com/pi-hole/FTL/pull/2571) - [@averyvigolo](https://redirect.github.com/averyvigolo) made their first contribution in [pi-hole/FTL#2610](https://redirect.github.com/pi-hole/FTL/pull/2610) **Full Changelog**: <pi-hole/FTL@v6.3.3...v6.4>   #### What's Changed (Web v6.4) - Start using commented tags for editorconfig-checker by [@yubiuser](https://redirect.github.com/yubiuser) in [pi-hole/web#3643](https://redirect.github.com/pi-hole/web/pull/3643) - Remove some unused code (leftover from v5) by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/web#3636](https://redirect.github.com/pi-hole/web/pull/3636) - Make sure the table is redrawn after the dnssec API call returns by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/web#3645](https://redirect.github.com/pi-hole/web/pull/3645) - Add hint that partial matching may not return all possible results by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/web#3654](https://redirect.github.com/pi-hole/web/pull/3654) - Enable one-time code autofill for TOTP input by [@sebastianlivoni](https://redirect.github.com/sebastianlivoni) in [pi-hole/web#3658](https://redirect.github.com/pi-hole/web/pull/3658) - Set "All Time " range for query log datepicker based on Database ranges (moment) by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/web#3657](https://redirect.github.com/pi-hole/web/pull/3657) - Request ANSI colour codes when calling gravity API by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/web#3662](https://redirect.github.com/pi-hole/web/pull/3662) - Pi-hole Web v6.4 by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/web#3670](https://redirect.github.com/pi-hole/web/pull/3670) #### New Contributors - [@sebastianlivoni](https://redirect.github.com/sebastianlivoni) made their first contribution in [pi-hole/web#3658](https://redirect.github.com/pi-hole/web/pull/3658) **Full Changelog**: <pi-hole/web@v6.3...v6.4> #### What's Changed (Core v6.3) - Add Fedora 43 to test suite by [@yubiuser](https://redirect.github.com/yubiuser) in [pi-hole/pi-hole#6453](https://redirect.github.com/pi-hole/pi-hole/pull/6453) - Fix libcap capabilities not being granted on OpenRC distros by [@Sparronator9999](https://redirect.github.com/Sparronator9999) in [pi-hole/pi-hole#6456](https://redirect.github.com/pi-hole/pi-hole/pull/6456) - systemd service - don't use deprecated PermissionsStartOnly by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/pi-hole#6465](https://redirect.github.com/pi-hole/pi-hole/pull/6465) - debug - speed up processing and display of file contents and services by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/pi-hole#6469](https://redirect.github.com/pi-hole/pi-hole/pull/6469) - Use port from dns.port in piholeDebug.sh by [@darkexplosiveqwx](https://redirect.github.com/darkexplosiveqwx) in [pi-hole/pi-hole#6475](https://redirect.github.com/pi-hole/pi-hole/pull/6475) - Improve gravity tables presentation on the debug log by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/pi-hole#6460](https://redirect.github.com/pi-hole/pi-hole/pull/6460) #### New Contributors - [@Sparronator9999](https://redirect.github.com/Sparronator9999) made their first contribution in [pi-hole/pi-hole#6456](https://redirect.github.com/pi-hole/pi-hole/pull/6456) **Full Changelog**: <pi-hole/pi-hole@v6.2.2...v6.3> </details> --- ### Configuration 📅 **Schedule**: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined). 🚦 **Automerge**: Enabled. ♻ **Rebasing**: Whenever PR is behind base branch, or you tick the rebase/retry checkbox. 🔕 **Ignore**: Close this PR and you won't be reminded about this update again. --- - [ ] If you want to rebase/retry this PR, check this box --- This PR was generated by [Mend Renovate](https://mend.io/renovate/). View the [repository job log](https://developer.mend.io/github/bigbeartechworld/big-bear-universal-apps).

…ag to v2025.11.1 This PR contains the following updates: | Package | Update | Change | |---|---|---| | [bigbeartechworld/big-bear-pihole-unbound](https://redirect.github.com/pi-hole/docker-pi-hole) | patch | `2025.11.0` → `2025.11.1` | --- ### Release Notes <details> <summary>pi-hole/docker-pi-hole (bigbeartechworld/big-bear-pihole-unbound)</summary> ### [`v2025.11.1`](https://redirect.github.com/pi-hole/docker-pi-hole/releases/tag/2025.11.1) [Compare Source](https://redirect.github.com/pi-hole/docker-pi-hole/compare/2025.11.0...2025.11.1)  ##### What's Changed (Docker Specific) - Fix build status badge in readme by [@nol166](https://redirect.github.com/nol166) in [#1938](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1938) - Add RISCV back by [@yubiuser](https://redirect.github.com/yubiuser) in [#1939](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1939) - Improve FTL startup detection and log tailing by [@PromoFaux](https://redirect.github.com/PromoFaux) in [#1940](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1940) - Set DNS listening mode to 'ALL' in docker-compose.yml example by [@cornshakes](https://redirect.github.com/cornshakes) in [#1946](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1946) - Add instructions for excluding Pi-hole from Watchtower updates by [@chippy01](https://redirect.github.com/chippy01) in [#1949](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1949) ##### New Contributors - [@nol166](https://redirect.github.com/nol166) made their first contribution in [#1938](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1938) - [@cornshakes](https://redirect.github.com/cornshakes) made their first contribution in [#1946](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1946) - [@chippy01](https://redirect.github.com/chippy01) made their first contribution in [#1949](https://redirect.github.com/pi-hole/docker-pi-hole/pull/1949) **Full Changelog**: <pi-hole/docker-pi-hole@2025.11.0...2025.11.1> ***  ##### What's Changed (FTL v6.4.1) - Fix API specs and example for dns.upstreams in config.yaml by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/FTL#2696](https://redirect.github.com/pi-hole/FTL/pull/2696) - gravity update - silently discard unicode BOM if present by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/FTL#2702](https://redirect.github.com/pi-hole/FTL/pull/2702) - Update embedded SQLite to 3.51.0 by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2704](https://redirect.github.com/pi-hole/FTL/pull/2704) - Get earliest query timestamp from database by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/FTL#2706](https://redirect.github.com/pi-hole/FTL/pull/2706) - Increase buffer length for query string by [@mwoolweaver](https://redirect.github.com/mwoolweaver) in [pi-hole/FTL#2709](https://redirect.github.com/pi-hole/FTL/pull/2709) - Reduce DNS resolver locking during database interaction by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2700](https://redirect.github.com/pi-hole/FTL/pull/2700) - Make colour output optional in streaming gravity API call by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/FTL#2718](https://redirect.github.com/pi-hole/FTL/pull/2718) - api/dhcp/leases Allow for hwaddr > 48 bits by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/FTL#2724](https://redirect.github.com/pi-hole/FTL/pull/2724) - Add rate-limiting for TOTP validation by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2719](https://redirect.github.com/pi-hole/FTL/pull/2719) - Implement simple partial matching for regex in /api/search/{domain} by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2705](https://redirect.github.com/pi-hole/FTL/pull/2705) - Performance optimizations: string processing, memory management, and compiler flags by [@Copilot](https://redirect.github.com/Copilot) in [pi-hole/FTL#2571](https://redirect.github.com/pi-hole/FTL/pull/2571) - Fix authentication redirect when webhome is / (fixes [#2518](https://redirect.github.com/pi-hole/docker-pi-hole/issues/2518)) by [@averyvigolo](https://redirect.github.com/averyvigolo) in [pi-hole/FTL#2610](https://redirect.github.com/pi-hole/FTL/pull/2610) - Reduce database locking and add timing debug setting by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/FTL#2688](https://redirect.github.com/pi-hole/FTL/pull/2688) ##### New Contributors - [@mwoolweaver](https://redirect.github.com/mwoolweaver) made their first contribution in [pi-hole/FTL#2709](https://redirect.github.com/pi-hole/FTL/pull/2709) - [@Copilot](https://redirect.github.com/Copilot) made their first contribution in [pi-hole/FTL#2571](https://redirect.github.com/pi-hole/FTL/pull/2571) - [@averyvigolo](https://redirect.github.com/averyvigolo) made their first contribution in [pi-hole/FTL#2610](https://redirect.github.com/pi-hole/FTL/pull/2610) **Full Changelog**: <pi-hole/FTL@v6.3.3...v6.4>   ##### What's Changed (Web v6.4) - Start using commented tags for editorconfig-checker by [@yubiuser](https://redirect.github.com/yubiuser) in [pi-hole/web#3643](https://redirect.github.com/pi-hole/web/pull/3643) - Remove some unused code (leftover from v5) by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/web#3636](https://redirect.github.com/pi-hole/web/pull/3636) - Make sure the table is redrawn after the dnssec API call returns by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/web#3645](https://redirect.github.com/pi-hole/web/pull/3645) - Add hint that partial matching may not return all possible results by [@DL6ER](https://redirect.github.com/DL6ER) in [pi-hole/web#3654](https://redirect.github.com/pi-hole/web/pull/3654) - Enable one-time code autofill for TOTP input by [@sebastianlivoni](https://redirect.github.com/sebastianlivoni) in [pi-hole/web#3658](https://redirect.github.com/pi-hole/web/pull/3658) - Set "All Time " range for query log datepicker based on Database ranges (moment) by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/web#3657](https://redirect.github.com/pi-hole/web/pull/3657) - Request ANSI colour codes when calling gravity API by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/web#3662](https://redirect.github.com/pi-hole/web/pull/3662) - Pi-hole Web v6.4 by [@PromoFaux](https://redirect.github.com/PromoFaux) in [pi-hole/web#3670](https://redirect.github.com/pi-hole/web/pull/3670) ##### New Contributors - [@sebastianlivoni](https://redirect.github.com/sebastianlivoni) made their first contribution in [pi-hole/web#3658](https://redirect.github.com/pi-hole/web/pull/3658) **Full Changelog**: <pi-hole/web@v6.3...v6.4> ##### What's Changed (Core v6.3) - Add Fedora 43 to test suite by [@yubiuser](https://redirect.github.com/yubiuser) in [pi-hole/pi-hole#6453](https://redirect.github.com/pi-hole/pi-hole/pull/6453) - Fix libcap capabilities not being granted on OpenRC distros by [@Sparronator9999](https://redirect.github.com/Sparronator9999) in [pi-hole/pi-hole#6456](https://redirect.github.com/pi-hole/pi-hole/pull/6456) - systemd service - don't use deprecated PermissionsStartOnly by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/pi-hole#6465](https://redirect.github.com/pi-hole/pi-hole/pull/6465) - debug - speed up processing and display of file contents and services by [@rrobgill](https://redirect.github.com/rrobgill) in [pi-hole/pi-hole#6469](https://redirect.github.com/pi-hole/pi-hole/pull/6469) - Use port from dns.port in piholeDebug.sh by [@darkexplosiveqwx](https://redirect.github.com/darkexplosiveqwx) in [pi-hole/pi-hole#6475](https://redirect.github.com/pi-hole/pi-hole/pull/6475) - Improve gravity tables presentation on the debug log by [@rdwebdesign](https://redirect.github.com/rdwebdesign) in [pi-hole/pi-hole#6460](https://redirect.github.com/pi-hole/pi-hole/pull/6460) ##### New Contributors - [@Sparronator9999](https://redirect.github.com/Sparronator9999) made their first contribution in [pi-hole/pi-hole#6456](https://redirect.github.com/pi-hole/pi-hole/pull/6456) **Full Changelog**: <pi-hole/pi-hole@v6.2.2...v6.3> </details> --- ### Configuration 📅 **Schedule**: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined). 🚦 **Automerge**: Enabled. ♻ **Rebasing**: Whenever PR is behind base branch, or you tick the rebase/retry checkbox. 🔕 **Ignore**: Close this PR and you won't be reminded about this update again. --- - [ ] If you want to rebase/retry this PR, check this box --- This PR was generated by [Mend Renovate](https://mend.io/renovate/). View the [repository job log](https://developer.mend.io/github/bigbeartechworld/big-bear-universal-apps).

PromoFaux requested a review from a team as a code owner November 9, 2025 14:15

PromoFaux changed the title ~~Merge pull request #2694 from pi-hole/master~~ Get earliest query timestamp from database Nov 9, 2025

PromoFaux force-pushed the new/earliest_timestamp branch from bb91f91 to 5df02b5 Compare November 9, 2025 14:37

DL6ER requested changes Nov 9, 2025

View reviewed changes

Comment thread src/database/query-table.c

Comment thread src/api/docs/content/specs/info.yaml Outdated

Comment thread src/api/docs/content/specs/info.yaml Outdated

Changes based on review comments

7d5d355

Signed-off-by: Adam Warner <me@adamwarner.co.uk>

PromoFaux requested a review from DL6ER November 9, 2025 20:43

DL6ER approved these changes Nov 9, 2025

View reviewed changes

DL6ER merged commit 5ce1ca2 into development Nov 9, 2025
18 checks passed

DL6ER deleted the new/earliest_timestamp branch November 9, 2025 21:06

rdwebdesign mentioned this pull request Nov 11, 2025

Bug on the new get_number_of_queries_in_DB() function. #2708

Closed

mwoolweaver mentioned this pull request Nov 11, 2025

Increase buffer length for query string #2709

Merged

1 task

PromoFaux mentioned this pull request Nov 25, 2025

Pi-hole FTL v6.4 #2726

Merged

viaggvi mentioned this pull request Apr 3, 2026

Dashboard graphs show stale historical data after extended FTL uptime — fixed by restarting FTL #2828

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Get earliest query timestamp from database#2706

Get earliest query timestamp from database#2706
DL6ER merged 2 commits into
developmentfrom
new/earliest_timestamp

PromoFaux commented Nov 9, 2025

Uh oh!

PromoFaux commented Nov 9, 2025

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

pralor-bot commented Nov 27, 2025

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants

Uh oh!

Conversation

PromoFaux commented Nov 9, 2025

What does this PR aim to accomplish?:

Uh oh!

PromoFaux commented Nov 9, 2025

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

pralor-bot commented Nov 27, 2025

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants