NEAR Protocol is an intuitive, eco-friendly blockchain, constructed from the ground up to be high-performing, secure, and unmatched in scalability. In technical terms, NEAR is a layer one, sharded, proof-of-stake blockchain designed with usability in focus. In straightforward terms, NEAR is a blockchain for everyone. The NEAR BigQuery Open Database is meant for those who wish to query blockchain data conveniently and cost-effectively.
Why BigQuery Open Database?
Until now, a user’s data inquiry requirements were met by indexers. Those indexers were either provided by NEAR Protocol or tailor-made. Developing custom indexers necessitated transforming JSON files from the NEAR Lake storage layer and loading them into a target database engine like PostgreSQL, and only then could a user execute queries against it.
This process is intricate, time-consuming, and resource-draining. It necessitates constant monitoring to ensure databases have the most recent information.
NEAR BigQuery Open Database transforms this. It furnishes nearly real-time blockchain data that can be effortlessly queried with SQL.
Advantages of BigQuery by NEAR Protocol:
-NEAR immediate insights
-Historical on-chain data queried at scale.
-Cost-efficient.
-Eradicate the need to store and process bulk NEAR Protocol data; query as little or as much data as preferred.
-Simple to use.
-No prior experience with blockchain technology is necessary; bring a general understanding of SQL to unlock insights.
The tables accessible in the NEAR Protocol Open Database on Google Cloud are:
Account changes: Each account has an associated state where it stores its metadata and all the contract-related data (contract’s code + storage).
Blocks: A structure that illustrates an entire block in the NEAR blockchain.
Chunks: A portion of each block produced as a result of sharding in the NEAR protocol.
Receipts: All cross-contract (assuming that each account lives in its own shard) communication in NEAR occurs through Receipts. Receipts are stateful, serving not only as messages between accounts but also can be stored in the account storage to await DataReceipts.
Transactions: A transaction in NEAR is a list of actions and additional information.
At The End
NEAR BigQuery Open Database is now accessible for anyone wishing to leverage blockchain data for their unique needs. BigQuery can assist not only developers but also wider audiences, including:
Users: Form queries to trace NEAR Protocol assets, oversee transactions, or scrutinize on-chain events on a massive scale.
Researchers: Utilize indexed data for data science tasks, encompassing on-chain activities, recognizing trends, or feeding AI/ML pipelines for predictive analysis.
Startups: Leverage NEAR Protocol’s indexed data for profound insights on user engagement, smart contract utilization, or insights across tokens and NFT adoption.
