Transaction history CSV file generator 2.0 (for your yearly tax reports)

View this thread on: d.buzz | hive.blog | peakd.com | ecency.com
·@pharesim·
0.000 HBD
Transaction history CSV file generator 2.0 (for your yearly tax reports)
@louis88 had been playing around with GitHub's Copilot and @mahdiyari's [public HafSQL database](https://peakd.com/hive-139531/@mahdiyari/public-hafsql-database-on-haf) to figure out [the retention rate and general efficiency of onboarding programs](https://peakd.com/hive-139531/@louis88/having-fun-with-data-13k-mau-i-dont-know), which I watched him stream on Discord. 

This made me want to create a hafsql version of the [hive_tx_to_csv](https://peakd.com/hive-139531/@pharesim/script-to-create-a-csv-file-with-all-financial-transactions-ie-for-tax-purposes) script using the same tools. After a lot of prompting the AI, waiting for results and test-runs, and fixing quite a lot of ridiculous mistakes, I ended up with a [working version](https://github.com/pharesim/hive_tx_to_csv/blob/main/hive_tx_to_csv_hafsql.py).

<center>![](https://images.hive.blog/p/NTy4GV6ooFRmaCXZ8UYgPhoud1kjiNX8QokLEZtbBKLuLWQ9yt7K3o4S6eC2WcnS9KkBw4dQazCQtHKyHFKQwm3iwphG9cqgQaUvZfpRjAw8rmJFsTd6cwr4NCkVq9W5LZSCT7BK5f4h4ubeXhn9jxxCEodmBNPJtsLjZdJ7?width=800&height=600&format=webp&mode=fit)</center>

The big benefit of using SQL is that it's a lot faster. Get a whole year's report in a matter of seconds or minutes.
The downside is that it relies on the availability of trustworthy public SQL nodes.
Both scripts are kept up-to-date (just added HBD interest payments for example), choose what suits your needs best.
👍 , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,