plugins icon indicating copy to clipboard operation
plugins copied to clipboard

probe: use postgres instead of sqlite when enabled

Open 3nprob opened this issue 4 years ago • 1 comments
trafficstars

If clightning is already configured to use a postgres database, it would be great to create a table there, that rather than creating a new sqlite3 database on disk

Especially for setups where the datadir for clightning is on a network-attached volume/disributed filesystem, as sqlite is known to be prone to corruption in those scenarios

3nprob avatar Feb 06 '21 03:02 3nprob

Adding postgresql support, or really any db supported by sqlalchemy should be very easy. I'd add a --probe-db option to allow operators to specify where to store the results, rather than hijacking the existing --wallet option, since that might be unexpected.

Very good suggestion 👍

cdecker avatar Feb 12 '21 14:02 cdecker