search

nycmeshnet / meshdb

A convenient, stable, and sane database for tracking Members and Nodes for use with robots and humans
https://db.nycmesh.net
MIT License
12 stars 14 forks source link

Add node-explorer data to SQL explorer #639

Open Andrew-Dickinson opened 1 month ago

Andrew-Dickinson commented 1 month ago

Make node explorer data available in sql-explorer so that for example, you can join dependent nodes in with queries of meshdb metadata.

I think we can use psql-http to create a stored procedure or VIEW which queries node-explorer / outage-analyzer, and provides the result in tabular format

Andrew-Dickinson commented 1 month ago

https://nycmesh.slack.com/archives/C06GW3Q92TY/p1728523132885009?thread_ts=1728520828.456049&cid=C06GW3Q92TY

Andrew-Dickinson commented 1 month ago

Could also do some kind of ETL job as a celery worker that fills up a table with the data