go - 如何在Scylla和Go中查询带偏移量的限制

Question

使用gocql或gocqlx，没有获取第n页的示例:

CREATE TABLE IF NOT EXISTS users (
    id    BIGINT, -- unique using distributed synchronous counter (redis-like), since Scylla doesn't support RETURNING on counter
    email TEXT, -- to enforce uniqueness
    PRIMARY KEY(email)
);
CREATE INDEX IF NOT EXISTS ON users(id);

查询功能:

func QueryRows(cql string) (res []M.SX) { // M.SX is map[string]interface{}
    q := Database.Query(cql) // database is the connection to scylla
    defer q.Release()
    res = []M.SX{}
    iter := q.Iter()
    for {
        row := M.SX{}
        if !iter.MapScan(row) {
            break
        }
        res = append(res, row)
    }
    return
}

要获取第n页(按 ALLOW FILTERING或 email排序)，是否容易但性能良好(没有 id)？

SELECT * FROM users WHERE id > 44 LIMIT 10 ALLOW FILTERING; 
-- eg. 44 is last id of current page

Answer 1

嗨，您尝试过基于 token 的分页吗？

来自scylladb/gocqlx的示例

https://github.com/scylladb/gocqlx/blob/master/example_test.go#L168