HiveSQL is a publicly available Microsoft SQL database containing all the Hive blockchain data.
Data are structured and easily accessible from any application able to connect to an MS-SQL Server database. It allows you to easily access data contained in the Hive blockchain and perform analysis or find valuable information.
Browsing the blockchain over and over to retrieve and compute values is time and resource consuming. Instead of having a local copy of the blockchain or downloading the whole data from some external public node to process it, you will send your query to HiveSQL server and get the requested information.
HiveSQL makes it possible to produce quick answers to complex questions.
The main advantage of having such a database is the fact data are structured and easily accessible from any application able to connect to a SQL Server database. Having a SQL Server database makes it possible to produce quick answers to complex queries.
Simply put, a query is a question. You ask the server for something and it sends back an answer (the query result set). For example, when dealing with large amounts of data such as the Hive blockchain data, you might want to search for the following information:
- What was the Hive power-down volume during the past six weeks?
- Which are the top 10 most rewarded post ever?
- How many times have I been mentioned in a post or comment last 7 days?
- How many posts are talking about ants?