In SQLite, a primary key uniquely identifies each row in a table and cannot have null values, while a unique key also ensures uniqueness but can contain null values. You would use a primary key when you want to enforce a strict unique constraint on a row, and a unique key when you need unique values but allow for nulls.