ryansurf / cli-surf

Get surf and ocean data from the command line interface
MIT License
18 stars 30 forks source link

Database #79

Open ryansurf opened 2 months ago

ryansurf commented 2 months ago

I was thinking we could implement a database that can keep track of daily surf data. We can then add a feature to display historical data in streamlit/the command line

@K-dash thoughts?

K-dash commented 2 months ago

Hi! @ryansurf

Implementing a database is an interesting initiative! When implementing a database, I believe we need to consider the following points:

Benefits of Implementing a Database to Store Historical Ocean Data

I believe the main benefits are:

What are your thoughts on this?

Database Deployment and Usage

While using free cloud-based managed database services is an option, it would require users to create individual accounts, potentially decreasing user convenience. Given that the current focus is on local environment usage, I think a configuration where the database can be easily set up using Docker Compose would be more appropriate.

Potential Database Candidates

I believe relational databases (MySQL or PostgreSQL) would work well, but it might also be interesting to adopt a document-oriented NoSQL database like MongoDB. It might be best to decide based on how you plan to utilize the stored data and considering the structure of the data to be stored!

ryansurf commented 2 months ago

@K-dash predictive analysis would be awesome!

I think analyzing seasonal variations/year-to-year changes would be interesting... especially with temperature data.

I was also thinking using a locally setup database, using Docker seems like the right choice.

I was thinking a NoSQL db like MongoDB would be a good candidate. I like the JSON structure :grin:

ruhi47 commented 1 month ago

Hey @ryansurf , How about building implementing this using a SVM model, it has good accuracy and feeding historical data at first and then real-time afterwards. I have experience in building something like this. Assign me please! Thank you!

ryansurf commented 1 month ago

Hey @ryansurf ,

How about building implementing this using a SVM model, it has good accuracy and feeding historical data at first and then real-time afterwards. I have experience in building something like this. Assign me please! Thank you!

Hello @ruhi47!

Sorry for the late response, I've been on vacation. That sounds great, I haven't used an svm model before and I'd love to give it a shot. If you have any questions I'll be able to help in a few days

Assigning it to you now

ruhi47 commented 1 month ago

Thank you!

ruhi47 commented 4 weeks ago

Hey @ryansurf , sorry for no PRs but have been sick for couple of weeks, will start this from today !