Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@jackysp
Last active October 13, 2022 12:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jackysp/a33269f84902149c612a6d7a99683cd8 to your computer and use it in GitHub Desktop.
Save jackysp/a33269f84902149c612a6d7a99683cd8 to your computer and use it in GitHub Desktop.
TiDB Hackathon 2022 RFC

TiDB + Blockchain = ?

  • Team name: 早日暴富

  • Authors: Jack Ma, Chen Xi, Jack Yu

  • Project process: WIP

Project description

Using the TiDB Compute Engine to Read Blockchain Data.

Background & motivation

Blockchain is more like a decentralized distributed database, however, it lacks SQL support, and this project tries to combine the two by using TiDB compute layer to access Blockchain data directly.

Project design

Let's take ethereum as an example, ethereum officially uses geth as a client and the loaded data is stored in local goleveldb, TiDB can naturally use goleveldb as a storage engine. At the same time, there are different storage engines such as TiKV, TiFlash, etc. in a cluster, and after accessing to Ethernet, you can use TiDB as the entry point to read the transaction data of Ethernet directly, instead of downloading the Ethernet data and then importing it into a relational database for reading. In addition, it is also possible to perform ETL of Ethernet data directly inside TiDB, and a simple SQL can import Ethernet data into TiKV/TiFlash to facilitate HTAP type business access.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment