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
834672c846
Improve delete function speed & order of ops
2026-05-21 12:05:16 -07:00
Owen Schwartz
b8180d848a
Merge pull request #3118 from Adityakk9031/#3105
...
Fix public resource health with unknown WireGuard targets
2026-05-20 16:20:25 -07:00
Owen
6337cf4359
Fix #3104
2026-05-20 16:14:47 -07:00
Owen
d65128671c
Fix logo url
2026-05-20 14:18:55 -07:00
Owen
2704202ba9
Add button to rebuid cache
2026-05-20 12:08:20 -07:00
Owen
1442faa740
Prevent concurrent rebuilds
2026-05-20 11:46:59 -07:00
Owen
6aa589e612
Block adds to clients in jit mode
2026-05-20 11:35:15 -07:00
Owen
4b1a8e14c4
Put long running into the background to end transaction
2026-05-20 11:18:47 -07:00
Owen
1a0db10b1a
Verify button to verify cache
2026-05-20 11:15:15 -07:00
Owen
b7634086db
Just accept any url for now
2026-05-20 10:47:37 -07:00
Aditya kumar singh
a6469e67a8
Fix public resource health with unknown WireGuard targets
2026-05-20 09:05:05 +05:30
Owen
08a08e73b3
derived only from roles that the user holds AND are assigned to the target resource
2026-05-19 10:53:54 -07:00
Owen
6e4a28f227
Add site information as well
2026-05-14 18:02:42 -07:00
Owen
d58b96f4b1
Add port and icmp information to api endpoint
2026-05-14 17:39:22 -07:00
Owen
6422208f69
Optimize get all relays
2026-05-14 16:59:15 -07:00
Owen
c3ebc423b5
Each node should only update its own sites
2026-05-14 16:51:09 -07:00
Owen
78ad2d17c7
Optimize building aliases in jit mode
2026-05-14 12:25:05 -07:00
Owen
5a8de8210b
Further optimizations
2026-05-14 11:59:59 -07:00
Owen
0e0666cacf
Optimize this
2026-05-14 11:34:09 -07:00
Owen
92a06e0ea3
Handle jit mode with syncs
2026-05-13 14:00:43 -07:00
Owen
c16d2ff2ed
Fix log message
2026-05-13 13:52:35 -07:00
Owen
73a4d7d351
Quiet log message
2026-05-13 11:57:02 -07:00
Owen
efb1d69ac9
Add migration
2026-05-12 20:59:58 -07:00
Owen
77d17af15b
Add global hide_powered_by and make it backward
2026-05-11 16:18:57 -07:00
Owen
a066a68e1a
Pick the most specific domain
...
Fixes #3047
2026-05-11 11:28:32 -07:00
miloschwartz
9fb677e952
allow editing self and owner user roles
2026-05-08 17:48:43 -07:00
Owen
27d230647f
Merge branch 's3' into dev
2026-05-08 17:05:39 -07:00
Owen
114486608e
Add client endpoint to network log
2026-05-08 17:04:58 -07:00
Owen
10fa9274d0
Add streaming errors for debug
2026-05-08 16:27:40 -07:00
Owen
cbdc74768f
Implement s3 streaming destination
2026-05-07 21:09:21 -07:00
Owen
5b8994d143
Cange to use primaryDb
2026-05-07 20:07:06 -07:00
Owen
c46ef2fe9c
Fix ts type issue
2026-05-07 20:03:48 -07:00
Owen
ce04ea9720
Fix not including today
...
Fixes #3028
2026-05-07 16:15:13 -07:00
Owen
a3ce382725
Pick up other domains in the sans field
2026-05-07 15:49:12 -07:00
Owen
4eb49e3e60
Make the rebuild long running function background
2026-05-07 15:40:34 -07:00
Owen
8ed01372b8
Add org to logs
2026-05-07 15:14:44 -07:00
Owen
7bc08c0425
If not exists on trial table
2026-05-06 20:00:23 -07:00
Owen
72e48a56df
Remove explicit call
2026-05-06 16:58:28 -07:00
Owen
b046ab7513
Add locks to allocations
2026-05-06 15:58:51 -07:00
Owen
65ee9b9544
Add transaction to alias address picking
2026-05-06 15:53:46 -07:00
Owen
49c7319342
Format and make the error a warning
2026-05-06 15:51:05 -07:00
Owen
ce7df5ddaa
Update log message
2026-05-06 15:19:13 -07:00
Owen
af1739fbcb
Bump version
2026-05-06 15:15:03 -07:00
Owen
f01c9ee41c
Try to fix time issue
...
Fixes #3007
2026-05-06 14:45:18 -07:00
Owen
19f8956218
Support flattened data fields
2026-05-06 14:30:57 -07:00
Owen
adf4a1ffda
Link to http private resources
2026-05-06 11:03:38 -07:00
Owen
7d67fb9984
Make sure the domain is defined on a http resource
2026-05-05 20:07:06 -07:00
miloschwartz
66fda553e4
introduce caching in calculate func
2026-05-05 14:12:02 -07:00
miloschwartz
2ecf076c0f
don't await second calculate func
2026-05-05 12:37:52 -07:00