Database Documentation
Closed this issue · 3 comments
It has to be a relational databse that is hosted somewhere online. Maybe bit.io but I am open to other ideas? I think we are going to be running lots of requests so the nicer their free plan is the better.
Here is an initial pass at a Schema:
https://miro.com/welcomeonboard/aHNFUVluemZ3N2hXWmdmdVBOSFRBMFJkNVFuUXVRdDdjSW5Da05LVXZObWVMZEZseG81NlBYRmU0Rk1yWFpmT3wzNDU4NzY0NTYxNTg5Mjc5MzQzfDI=?share_link_id=924271553769
I just added everything that we will have from the Eve API pulls.
Something interesting that I hadn't thought about is the fact that the history and the active order pulls are very different.
I'm not sure how to actually integrate the current prices into what we are doing. Maybe a separate model after we have built up our own history? I am not sure.
Also digging around free hosted Postgres. Fly.io is looking like a good contender:
https://fly.io/docs/about/pricing/
I think 3 gb of storage should be more than enough.
The second question is do we have a seperate local database for model stuff? That I'm still not sure yet, maybe we could get away with thick CSV files in the beginning?
Closing this