Database

From mojo_puzzler
Revision as of 18:17, 16 November 2023 by Gneale (talk | contribs) (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>")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;"'
Retrieved from "https://mojopuzzler.org/mediawiki/index.php?title=Database&oldid=1114"