Prep Room
Sign inCreate account
Code Room
Code reviewMediumcr-p083
Subject PerformanceLevel Mid–Senior~18 minCommon in Code quality & review interviewsIndustries Software development

Question

Review this database access code.

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 get_user(uid):    conn = psycopg2.connect(DATABASE_URL)    cur = conn.cursor()    cur.execute('SELECT * FROM users WHERE id = %s', (uid,))    return cur.fetchone()
Run or narrate your approach, then ask the coach.