# Acala EVM Analytics Dashboard
## Summary
Currently Footprint paid account seems to be the best solution for us, it has smooth dashboard creation process, and supports updating data by API (potentially can even connect db directly). As for Dune and Dapplooker, they both have bugs that prevented query creation.

Footprint's price is cheaper than dune, and ideally we should contact them for a discount plan, since our current usage is small.

### alternative solution 0
Use Footprint paid account temporarily, and wait for Dapplooker to fix their bugs. They said these are critical bugs and will prioritize fixing them. The SQL queries should be consistent in theory, so once Dapplooker fixed their issues, we should be able to create similar dashboards easily from foorprint queries.

### alternative solution 1
Use Footprint free account, and upload data manually once a while. Might need to switch account often since upload limitation is 5 times, and re-create queries and dashboards, this will be very time consuming

### alternative solution 2
I am still taking a look into Footprint's postgres integration, let's see if this can work with free account (which I doubt). But even this works with paid account, the data pipeline will be much simplified, since we don't need to do `pull data => upload data` with a script anymore

## Comparison among different solutions
### Dune
- data integration
- ✅ can manually upload
- ✅ can use api to upload
- 🟨 LIMIT: can only upload 1MB data, and paid account is expensive
- dashboard
- ❌ BUG: can't recognize timestamp type from uploaded dataset, so can't create query, haven't found a solution yet

### Dapplooker
- data integration
- ✅ can integrate with subquery directly
- ❌ BUG: omits many data from subql
- 🟨 LIMIT: doesn't support array data
- ❌ can't use api to upload
- ❌ can't manually to upload
- dashboard
- ❌ BUG: queries doesn't work with array data

### Footprint - mostly China based
PoC: https://www.footprint.network/@shunji/Euphrates
- data integratio
- ✅ can manually upload
- 🟨 LIMIT: only 5 times
- ✅ can use api to upload
- 🟨 LIMIT: only for paid account, so haven't test this yet
- ✅ can integrate with postgres directly
- 🟨 LIMIT: not tested yet
- dashboard
- ✅ works perfectly
- POC: https://www.footprint.network/@shunji/Euphrates

## Pricing

| Dune | Dapplooker | Footprint |
| -------- | -------- | -------- |
| [399/month or 349/month(pay yearly)](https://dune.com/pricing) to enable upload > 1M | [99/month](https://dapplooker.com/pricing) to enable > 50k record, otherwise free | [299/month or 239/month(pay yearly)](https://www.footprint.network/pricing?type=footprint) to enable upload API access. |