Publicly Shared Version – October 28, 2025
Fully Verified | Source-Backed | Community-Editable
"The future of money is programmable, compliant, and green." – Gene Hoffman
Gene Hoffman hoffmang9
hoffmang9
/ gist:92e7397df08fa78ddd3aa369631a3ee3
Last active
October 30, 2025 02:54
Grokopedia Entry: Gene Hoffman Jr. (Technology Executive)
hoffmang9
/ gist:ab52e699b2a261f0046a475993451e34
Created
December 20, 2023 00:17
sqlite3 compile time options Ubuntu 22.04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| python -c ' | |
| import sqlite3 | |
| import sys | |
| conn = sqlite3.connect(":memory:") | |
| print("Python version:", sys.version) | |
| print("SQLite version:", conn.execute("select sqlite_version()").fetchone()[0]) | |
| print("SQLite compile options\n " + "\n ".join(r[0] for r in conn.execute("pragma compile_options").fetchall())) | |
| for pragma in ( | |
| "foreign_keys", "defer_foreign_keys", "ignore_check_constraints", "legacy_alter_table", | |
| "recursive_triggers", "writable_schema", |
hoffmang9
/ og-farmer-winners.md
Last active
October 21, 2020 21:09
How to verify and claim your OG Farmer Prize
You will need to send a signed message to @hoffmang or @lbisio (both are preferred) on Keybase or email to hello@chia.net.
To sign the proper message you will need some data about your HD key. Don't share the full results, but reference this command for the following steps.
chia keys show
From that you will first need the Fingerprint: and the Pool public key and it's derivation path which is in the parentheses right before the Pool public key.
hoffmang9
/ Signing-Verifying-Chia-Keys.md
Last active
February 4, 2023 19:29
How to sign and verify arbitrary data with Chia keys
You will need some data about your HD key. Don't share the results, but reference this command for the following steps.
chia keys show
Grab the Fingerprint value for your key set. You will also need the keypath to your Pool Public key, e.g. (m/12381/8444/1/0). You will drop the parentheses and the leading m/ as shown below.
chia keys sign -f [fingerprint] -t [hd_path] -d [message] (sign a message with a private key)
# Working Example
Here are the new Windows install instructions as of 2020-04-21 00:30 PDT:
For beta3 chain compatibility: Download and Run https://download.chia.net/beta-1.4-win64/chia-0.1.8.exe (current at 2020-04-20-0930 PDT)
For pre-beta4 chain compatibility: Download and Run https://download.chia.net/beta-1.4-win64/chia-0.1.9.exe (current at 2020-04-21-0030 PDT)
Right click on the PowerShell application and select Run as Administrator or search for PowerShell and choose the Administrator option.
I hereby claim:
- I am hoffmang9 on github.
- I am hoffmang (https://keybase.io/hoffmang) on keybase.
- I have a public key ASDfAMG266H11MMnk3xGygEO6hJ0OYUNQ1VztJxjtVQP5Qo
To claim this, I am signing this object: