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

Extract certificates to their own database table #30

Open
daveschaefer opened this issue Jan 18, 2014 · 3 comments
Open

Extract certificates to their own database table #30

daveschaefer opened this issue Jan 18, 2014 · 3 comments

Comments

@daveschaefer
Copy link
Collaborator

We currently duplicate a lot of information storing the certificate fingerprint inside the observations table. We should move our data back to Third Normal Form and move cert info into it's own table.

@daveschaefer
Copy link
Collaborator Author

In my test with a copy of notary1's data this shrunk the database size by 66%. This would also allow us to properly store other information about certificates, as mentioned in #9 .

@daveschaefer
Copy link
Collaborator Author

Leaving this until we have implemented TLS functionality may be nice, as then the existing v2 notaries could be upgraded with only one set of table changes. They could then be upgraded again with another schema change later.

@daveschaefer
Copy link
Collaborator Author

As per #19, if we plan to implement https mostly by using another server in front of cherrypy, then waiting for HTTPS functionality before we change the database structure isn't the best order of priorities. We should fix the database structure sooner so that we can begin using new hashes ( #22 ).

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

No branches or pull requests

1 participant