nanodb VS nano-community

Also — sharing this too incase it's helpful: https://github.com/mistakia/nanodb

There is a project that lets you convert the nano ledger into sql : https://github.com/mistakia/nanodb (also into neo4j)

I'm working on this and creating tools and datasets to make it more accessible for others to do research on this (and ledger analysis in general). I'm setting up new dataset pipeline that should be ready in the next 10 days.

I will at some point provide an API as well. In the meantime, I have the ledger data loaded up in MySQL and would be happy to run some queries and export the results for you.

You can download the ledger and start digging.

I was thinking about using IPFS (via something like Nano IPFS-Log) to maintain and track these accounts. That way IPFS Pubsub can be used to easily propagate new frontiers to all peers.

Improving Nano ledger data accessibility — https://github.com/mistakia/nanodb

Nano foundation will be dismantled soon, they have very little funding left and it's a good thing, we don't need them. Colin is a coder just like the rest of us, he's very talented and at the right time at the right place with the right idea but we can't depend on him forever. The community will take over. https://nano.community

And https://nano.community are both pretty good resources in general

Sources and calculations: Energy per bitcoin transaction: 734 kWh (https://digiconomist.net/bitcoin-energy-consumption ) (4 day average, 08.02.2023) Energy consumption of the nano network based on TPD by principal representatives: 57 kWh/day (https://nano.community) (4 day average, 08.02.2023) Sustainable tps by the nano network: 20.5 tps (https://nanotps.com) (08.02.2023) 1,771,200 transactions per day (including 1 send and 1 receive block per transaction) results in 0.0322 Wh average energy consumption per transaction (network only) Energy for PoW generation of a send block: 0.0147 Wh Energy for PoW generation of a receive block (1/64th difficulty of send): 0.000230 Wh (tested by community member Ricki) Total energy for 1 nano transaction: 0.0322 Wh + 0.0147 Wh + 0.000230 Wh = 0.0471 Wh 734 kWh / 0.0471 Wh = 15,583,864 To make this more tangible with 0.0471 Wh (1 nano transaction) you can     *Use a waffle maker for 0.1 s *Power a 50 W LED lightbulb for 3 s *Drive a Tesla Model S for 22 cm Special thanks to Ricki (PoW data and idea for this scene), trashman (TPD calculations and data from nano.community) and Pilsner_Maxwell (original concept for the nano-energy-cubes from 2 years ago). Song: Kevin MacLeod - Black Vortex

https://nano.community/ states a 2.375 kWh/day thermal dissipation power (TDP) of all PRs based on their CPU model infos.

My articles (https://senatus.substack.com/) provide a fair bit of extra background as well, and the Nano blog (https://nano.org/en/blog) has a lot more articles. There's also the community-run Nano.community (https://nano.community/).

Here are the stats I'm planning to work on: https://github.com/mistakia/nano-community/discussions/32

With nano, we have a truly great community project called Nano.Community (https://nano.community/) which is entirely hosted on Github. Simply fork the project, make your changes according to the contribution guidlines and boom. You're helping in the best possible way you can. If you feel up to it, you can contribute directly to the nano foundation living whitepaper, too.