7

There are growing number of crypto currencies currently translated into public access via BigQuery by means of Google Cloud. For example, see here, here, or here. Also this article in Forbes about this trend.

In the articles above, we can clearly see the motivation that was behind that decision.

Can we, as a Tezos community, make the similar effort and translate the entire blockchain into open DB format? It may be GCP+BigQuery or AWS+Redshift, etc.

That effort may require a constant synchronization, but example in this direction is already exists. For instance, this baker is delivering the current DB state on regular basis. This service allow anybody to grab the recent DB snapshot and use it.

Now, we may need to consider making entire DB available for SQL queries and searchable publicly. Projects involved in block exploration may be better positioned here.

Just want to ask what is needed for it? Is it something that requires deep knowledge of Tezos proprietary DB?

My guess that sooner or later every meaningful blockchain will be explored through Google. Everybody may have a chance to say "Hey Google, show me the block 327239 in Tezos" or simply type SQL in BigQuery and Google will present something similar to https://tzscan.io/327239 but using BigQuery with applied visual analytics. Just dreaming. But who knows, maybe there are people who have been thinking about it as well.

5

In addition to what Ezy said here, Cryptonomic actually does have plan to export data to Big Query. We have in the past reached out to the developer outreach person at Google who started this project and will get to the task once we catch up to the quickly-evolving features of the Tezos platform.

| improve this answer | |
  • 1
    Awesome, we all we be waiting for this moment then – indigo Feb 25 '19 at 15:51
  • 1
    Thanks Vishakh for the update sounds exciting! – Ezy Feb 25 '19 at 17:19
2

It seems to me this is a very good question and afaik such an effort is actively taken by Cryptonomic in that direction. They are in the process of releasing a quite flexible query system called Arronax that is powered by Conseil/ConseilJS .

| improve this answer | |
0

Tezos BigQuery dataset is available now :)

https://medium.com/tezoscommons/tezos-public-finance-dataset-integrated-into-google-bigquery-6050726d2b96

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.