43 Commits

Author	SHA1	Message	Date
bishnubista	817e848d08	fix(audit-logs): route request audit log reads through logsDb ... Route the read paths in queryRequestAuditLog.ts and queryRequestAnalytics.ts through `logsDb` instead of `primaryLogsDb`, matching the existing private audit log routes (queryActionAuditLog, queryAccessAuditLog, queryConnectionAuditLog all already use `logsDb`). In PostgreSQL deployments configured with a read replica via `withReplicas` (see server/db/pg/logsDriver.ts), this keeps high-volume audit log reads off the primary. No-op in OSS-SQLite where `logsDb === primaryDb`. Investigated rewriting `queryUniqueFilterAttributes` per the in-line TODO ("SOMEONE PLEASE OPTIMIZE THIS!!!!!"). A candidate rewrite using UNION ALL with six GROUP BY...LIMIT 500 arms benchmarked 48-61% slower than the current SELECT DISTINCT LIMIT 501 approach on SQLite (100k/300k/1M rows, 20 runs each): each grouped arm materializes a temp B-tree before applying LIMIT, while DISTINCT short-circuits via hash dedup with early exit. A materialized facets table is likely the right long-term fix, not a query-shape rewrite.	2026-05-25 10:37:47 -07:00
Owen	114486608e	Add client endpoint to network log	2026-05-08 17:04:58 -07:00
Owen	789b991c56	Logging and http working	2026-04-12 15:08:17 -07:00
Owen	2c6e9507b5	Connection log page working	2026-03-23 21:41:53 -07:00
Owen	6471571bc6	Add ui for connection logs	2026-03-23 20:18:03 -07:00
miloschwartz	4cab693cfc	openapi and swagger ui improvements and cleanup	2026-03-03 14:54:17 -08:00
Owen	b622aca221	Try to route logs requests to a different database	2026-02-20 17:20:01 -08:00
Owen	5c67a1cb12	Format	2025-12-22 16:28:41 -05:00
Owen	221ee6a1c2	Remove warning for limit	2025-12-22 14:07:49 -05:00
Owen	3e01bfef7d	Move primaryDb into driver	2025-12-18 17:08:50 -05:00
Owen	6b609bb078	Force big queries onto primary db to prevent 40001	2025-12-18 16:03:15 -05:00
depado	16653dd524	fix(database): filter dates evaluated at module load time	2025-12-18 10:06:31 -05:00
miloschwartz	f81909489a	add client telmetry and fix missing openapi on prefault	2025-12-11 10:38:48 -05:00
Fred KISSIE	f9c0e0ec3d	💬 updated text	2025-12-10 03:56:08 +01:00
Fred KISSIE	df4b9de334	🚧 wip: export limits	2025-12-10 03:24:32 +01:00
Fred KISSIE	d490cab48c	Merge dev into fix/log-analytics-adjustments	2025-12-10 03:19:14 +01:00
Fred KISSIE	9db2feff77	♻️ set default time to 7 days ago in API too	2025-12-09 00:17:34 +01:00
Fred KISSIE	adf76bfb53	♻️ set default start time to 7 days ago	2025-12-08 23:56:28 +01:00
Fred KISSIE	e0a79b7d4d	♻️ set default log analytics time range to. 7days ago	2025-12-08 22:57:05 +01:00
miloschwartz	a746ef36a8	Merge branch 'dev' into clients-user	2025-12-04 11:38:05 -05:00
miloschwartz	4b580105cd	change default sort on logs tables closes #1907	2025-12-03 18:20:28 -05:00
Fred KISSIE	3f440f0f7a	🏷️ fix type for SQLite	2025-11-21 06:10:01 +01:00
Fred KISSIE	ba6defa87c	✨Add request by day chart	2025-11-21 06:03:34 +01:00
Fred KISSIE	a42d012788	✨load logs per day	2025-11-21 04:48:01 +01:00
Fred KISSIE	5fd64596eb	✨add top countries list	2025-11-21 02:00:47 +01:00
Fred KISSIE	5d1f81a92c	✨ world map	2025-11-20 08:19:11 +01:00
Fred KISSIE	dc237b8052	💬 update text message from the API	2025-11-20 03:19:43 +01:00
Fred KISSIE	cd76fa0139	✨add analytics endpoint	2025-11-20 02:55:33 +01:00
Fred KISSIE	af4b9e83f7	✏️ fix typos	2025-11-20 02:55:03 +01:00
miloschwartz	02fbc279b5	add email consent and update audience	2025-11-17 20:37:24 -05:00
Lokowitz	5d2f65daa9	fix for zod	2025-11-17 13:23:30 +00:00
Lokowitz	7db99a7dd5	used zod codemod	2025-11-16 14:18:17 +00:00
Owen	ebd99f95a3	Also order by id	2025-10-29 17:37:29 -07:00
Owen	c6f7be40df	Sort by descending	2025-10-29 16:16:25 -07:00
Owen	68f0c4df3a	Working on licencing	2025-10-24 10:11:28 -07:00
Owen	921285e5b1	Filtering on all tables	2025-10-23 15:33:29 -07:00
Owen	264bf46798	Filtering working on both access and request	2025-10-23 14:34:56 -07:00
Owen	eae2c37388	Add expandable columns	2025-10-22 18:21:54 -07:00
Owen	0211f75cb6	Access logs working	2025-10-22 17:42:27 -07:00
Owen	7f981f05fb	Show resource link in table for requests	2025-10-22 14:58:18 -07:00
Owen	f2c31d3ca6	Add actor data to request	2025-10-22 14:27:21 -07:00
Owen	f748c5dbe4	Basic request log working	2025-10-22 12:23:48 -07:00
Owen	1f50bc3752	Add logActionAudit and query endpoint	2025-10-19 21:53:00 -07:00