correction,
i kind of recollected this as my own problem of a client wanting 100k rows
worth data downloadable.
we finally decided with csv dump and upload to object store, from where the
client would download the file.
all other options like web ui with pagination etc were resulting in memory
issues in the api.
so if it is how to render 1gb db worth data on a web browser, then ignore
my answer.