I’m running the following SQL, although I’m not actually sure it’s as necessary since 0.18.3. It doesn’t delete any post history or anything.

DELETE FROM activity WHERE published < NOW() - INTERVAL '1 day';

Hugo calls these sorts of things “frontends” and has a list here: https://gohugo.io/tools/frontends/

I haven’t had great luck with any of them personally.

It’s free as in “paying zero money”. It’s still distributed via leanpub. Requires an email address to get to the download page, it doesn’t verify it in any way other than being a valid email format. Links are to DRM-free epub and PDF.

I believe the activity table in Postgres is retained for 6 months (although I’m purging mine daily) and the pict-rs cache is 168 hours (1 week).

I’m running a Kubernetes cluster on the Dell hardware, then another single node k8s cluster on the Lenovo, mostly to run Adguard home / DNS in case the big cluster goes down for whatever reason.

Hardware:

• Two Dell r610s, each with 12 cores and 96 GB of RAM, running ESXi 6.7
• Lenovo M900, 4 core, 16 GB RAM, Ubuntu and k3s
• Synology 1515 with 12 TB usable
• Synology 1517 with 32 TB usable
• Juniper SRX 220H (Firewall)
• Juniper EX 2200 48 port switch
• UnFi in-wall WiFi APs

I run the following services, all in Kubernetes, with FluxCD doing GitOps from a repo in GitHub (for now, might move to Gitea later):

• Authentik
• Bookstack
• Calibre
• Flame (Homepage)
• Frigate NVR
• Home Assistant
• Memos
• Monica
• Plex
• Prowlarr
• Radarr
• Rocket Chat
• Sonarr
• Tandoor
• Tautulli
• Unifi
• UptimeKuma
• VS Code
• Zigbee2MQTT