There's really only those two things to worry about inside SQLite: access starvation (two locks both waiting for each other) and the programmer coming up with a recursive WITH statement which doesn't terminate. Any good programmer will never encounter either of them. Most hangs I've dealt with which were reported as SQLite problems were actually hardware problems. SQLite does complicated things with storage very quickly SQLite so it's often the thing that was happening when your disk drive fails, or when a connection inside your computer comes loose.