search

rustyqt / zilgraph

Zilgraph - A Zilswap Dashboard
GNU General Public License v3.0
3 stars 2 forks source link

DB Scheme #2

Closed diegofcoelho closed 3 years ago

diegofcoelho commented 4 years ago

Can you release the structure for the database?

rustyqt commented 3 years ago

Recently, there has been a major shift in the Zilgraph back-end towards elasticsearch. Currently I have two indexes, zilcrawl and zilswap.

zilcrawl: Here you have all transactions executed at the Zilliqa blockchain. Some fields, e.g. events, are saved as serialized strings so that it was possible to store all transactions in a simple and common manner without pre-filtering.

zilswap: The zilswap.py contiounsly searches for new transaction in the zilcrawl index. If any zilswap related transactions appear, the data gets analyzed and the aggregated data gets stored in the zilswap index.

For the database structure you can have a look directly in kibana. At port 5602 you get logged in automatically as a read-only user and you can explore the data on your own. See: https://zilgraph.io:5602

rustyqt commented 3 years ago

Database publicly available.