--- a/libnumdb2/Makefile	Mon Aug 14 13:10:38 2023 -0800
+++ b/libnumdb2/Makefile	Mon Aug 14 13:17:07 2023 -0800
@@ -1,6 +1,6 @@
 CC=	gcc
 CFLAGS=	-O2
-OBJS=	readbin.o
+OBJS=	readbin.o refresh.o
 LIB=	libnumdb.a
 
 all:	${LIB}

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/libnumdb2/refresh.c	Mon Aug 14 13:17:07 2023 -0800
@@ -0,0 +1,52 @@
+/*
+ * Long-running ThemWi daemon processes need to be able to pick up updates
+ * to the number database without being restarted.  Whenever they need to
+ * consult the number db when handling a new call setup or equivalent,
+ * they will call refresh_number_db(), which does a stat on the file,
+ * followed by a re-read if the file has changed.
+ */
+
+#include <sys/types.h>
+#include <sys/stat.h>
+#include <stdio.h>
+#include <stdint.h>
+#include <stdlib.h>
+#include <syslog.h>
+#include "../include/number_db_v2.h"
+
+extern char numdb_pathname[];
+extern struct stat numdb_file_stat;
+extern struct owned_number_rec *numdb_owned_numbers;
+extern struct short_number_rec *numdb_short_numbers;
+
+refresh_number_db()
+{
+	int rc;
+	struct stat st;
+
+	rc = stat(numdb_pathname, &st);
+	if (rc < 0) {
+		syslog(LOG_CRIT, "unable to stat %s for refresh: %m",
+			numdb_pathname);
+		return(-1);
+	}
+	if (st.st_mtime == numdb_file_stat.st_mtime &&
+	    st.st_ctime == numdb_file_stat.st_ctime &&
+	    st.st_size  == numdb_file_stat.st_size)
+		return(0);
+	if (numdb_owned_numbers) {
+		free(numdb_owned_numbers);
+		numdb_owned_numbers = 0;
+	}
+	if (numdb_short_numbers) {
+		free(numdb_short_numbers);
+		numdb_short_numbers = 0;
+	}
+	rc = read_number_db();
+	if (rc < 0) {
+		syslog(LOG_CRIT, "error reading %s on refresh!",
+			numdb_pathname);
+		exit(1);
+	}
+	return(1);
+}