chantools icon indicating copy to clipboard operation
chantools copied to clipboard

multi: add sql backend support

Open ziggie1984 opened this issue 1 year ago • 1 comments
trafficstars

Still draft needs a bit more cleanup, so work in progress.

Fixes: https://github.com/lightninglabs/chantools/issues/53

ziggie1984 avatar Nov 22 '24 12:11 ziggie1984

example commands:

chantools walletinfo -r --db.backend sqlite --withrootkey --walletdb ./chain.sqlite

chantools walletinfo -r --db.backend postgres --db.postgres.dsn "postgres://lnd_migration:lnd_migration@localhost:5432/lnd_migration_db?sslmode=disable" --withrootkey

chantools -r --db.backend sqlite --db.sqlite.data-dir /regtest/data dropchannelgraph --single_channel 930186837164032 --node_identity_key 0356b85c9fd3d8da2e74e646e9f5b327d9b9c8538f0a817dcf72662fcad0cae49d

ziggie1984 avatar Nov 22 '24 20:11 ziggie1984

@guggero Any plans on adding support to sql backends?

d4r1as avatar Jul 08 '25 11:07 d4r1as

@d4r1as what command specifically do you need? Most commands work without any interaction with the database.

guggero avatar Jul 08 '25 11:07 guggero