https://mojopuzzler.org/mediawiki/index.php?title=Database&feed=atom&action=historyDatabase - Revision history2024-03-28T16:56:19ZRevision history for this page on the wikiMediaWiki 1.40.1https://mojopuzzler.org/mediawiki/index.php?title=Database&diff=1114&oldid=prevGneale: 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>"2023-11-16T18:17:01Z<p>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>"</p>
<p><b>New page</b></p><div>==Useful Command:==<br />
<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></div>Gneale