routers(): Randomly select ip addresses to represent routers

ethanjweiner / visualize-the-web

A geographic visualizer of HTTP requests across long distances, built with Python and Flask

2 stars 1 forks source link

routers(): Randomly select ip addresses to represent routers #1

Closed ethanjweiner closed 3 years ago

ethanjweiner commented 3 years ago

Import csv file into database?
Select coordinates directly from csv reader?
Add ip addresses to routers.db

ethanjweiner commented 3 years ago

Decide between selecting from .csv file VS

Try csv first
If loading from csv reader is too slow --> use SQL database instead

ethanjweiner commented 3 years ago

Indexing into .csv file to get routers was too slow. Will now try creating a SQL database (with the .csv) instead, and querying from that -- hopefully the querying process is much faster.

ethanjweiner commented 3 years ago

Ended up loading the routers from a sqlite3 database into an Python that is passed to the client side.