Backend - ThisIsntTheWay/ps_binance_interface GitHub Wiki

Overview

This page attempts to explain how this script stores data and operates.

Data storage

All data is stored in a SQLite Database.
As such, PowerShell needs access to the 3rd-party module "PSSQLITE".

Tables

The DB houses three tables:

  • binanceSettings
    • This table contains the API key and secret.It is stored as a SecureString value.
  • exchangeTrading
    • This table contains information about all trading pairs that exist on Binance.It is possible to filter this data using ./filter/quoteAssetFilter.txt.
  • userInfo
    • This table contains user wallet info.
  • orderInfo
    • This table contains info about all orders that have been executed with this script.

Each entry gets tagged with a date, located in the date column.
Currently, data under userInfo does not get refreshed automatically or periodically.
It must be manually updated using main.ps1.