listinvoices command parameters for limit and offset

[lujakob]

Is it possible to pass limit and offset parameters for the listinvoices rpc command to be able to paginate the data? What is the default limit for the result set? I cannot find anything in the docs and neither in the code.

[vincenzopalazzo]

Ok! I had a proposal somewhere but I need to finish it! We had an idea to add the possibility to implement a generic paginator without introducing breaking changes with the actual API.

Speaking of stuff that you can do now, the only solution for you is to use the SQL plugin and write your query for the database that supports the limit and offset

Link: https://lightning.readthedocs.io/lightning-sql.7.html

[fusion44]

I'm working on the RaspiBlitz project, writing a backend project that abstracts away the differences between different implementations. I'm working on the implementation of the JSON RPC interface. I provide paging as a native feature of the API.

Problem A:
Currently I can only request all the data every time the user requests more data from the API. This is not very efficient as this can happen in rapid succession. I want to be able to request only the data I need.

Problem B:
Python Async streams (https://docs.python.org/3/library/asyncio-stream.html) have a buffer size limit, which is 64 KiB by default. Once it's reached, they throw an error. I'm raising this limit to 10MB for now, but heavily used nodes will probably hit this limit at some point.

Paging would solve both problems and make my life a lot easier.

[vincenzopalazzo]

Tracking issue #6348