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 queries.
Simply put, a query is a question. You ask the server for something and it sends back an answer (called the query result set). For example, when dealing with large amounts of data such as the Hive blockchain data, you might want quick answers to questions (queries) such as:
What was the Hive power-down volume during the past six weeks?
Which are the top 10 most rewarded post ever?
Did I get, me or my posts, mentioned in any post or comment?
How many posts are talking about ants?