Cursor Based

# Cursor-based pagination
@app.route('/messages')
def list_messages():
    cursor = request.args.get('cursor')
    limit = min(request.args.get('limit', 20, type=int), 100)

    if cursor:
        # Decode cursor (base64 encoded timestamp+id)
        cursor_data = json.loads(base64.b64decode(cursor))
        messages = db.execute("""
            SELECT * FROM messages
            WHERE (created_at, id) < (%s, %s)
            ORDER BY created_at DESC, id DESC
            LIMIT %s
        """, [cursor_data['created_at'], cursor_data['id'], limit + 1])
    else:
        messages = db.execute("""
            SELECT * FROM messages
            ORDER BY created_at DESC, id DESC
            LIMIT %s
        """, [limit + 1])

    has_more = len(messages) > limit
    if has_more:
        messages = messages[:limit]
        last = messages[-1]
        next_cursor = base64.b64encode(json.dumps({
            'created_at': last.created_at.isoformat(),
            'id': last.id
        }).encode()).decode()
    else:
        next_cursor = None

    return jsonify({
        "data": [m.to_dict() for m in messages],
        "pagination": {
            "next_cursor": next_cursor,
            "has_more": has_more
        }
    })

// Cursor pagination in Node.js
app.get('/events', async (req, res) => {
  const cursor = req.query.cursor;
  const limit = Math.min(req.query.limit || 20, 100);

  let query;
  let params;
  if (cursor) {
    const decoded = JSON.parse(Buffer.from(cursor, 'base64'));
    query = `SELECT * FROM events WHERE (id) < ($1) ORDER BY id DESC LIMIT $2`;
    params = [decoded.id, limit + 1];
  } else {
    query = `SELECT * FROM events ORDER BY id DESC LIMIT $1`;
    params = [limit + 1];
  }

  const results = await db.query(query, params);
  const hasMore = results.rows.length > limit;
  if (hasMore) results.rows.pop();

  res.json({
    data: results.rows,
    nextCursor: hasMore
      ? Buffer.from(JSON.stringify({ id: results.rows[results.rows.length - 1].id })).toString('base64')
      : null,
    hasMore
  });
});