Database

From mojo_puzzler
Jump to navigation Jump to search

Useful Command:

watch -n10 'sqlite3 ~/.chia/mainnet/db/blockchain_v2_mainnet.sqlite "SELECT timestamp, hex(puzzle_hash), hex(amount) FROM coin_record ORDER BY confirmed_index DESC LIMIT 40;"'