C.W.K.
Stream
Quiz · 3 questions

✏️ Writes, Transactions, and WAL

Joins, foreign keys, transactions, WAL mode, and UPSERT — the writing half of SQL

Level 0Scout
0 XP0/80 lessons0/10 achievements
0/120 XP to next level120 XP to go0% complete

Quiz

01Why is PRAGMA foreign_keys = ON often called the most common SQLite footgun?
02What does WAL mode primarily change about SQLite's concurrency story?
03What does ON CONFLICT(...) DO UPDATE SET col = excluded.col mean?
Spotted a bug or have feedback on this page?Report an Issue

Comments 0

🔔 Reply notifications (sign in)
Sign inPlease sign in to comment.

No comments yet — be the first.