Prep Room
Sign inCreate account
Code Room
Code reviewMediumcr-g124
Subject Data bugsLevel Mid–Senior~25 minCommon in Networking & APIs interviewsIndustries Software development

Question

Review this SQL-backed Python pagination.

What a strong answer looks like

Separate real bugs from style. Rank issues by severity, point at the root cause rather than the symptom, and suggest a concrete fix — specific and kind.

Learn the concepts
Talk through your review
Code to reviewpython
def page(conn, page_num, size=20):    offset = page_num * size    cur = conn.execute(        'SELECT id, name FROM items ORDER BY created_at LIMIT ? OFFSET ?',        (size, offset),    )    return cur.fetchall()
Run or narrate your approach, then ask the coach.