[MapServer-users] mapcache: time dimension default value and psql list_query

[Trygve Aspenes]

Hi mapserver users list

I have a mapserver backend with mapcache to handle the tile queries and 
psql as a db.

It's working but I have some details I'm trying to improve.

1: The time dimension has a default value. The client I server data to 
require this. I have 1 week of data available adding more data every 5 
minute ( and deleting old data). Therefor the hard coded default value 
quickly become out of range. ie:

<dimension type="postgresql" name="time" default="2022-11-29T12:00:00Z" 
time="true" unit="ISO8601">

Is there a way to make the default value be the newest value from my 
psql?
(an emergency solution will be to make some kind of script that 
continuously update this value somehow, but I hoped to avoid that.)

2: I think I understand that <list_query> list all timestamps values 
from the psql. This will be visible in the mapcache getcapabilities as a 
list of timestamps, 2016 stamps with data every 5 minutes for one week. 
Like
<Dimension name="time" default="2022-11-29T12:00:00Z" 
units="ISO8601">2023-03-23T00:00:00Z, <!-- very long list --> 
2023-03-30T13:30:00Z</Dimension>

Is there a way to make a start/end/step kind of list? eg 
2023-03-23T00:00:00Z/2023-03-30T13:30:00Z/PT5M

Thanks

Trygve Aspenes