From 4325a6d9dc0d0dbc07091dac616e72d61d79ef2b Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Sat, 1 Jul 2023 19:35:35 +0200 Subject: [PATCH] Continued: - how to maintain (check for bad entries in `instances`) added --- README.md | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/README.md b/README.md index f0fb65c..db37a0e 100644 --- a/README.md +++ b/README.md @@ -58,6 +58,14 @@ systemctl enable --now fedi_block_api https://fba.ryona.agency/ uses an older code than this one. So it doesn't reflect this code here. My FBA sub-domain is currently password-protected as I still need to fix some performance issues with large blocking lists. +## Maintenance + +Run these SQL queries from time to time. They always should return zero. + +```sql +SELECT COUNT(blocked) AS cnt FROM blocks LEFT JOIN instances ON blocks.blocked = instances.domain OR blocks.blocker = instances.domain WHERE domain IS NULL LIMIT 1; +SELECT COUNT(domain) AS cnt FROM instances WHERE nodeinfo_url IS NOT NULL AND software IS NULL LIMIT 1; +``` ## License [AGPLv3](https://gnu.org) -- 2.39.5