✨ PostgreSQL ✨

Speed Fast API request for Bitcoin and Other Crypto Balance Checker with 🐍 Python 🐍 PostgreSQL and Flask.

bandicam.2022-08-21.17-24-05-793.mp4

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.

License: PostgreSQL License (free and open-source, permissive)

Developer(s): PostgreSQL Global Development Group

Repository: git.postgresql.org/gitweb/?p=postgresql.git

Initial release: 8 July 1996; 26 years ago

Operating system: macOS, Windows, Linux, FreeBSD, OpenBSD

Stable release: 14.5 / 11 August 2022; 1 day ago

ℹ️ Install PostgreSQL ℹ️

1_Install.Postgress.mp4

ℹ️ Create Table ℹ️

CREATE TABLE hunter(
address VARCHAR(80) not null,
balance VARCHAR(30) not null
);

2_Table.mp4

ℹ️ Install Flask psycopg2 waitress ℹ️

pip install flask
pip install psycopg2
pip install waitress

3_Install.Flask.mp4

ℹ️ Import and Use ℹ️

Import your list off addresses with Balance.The first time that you try to import PostgreSQL will give you error reguarding Binary Path in the Preferences dialog. To Resolve Correct The Binary Path pgAdmin 4 PostgreSQL 14. We need to set the bin path of the PostgreSQL installation which is not done at the time of installation. You will need to update the PATH on your PostgreSQL.

C:\Program Files\PostgreSQL\14\bin

set FLASK_APP=app.py
set FLASK_ENV=development
flask run --host=0.0.0.0

4_import.mp4

http://127.0.0.1:5000/balance?active=1FeexV6bAHb8ybZjqQMjJrcCrHGW9sb6uF

💡 Index Database 💡

You will Find Without indexing the Databse the Request will be slow. More Information ( https://www.tutorialspoint.com/postgresql/postgresql_indexes.htm )

Unique Indexes

Unique indexes are used not only for performance, but also for data integrity. A unique index does not allow any duplicate values to be inserted into the table. The basic syntax is as follows −

CREATE UNIQUE INDEX index_name on table_name (column_name);

Partial Indexes

A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate of the partial index). The index contains entries only for those table rows that satisfy the predicate. The basic syntax is as follows −

CREATE INDEX index_name on table_name (conditional_expression);

bandicam.2022-08-21.16-46-53-568.mp4

CREATE INDEX index_hunter
ON hunter (address, balance);

Much more to Add. Information and Programs coming Here soon... Happy Hunting