Joined: 18/03/2023 16:31:14
I have created an ETL process to produce csv files from the allCountries.txt and some of the other files. These csv files can then be imported into Kuzu DB (https://kuzudb.com) - a graph database.
Graph databases are powerful when it comes to data that is related to each other. So I have created nodes for: Geographical points, countries, continent, features and admin divisions and connected them.
If you want to have a look, my project is on github: https://github.com/uwegeercken/tweakstreet-kuzudb