Skip to content

feature: query aggregate data over RIB #112

@ties

Description

@ties

Hi,

I have a rotonda instance with a significant amount of data in it. I want to query simple aggregate statistics over the routing tables in there, and I think this may warrant an API endpoint that returns less data (it also does not necessarily need to be json, grpc, arrow flight, etc may be good alternatives).

$ time curl curl -s http://localhost:8080/prefixes/193.0.0.0/20?include=moreSpecifics > /dev/null
real    0m0.341s
user    0m0.004s
sys     0m0.008s
$ curl curl -s http://localhost:8080/prefixes/193.0.0.0/20?include=moreSpecifics | wc -l
388679
$ curl curl -s http://localhost:8080/prefixes/193.0.0.0/20?include=moreSpecifics | jq '.included.moreSpecifics[] | "\(.p
refix) \(.attributes[] | select(.asPath) | .asPath[-1])"' | sort | uniq -c
    386 "193.0.0.0/21 AS3333"
    386 "193.0.10.0/23 AS3333"
    386 "193.0.12.0/23 AS3333"
    430 "193.0.14.0/23 AS25152"
    485 "193.0.14.0/24 AS25152"
    453 "193.0.15.0/24 AS25152"
    419 "193.0.8.0/23 AS197000"
    431 "193.0.8.0/24 AS197000"
    441 "193.0.9.0/24 AS197000"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions