4 votes
Accepted

explore sqlite wallet

The data stored is binary data, which is why it comes out garbled. It is not text. So you will have to convert the data to something human readable. One such method is to convert it to hex. One such ...
user avatar
  • 62.4k
4 votes

Getting "Unable to find DB driver for sqlite3" when trying to start c-lightning node

Most likely this is due to a mismatch between the sqlite3 version that c-lightining was compiled with and the version your OS currently has installed. With the recently release v0.10 2, c-lightining ...
user avatar
  • 8,814
3 votes

Are the block headers kept in memory?

I think you are confusing what it means to store things "in memory". As you say, indeed, the block index DB and the chainstate DB are both levelDB databases stored on disk. However, while ...
user avatar
  • 11.4k
2 votes
Accepted

Layout of new SQLite descriptor wallets in v0.21 and v22.0?

An extended public key contains the chaincode, so it is not stored separately. So the tpubs that you have found will contain the chaincode. The private keys are not encrypted, and unencrypted private ...
user avatar
  • 62.4k
1 vote
Accepted

Database of altcoins?

https://github.com/satoshilabs/slips/blob/master/slip-0044.md For those using the BIP44 "purpose" field anyway. That "major" qualifier will be slippery From my notes so far ... ...
user avatar
  • 405
1 vote
Accepted

How to identify Taproot transaction using big query?

You clarified in the comments that you are using BigQuery datasets and so you are right Taproot transactions should eventually be labelled as witness_v1_.... Taproot only activated a couple of days ...
user avatar
1 vote

Bitcoin data by country?

I've written an open-access academic paper on Bitcoin full node data here, and the data is in the Electronic Supplements. I explain in the Appendix how I get and prepare the data if you need more fine-...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible