Cyberhub Home

Once you have LNDg installed and running, this guide will help you ingest your node data into a local Windows MySQL database to query using MySQL Workbench. With these extra steps, above and beyond the steps taken in How to Get Monthly Node Summary Stats via SQLite, you can eliminate the trouble of manually copying your db.sqlite3 file every time you want to work with current LNDg data.

For Windows:

1. Install MySQL Workbench

2. Create a new LNDg database

3. Install Python and packages

4. Create a Python script to ingest your LNDg data into a local database

5. Query your LNDg local database using MySQL Workbench

6. Automate the ingestion script

To chart historical stats like APY, you will need additional data not available in the LNDg database. See How to Record Daily LND Data to Compliment Your LNDg Data for more information.

This guide is just the documented steps of my own learning journey. It worked for me, so maybe it will be useful for others. If you have a suggestion for what I might do to improve this guide, or to do next in my learning journey to improve, please tweet or telegram me and guide my path. šŸ™

<aside> šŸ¤ Value for Value

</aside>

If you feel enriched by something I have shared, Iā€™m delighted by any form of support you feel inspired to offer. Even the smallest gesture delights me more than words can say because it brings with it a much larger feeling. Your support fills me with hope. It encourages me to fight the good fight because others are by my side.

<aside> šŸ¤ Support cyberhub

</aside>