Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Another DB redesign #253

Open
SayakMukhopadhyay opened this issue Jun 30, 2021 · 1 comment
Open

Another DB redesign #253

SayakMukhopadhyay opened this issue Jun 30, 2021 · 1 comment
Assignees

Comments

@SayakMukhopadhyay
Copy link
Member

Right now, the DB is denormalised to a certain extent which is creating scaling problems with the constantly changing landscape of Elite. Perhaps the db should be fully normalised with master tables for system, faction and stations, a mapping table between system and faction and a full history table for each.

But that still begs the question how can we maintain the history of the mapping between system and faction. Will need to think about these in V6.

As for the data, I can try replaying the data from https://edgalaxydata.space/EDDN/. The oldest data I have is from 8/10/2017 whereas the oldest data in edgalaxydata is 8/2017

@SayakMukhopadhyay
Copy link
Member Author

Make sure to index coordinates so that it can utilised while searching systems in bounding boxes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant