Jeffrey Paul sneak
sneak pushed to main at sneak/routewatch 2025-07-28 17:21:51 +02:00
40d7f0185b Optimize database batch operations with prepared statements
b9b0792df9 Fix shutdown handling and optimize SQLite settings
21921a170c Optimize database performance to fix slow queries
78d6e17c76 Add debug logging and optimize SQLite performance
9b649c98c9 Fix AS detail view and add prefix sorting
Compare 10 commits »
sneak pushed to main at sneak/routewatch 2025-07-28 03:44:27 +02:00
2fc24bb937 Add route age information to IP lookup API
sneak pushed to main at sneak/routewatch 2025-07-28 03:31:59 +02:00
691710bc7c Add /api/v1/ip/<ip> endpoint for IP to AS lookups
sneak pushed to main at sneak/routewatch 2025-07-28 03:26:22 +02:00
afb916036c Fix handler processing time display for sub-millisecond values
sneak pushed to main at sneak/routewatch 2025-07-28 03:23:39 +02:00
13047b5cb9 Add IPv4 range optimization for IP to AS lookups
sneak pushed to main at sneak/routewatch 2025-07-28 03:02:51 +02:00
d929f24f80 Remove RoutingTableHandler and snapshotter, use database for route stats
sneak pushed to main at sneak/routewatch 2025-07-28 02:55:32 +02:00
cb1f4d9052 Add route update metrics tracking to PrefixHandler
sneak pushed to main at sneak/routewatch 2025-07-28 02:50:11 +02:00
bc640b0b37 Reduce all handler queue sizes to 100,000
sneak pushed to main at sneak/routewatch 2025-07-28 02:40:24 +02:00
7d814c9d2d Optimize SQLite and PrefixHandler for better performance
sneak pushed to main at sneak/routewatch 2025-07-28 02:36:22 +02:00
54bb0ba1cb Simplify peerings table to store AS numbers directly
sneak pushed to main at sneak/routewatch 2025-07-28 02:31:13 +02:00
1157003db7 Refactor database handlers and optimize PeeringHandler
sneak pushed to main at sneak/routewatch 2025-07-28 02:16:20 +02:00
eaa11b5f8d Move prefixes table maintenance from DBHandler to PrefixHandler
sneak pushed to main at sneak/routewatch 2025-07-28 02:11:10 +02:00
8b43882526 Increase batch sizes to 10000 and queue sizes to 200000, reduce timeout to 2s
sneak pushed to main at sneak/routewatch 2025-07-28 02:07:39 +02:00
eda90d96a9 Remove debug logging for withdrawals without origin ASN
3c46087976 Add live routing table with CIDR mask length tracking
cea7c3dfd3 Rename handlers and add PrefixHandler for database routing table
Compare 3 commits »
sneak pushed to main at sneak/routewatch 2025-07-28 01:16:37 +02:00
3aef3f9a07 Format logger source location as file.go:linenum
sneak pushed to main at sneak/routewatch 2025-07-28 01:14:58 +02:00
67f6b78aaa Add custom logger with source location tracking and remove verbose database logs
sneak pushed to main at sneak/routewatch 2025-07-28 01:03:16 +02:00
3f06955214 Increase batch sizes and timeouts for better throughput
sneak pushed to main at sneak/routewatch 2025-07-28 01:01:33 +02:00
155c08d735 Implement batched database operations for improved performance
sneak pushed to main at sneak/routewatch 2025-07-28 00:55:16 +02:00
d15a5e91b9 Inject Config as dependency for database, routing table, and snapshotter
1a0622efaa Add handler queue metrics to status page
Compare 2 commits »
sneak pushed to main at sneak/routewatch 2025-07-28 00:28:00 +02:00
6593a7be76 Add database file size and reorganize status page