4 ms·
A cursor is either valid in a transaction, or will cache its results - either way it will give a consistent view of data: https://www.postgresql.org/docs/13/sq
by e12e 6y ago
A cursor is either valid in a transaction, or will cache its results - either way it will give a consistent view of data:
https://www.postgresql.org/docs/13/sql-declare.html https://www.postgresql.org/docs/13/sql-declare.html
- lenkite 6y agoThese cursors are not database cursors. I too was confused by the bad terminology...
- e12e 6y agoAh, I assumed from the topic, term and discussion that this would be implemented via sql cursors. Apparently elastic search has a similar concept - but like sql cursors it cannot be stateless (because you cannot ask for Nth to Mth result of searching the collection as of state Z -if you don't want to capture/supply state Z). This means any stateless pagination api is fundamentally broken. Please don't make promises you cannot keep. For elastic: https://www.elastic.co/guide/en/elasticsearch/reference/current/paginate-search-results.html#search-after https://www.elastic.co/guide/en/elasticsearch/reference/curr...