Database: Difference between revisions

From mojo_puzzler
Jump to navigation Jump to search
(Created page with "==Useful Command:== <pre>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;"'</pre>")
 
(No difference)

Latest revision as of 18:17, 16 November 2023

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;"'