mcldsp
mcldsp
A tool that migrates data from a c-lightning SQLite3 database into PostgreSQL so one can keep Lightning channels and everything but change the underlying database.
It’s a mostly manual thing, and I keep following changes in the database schema on c-lightning’s GitHub repo so I can update the migration specs whenever needed.
See also
Published at
2024-01-14 14:55:28Event JSON
{
"id": "89996dd010e3c4e3e80a2cf372a8e1da7c274be73b1d1988827b287b162f7251",
"pubkey": "3bf0c63fcb93463407af97a5e5ee64fa883d107ef9e558472c4eb9aaaefa459d",
"created_at": 1705240528,
"kind": 30023,
"tags": [
[
"d",
"6cd4aa42"
],
[
"title",
"mcldsp"
],
[
"published_at",
"1570060800"
],
[
"a",
"30023:3bf0c63fcb93463407af97a5e5ee64fa883d107ef9e558472c4eb9aaaefa459d:e03d51f2",
"wss://fiatjaf.com"
],
[
"a",
"30023:3bf0c63fcb93463407af97a5e5ee64fa883d107ef9e558472c4eb9aaaefa459d:e85b3d90",
"wss://fiatjaf.com"
]
],
"content": "\n# mcldsp\n\nA tool that migrates data from a [c-lightning](https://github.com/ElementsProject/lightning/) SQLite3 database into PostgreSQL so one can keep Lightning channels and everything but change the underlying database.\n\nIt's a mostly manual thing, and I keep following changes in the database schema on c-lightning's GitHub repo so I can update the migration specs whenever needed.\n\n- \u003chttps://github.com/fiatjaf/mcldsp\u003e\n\n## See also\n\n- [Sparko](nostr:naddr1qqyx2vpnvs6nze3jqyghwumn8ghj7enfv96x5ctx9e3k7mgzyqalp33lewf5vdq847t6te0wvnags0gs0mu72kz8938tn24wlfze6qcyqqq823c362tx2)\n- [trustedcoin](nostr:naddr1qqyx2wp4vgekgwfsqyghwumn8ghj7enfv96x5ctx9e3k7mgzyqalp33lewf5vdq847t6te0wvnags0gs0mu72kz8938tn24wlfze6qcyqqq823c04z53s)\n",
"sig": "a1359dd44f88d48596a037cf2414bb84509aa276fabb80d3d77f257ed68036ab9911017803b7af773019927efc1b0503b835621cab6430135814998ab0325e22"
}