I’ve been working a lot with queries and scripts for DB Sync and Smash recently, and decided to build them into a dedicated application called Cardano StakeSync.
For those not aware of DB Sync, it’s a tool following the Cardano Blockchain to write its data directly into a PostgreSQL database. Pool metadata (pool name, ticker, description and website) can be collected and stored using a Smash server. StakeSync now adds another database, maintaining various additional live data such as address / stake balances and extended delegation and pool information.
Check out a live view of all databases here: https://stakesync.io/db
For step-by-step instructions on how to install the latest releases of Cardano Node, DB Sync and Smash, here’s a simple installation guide: https://github.com/StakeSync/Guides/blob/master/install_node-dbsync-smash.md
StakeSync is written in PHP and can easily be customized. The initial sync process takes about 12-24 hours, but once up to date it is very resource-friendly. No installation or required dependencies and no interference with your current server setup, data retrieval is standalone and read-only from the DB Sync and (optionally) Smash database. StakeSync works with the latest DB Sync 7.1 and Smash 1.3 releases, although the current feature set is also compatible with older versions.
More data and features are planned in future updates, for example retrieval of extended pool metadata and a REST Api.
To fund ongoing updates and support, the price for a StakeSync licence is currently 400 ADA. Would be great to be able to fund development via Catalyst or Stakepool operation at some point, in which case it could be turned into freeware.
Download StakeSync at https://stakesync.io