Skip to content

Instantly share code, notes, and snippets.

View hoffmang9's full-sized avatar

Gene Hoffman hoffmang9

View GitHub Profile
@hoffmang9
hoffmang9 / gist:ab52e699b2a261f0046a475993451e34
Created December 20, 2023 00:17
sqlite3 compile time options Ubuntu 22.04
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
hoffmang9 / og-farmer-winners.md
Last active October 21, 2020 21:09
How to verify and claim your OG Farmer Prize

Claiming your OG Farmer Prizes

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
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
@hoffmang9
hoffmang9 / Windows-Install.md
Last active April 22, 2020 06:55
Installing Windows pre-beta-1.4
@hoffmang9
hoffmang9 / keybase.md
Created January 6, 2018 23:16
Keybase authentication of GitHub

Keybase proof

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: