I would like to learn to build my own database to store my stock, economy, non price data and etc. May I know what is the most relevance database method to use? There few SQL like MySQL, PostgreSQL and etc, and also few NoSQL like mongoDB, Cassandra, HBase and etc.
I hope if anyone has rich experience, please give me advise about which database method I should learn. Thank you so much
Hi Chin Hong Wong
There are several database methods that you can use to store your stock, economy, and other non-price data. Some databases may be better suited for certain types of data or workloads, while others focus on scalability or ease of use.
Relational Databases - Structured databases that use tables to store data, and relationships between tables to represent the data's connections. Examples include MySQL and PostgreSQL.
NoSQL Databases - Unstructured databases that do not use tables to store data. Instead, they use a variety of data models, such as key-value pairs, documents, and graphs. Examples include MongoDB and Cassandra.
Time-series Databases: These are databases specifically designed for storing and querying time-series data. Examples include InfluxDB and Prometheus.
Ideally, if you are working with the historical price and volume data of stocks then you can use CSVs or Spreadsheets. As long as the dataset isn't very large, these would be sufficient.
However, if the data itself is large or unstructured, you can opt for using any of the databases mentioned above.
Some factors that you can look into are:
- Scalability
- Performance (how quickly you can retrieve and manipulate data)
- Learning Curve
- Cost. It's also important to consider your budget and choose a database that fits your financial resources.
I hope this was helpful to you.