Guide Step 1.

This will help you run your own online API requests to get Balances from Bitcoin Addresses.(More Cryptos can be added)

Users will have to know basic Ubuntu, Terminal, Google:)

This Is a Virtual Box Image of Linux Ubuntu with PostgreSQL, PGAdmin4

Requires https://www.virtualbox.org/wiki/Downloads
VirtualBox 6.1.32 ( https://download.virtualbox.org/virtualbox/6.1.32/VirtualBox-6.1.32-149290-Win.exe )
VirtualBox 6.1.32 Oracle VM VirtualBox Extension Pack ( https://download.virtualbox.org/virtualbox/6.1.32/Oracle_VM_VirtualBox_Extension_Pack-6.1.32.vbox-extpack )

Edit Ubuntu.vbox file with note pad remove lines 15 and 16 and Save file.

<Image uuid=”{f7f63395-225b-4ada-abf6-79f68a1c9629}” location=”C:/Users/Mizogg/Downloads/ubuntu-20.04.4-desktop-amd64.iso”/>
<Image uuid=”{bf6747fc-c258-47d3-adf4-a619a3a2f6ac}” location=”C:/Program Files/Oracle/VirtualBox/VBoxGuestAdditions.iso”/>

Install and Import into VirtualBox.

username = Ubuntu

password = ???????????????

Setup File on Desktop include username and passwords for programs and database installed.

Open folder on desktop called flask_app

Right click and open terminal in that location

RUN:
ubuntu@ubuntu-VirtualBox:~/Desktop/flask_app$source bitcoin/bin/activate

(bitcoin) ubuntu@ubuntu-VirtualBox:~/Desktop/flask_app$ export FLASK_APP=app.py

(bitcoin) ubuntu@ubuntu-VirtualBox:~/Desktop/flask_app$ export FLASK_ENV=development

(bitcoin) ubuntu@ubuntu-VirtualBox:~/Desktop/flask_app$ flask run —host=0.0.0.0

YOU will find that this is already saved in the terminal commands use the up key to scroll.

open Firefox
http://127.0.0.1:5000/balance?active=

Now the next bit is up to you. Where you copy or upload to? Open firewall or VPS for external access from other devices

This has already been install within the Ubuntu Virtual Box. To use create databases or new tables open terminal.

psql -U bithunt -h localhost or psql -U postgres -h localhost

enter password for bithunt.**

The user bithunt has been given permission to access the postgress database bithunt and and create/drop tables and edit all within this database.  I would use this account when importing editing  information into the database. The main administration account postgres ** can make gobal changes add user accounts, permissions and much more.

**(password saved in text file)

display User account

\du

List Database

\l

Already done but if you want to create a Database or a  New Table.

CREATE DATABASE bithunt;

postgres=# CREATE TABLE bitcoin(
address VARCHAR(80) not null,
balance VARCHAR(20) not null
);