Paycoin Blockchain Storage

Paycoin Blockchain Storage uses RPC commands to get data from a local wallet and then parse that data into an SQLite database.

Works with wallets in both mainnet and testnet modes, checking which mode the wallet is running before putting the correct genesis block into the database. On Linux and Mac, this will complete at a decent speed. However, due to RPC issues, on Windows this will run incredibly slowly.

####Running PBS:

---

Ensure you have at least Ruby 2.2.1 installed. Instructions to install Ruby correctly can be found on the RVM site. Once installed, you will also need Bundler, which can be installed through RubyGems.

gem install bundler

Clone the repo, navigate to the src directory and run

bundle install

After all required gems are installed, make sure that your wallet is running with rpcuser=paycoinrpc, rpcpassword=password, rpcport=9001 in your paycoin.conf. To run the parser, type

ruby src/main.rb -c

Creating/Upgrading database

After pulling a new version, run ensure you run Sequel migrations to get your database up to date. For SQLite, run

sequel -m src/migrations sqlite://path_to_database

SQLite will automatically create a new file if one doesn't exist yet. For PostgreSQL, run

sequel -m src/migrations postgres://user:password@host/database_name

and for MySQL, run

sequel -m src/migrations mysql2://user:password@host/database_name

You will need to install PostgreSQL/MySQL, create the user, database and assign the correct privileges before running the migration.

During the first run of the application, the current database version will be set in schema_info. If the version in the db does not match the version in the application after an update, the application will not start and it will inform you to run the migration before trying again to ensure that you do not corrupt your database or cause crashes looking for columns that don't exist.

Usage

To run PBS after installation

ruby src/main.rb

Available options:

--config,       -c  :  Use default OS Paycoin configuration file
--loadconfig,   -l  :  Load separate configuration file (Can contain database config info)
--user,         -u  :  RPC Username
--pass,         -ps :  RPC Username (default => "rpcpass")
--port,         -p  :  <numeric> RPC Username (default => 9001)
--host,         -ho :  RPC Hostname (default => "127.0.0.1")
--help,         -h  :  Get helpful information for action "pbs parse" along with its usage information.

####TODO:

---

Speed it up