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.

Sign up for GitHub

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

Jump to bottom

Proper Database Structure? #49

Open
Rustypredator opened this issue Jan 19, 2019 · 1 comment
Open

Proper Database Structure? #49

Rustypredator opened this issue Jan 19, 2019 · 1 comment

Comments

@Rustypredator
Copy link

Hi, Im currently in the progress of creating a simple webinterface, and i stumbled upon the Database Structure, wich goes against anything i know about proper Database Design.
Now, im no Professional, but i had my fair share of Lessons in school about database normalization.
May i create a Pull request with a Database design i think would work better?
@games647
Copy link
Owner

Of course. I appreciate any help.

Rustypredator added a commit to Rustypredator/LagMonitor that referenced this issue May 5, 2019
@Rustypredator
Update DB Structure
23c3c91 
Reference Issue: games647#49   
The Changes make sure, that you do'nt have duplicate data in the Database by separating the Data, that changes from the data that is static.  
That way you'll also save space (a little).
  
e.g. every player would only need to be created once. the Ping data will go into `player_data`
same with worlds.
  
if there are any questions i'll be happy to answer :)
@Rustypredator Rustypredator mentioned this issue May 5, 2019
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@games647 @Rustypredator