Perdedune | Database

Postgres SQL database creation.

Schema and tables

• Schema: erc20
• Table: erc20.ERC20_evt_Transfer

Build and deploy

• scripts/build.sh builds the docker image;
• scripts/deploy.sh deploy the database creation. In order to use this script is mandatory to properly set the local absolute path to mount the data.

Test deployment

In order to test the deployment of the table and the data loaded you could query directly from the inside of the container.

psql -h localhost -p 5432 -U perdune -d perdune

Query comparison

• scripts/query_comparison_1.sh and scripts/query_comparison_2.sh execute sql scripts in order to make a comparison between the original query and the generated by the compiler.

Demo