András Bánki-Horváth

channeldb: write through cache for the graph and channel state

20

This PR adds a generic cache to the `kvdb` layer as well as demonstrates its use caching the channel state and the graph (graph cache being reworked to be more...

channeldb: update payment status instead of full re-fetch to improve performance

3

This PR adds a small refactor to reduce the number of times we fetch payments where we have all information already in memory. Tested with Postgres since this change adds...

test: autoloop test flake

2

Found this flake using the CI build. ```=== RUN TestAutoLoopInEnabled autoloop_testcontext_test.go:271: Error Trace: autoloop_testcontext_test.go:271 autoloop_test.go:601 Error: Not equal: expected: 80000 actual : 160000 Test: TestAutoLoopInEnabled autoloop_testcontext_test.go:271: Error Trace: autoloop_testcontext_test.go:271 autoloop_test.go:601...

channeldb: refactor `UpdateInvoice` to make it simpler to create SQL specific implementation

8

This PR is a collection of small changes refactoring the `UpdateInvoice` call and also `InvoiceDB` and `InvoiceRegistry` tests to be able to make `InvoiceDB` fully implementable both in k/v and...

sqldb: `InvoiceDB` implementation

8

This PR is based on the work of @positiveblue in https://github.com/lightningnetwork/lnd/pull/7357. Also based on top of https://github.com/lightningnetwork/lnd/pull/8100 which is preliminary work refactoring the update invoice flow in order to be...

Fixes https://github.com/lightninglabs/loop/issues/746 #### Pull Request Checklist - [ ] Update `release_notes.md` if your PR contains major features, breaking changes or bugfixes

With this client side RPC option the client will be able to set a payment timeout for individual off-chain payments. This applies both to the prepayment and the swap payment....

sqldb+invoices: fix incorrectly stored invoice expiries when using native SQL

3

Previously, when using the native schema, invoice expiries were incorrectly stored as 64-bit values (expiry in nanoseconds instead of seconds), causing overflow issues. Since we cannot determine the original values,...

invoices: fix SQL invoice query pagination

1

Previously paginated queries offseted the add_index_get, add_index_let, settle_index_get and settle_index_let parameters with the paginators current page offset, however this was incorrect as we can just use SQL's LIMIT/OFFSET to paginate....

invoices: migrate KV invoices to native SQL for users of KV SQL backends

3

## Change Description This pull request adds the migration of old key-value (KV) invoices to the new native SQL schema when the --db.use-native-sql flag is set, unless the --db.skip-sql-invoice-migration flag...