Last week a message from 
Well, I couldn't agree more so I got to work!!
Today, we have a sidechain on top of the main blockchain and data just pouring out everywhere. As I looked at this my consideration was both which data to get and where to get it from. As I was exploring the answer hit me square in the face.
You see, I am a Hive Engine Witness so I've got a server running, a server with literally all the data I need and an API hanging off the back that I can call!
I started playing around with that API and found the getBlockInfo method to be the best endpoint to hit and then parse through everything in there. Drilling down into the data, I see the contract and action sort of defining the underlying data so I started building out tables in MySQL to match these records.
All the tables I've deployed are in the schema below.
First and foremost, I am far more of a backend developer. I love data, I can pull in data, parse it, transform it, and do anything really. While I can do front end work, I suck, it's slow, and I always put it last. This is to say, I have no front end yet, lol.
I want to both validate my data and get your thoughts on what sort of a front end I should put together. What features you wanna see, and more specifically, what features do you want but can't find anywhere else?
So to start, just jump right in and look at all my data. Also, since this is all just a proof of concept MVP, I only have roughly the last week of data. Once we validate everything I'll pull in everything.
I threw up a basic GET API in front of my database so you can jump in and get at the data right now. Please note, this is on a basic server so you should expect to run into issues, this is far from production ready.
There's just a few pieces to this puzzle:
General URL: http://144.126.250.230:3000/api/{TableName}/{TOKEN}?page={page_number}
Key point: the URLs are case sensitive, follow the case from the table schema below. Also, tokens are ALLCAPS, again case sensitive.
Here's a complete URL: http://144.126.250.230:3000/api/MarketBuy/WORKERBEE?page=3.
You can walk through all the data in all these tables. At last count, I have 509,759 total records across all these tables, from just the last week. You probably want to install a JSON extension to format everything nicely in your browser.
My biggest concerns are missing data. Did I forget any tables? Are any fields missing from my tables? Can you find a transaction from the last week that's not in my database?
I'm really excited to fully launch this and find more projects that I can contribute. I'm even more excited to see that I have been able to climb up the ranks on the witness list!
Even so, I'd like to firm up my position and earn even more of your trust. If you think I am a good Hive Engine witness I would appreciate your vote.
As always, hit me up on Discord: blervin#9759
TABLE: MarketBuy
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| Id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| CreatedAt | timestamp | YES | | CURRENT_TIMESTAMP | |
| Price | double(18,8) | YES | | NULL | |
| Quantity | double(18,8) | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: MarketCancel
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| Id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| CancelId | varchar(255) | YES | UNI | NULL | |
| CreatedAt | timestamp | YES | | CURRENT_TIMESTAMP | |
| Sender | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: MarketSell
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| Id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| CreatedAt | timestamp | YES | | CURRENT_TIMESTAMP | |
| Price | double(18,8) | YES | | NULL | |
| Quantity | double(18,8) | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: NftBurn
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP | |
| Nfts | text | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: NftIssue
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP | |
| FeeSymbol | varchar(255) | YES | | NULL | |
| LockTokens | varchar(255) | YES | | NULL | |
| Properties | varchar(255) | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| To | varchar(255) | YES | | NULL | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: NftIssueMultiple
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP | |
| Instances | text | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: NftMarketBuy
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| CreatedAt | timestamp | YES | | CURRENT_TIMESTAMP | |
| MarketAccount | varchar(255) | YES | | NULL | |
| Nfts | text | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: NftMarketCancel
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| CreatedAt | timestamp | YES | | CURRENT_TIMESTAMP | |
| Nfts | text | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: NftMarketChangePrice
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| CreatedAt | timestamp | YES | | CURRENT_TIMESTAMP | |
| Nfts | text | YES | | NULL | |
| Price | double(18,8) | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: NftMarketSell
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| CreatedAt | timestamp | YES | | CURRENT_TIMESTAMP | |
| Fee | int(11) | YES | | NULL | |
| Nfts | text | YES | | NULL | |
| Price | double(18,8) | YES | | NULL | |
| PriceSymbol | varchar(255) | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: NftSetProperties
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP | |
| Nfts | text | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: NftTransfer
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP | |
| Nfts | text | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| To | varchar(255) | YES | | NULL | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: TokensIssue
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP | |
| Quantity | double(18,8) | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| To | varchar(255) | YES | | NULL | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: TokensStake
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP | |
| Quantity | double(18,8) | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| To | varchar(255) | YES | | NULL | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: TokensTransfer
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP | |
| Memo | text | YES | | NULL | |
| Quantity | double(18,8) | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| To | varchar(255) | YES | | NULL | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+
TABLE: TokensUnstake
+---------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ActiveKey | bit(1) | YES | | NULL | |
| AppId | int(11) | YES | MUL | NULL | |
| BlockNumber | int(11) | YES | | NULL | |
| created_at | timestamp | YES | | CURRENT_TIMESTAMP | |
| Quantity | double(18,8) | YES | | NULL | |
| Sender | varchar(255) | YES | | NULL | |
| Symbol | varchar(255) | YES | | NULL | |
| Timestamp | timestamp | YES | | CURRENT_TIMESTAMP | |
| TransactionId | varchar(255) | YES | UNI | NULL | |
+---------------+--------------+------+-----+-------------------+----------------+