Post
Topic
Board Development & Technical Discussion
Merits 1 from 1 user
Re: Quick balance check
by
NotATether
on 13/10/2022, 07:32:05 UTC
⭐ Merited by NeuroticFish (1)
The fastest solution would be to download daily dump of founded addresses (from blockchair or http://addresses.loyce.club/ ), load into local database (for example postgresql) and then have have a program which launches queries to your database. That way you are independent of network connection, API limitations etc. In long term perspective, this is the best solution (of course you need to update your database from time to time).

Another solution would be to host everything locally - full node, spv server like electrs and then rpc explorer.

This is what I'd suggest: a local block explorer that provides the API OP needs.
The dumps from loyce.club are big (over 1GB zipped) and I find downloading them on a daily basis counterproductive.

Why not just a database, if you're going to be dumping data and blocks onto the hard disk?

At least you will be able to make comprehensive SQL queries, make graphs (using something like PowerBI) and scale to many computers if you run out of disk space.