public HafSQL database to figure out the retention rate and general efficiency of onboarding programs, which I watched him stream on Discord.@louis88 had been playing around with GitHub's Copilot and @mahdiyari's
This made me want to create a hafsql version of the hive_tx_to_csv 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.
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.
Very timely! I haven't taken a deep look because my work is going crazy right now, but what's the difference between hive_tx_to_csv.py and hive_tx_to_csv_hafsql.py - is it just down to the public node that it's using?
See the last paragraph. hafsql uses a SQL database, the base version queries the blockchain directly.
Very cool, that makes sense. I was just reading through the actual files too as you were making this comment and had figured that out. I appreciate the reply!
Thanks for the link @steevc, had just started looking into hivesql link to excel
Nice work @pharesim
Interesting. Someone was asking on Brits Discord about how to generate details for the taxman. I was looking at the UK tax and crypto trading falls under capital gains. You can earn earn up to £3000 before you need to pay tax. I need to see what it includes. A lot of us 'earn' $HIVE, but does that count as mining? The tax man may only notice when you convert to fiat and I've not done that in a while.
Taxation is theft.
Doesn't matter what the armed robber wants from you, it's always better to give it up and continue living your life in peace.
!lolz
Yeah, if you don't mind being bled by vampires that might be a good strategy, otherwise, you might want to fight.
If you never say no to your gov't, you got to expect it to take all you allow.
Guns and ammo for everybody.™
https://archive.org/details/combatsurvivalweaponsimprovisedkurtsaxonhowtobuildthefourwindsshotgun
lolztoken.com
The outside.
Credit: reddit
$LOLZ on behalf of antisocialist
(1/8)
NEW: Join LOLZ's Daily Earn and Burn Contest and win $LOLZ@pharesim, I sent you an
It's sad many of us will likely need such tool :/
Servus @pharesim , auch @louis88 , Betreff: https://hiveinvite.com/
Leider funktioniert das onborden mit E-mail scheinbar nicht:
Die Einladung hat mein Sohn versendet: @sportsvote :
Bis heute keine Email beim betreffenden eingelangt....
und morgen endet die Einladung...
lg mit nem BEER chen 🤠
Emails waren kaputt da der hoster überraschend die ports geblockt hatte. Seit Montag sind die aber wieder offen, ich habe gerade eine Einladung erstellt und die Mail kam sofort. Am besten du löschst die Einladung und erstellst einfach eine neue.
Danke!
Machen wir...
Lg 🤠
Thank you for your witness vote!
Have a !BEER on me!
To Opt-Out of my witness beer program just comment STOP below