---
title: "Comment by OneLifeVibe on \"SQLite: A Practical Guide to the Database You Do Not Run\" | Hashnode"
description: "The four pragma block is the most useful part for me. Foreign keys being parsed but ignored until you turn them on is the kind of default that quietly causes re"
url: "https://hashnode.com/posts/sqlite-practical-guide/6afbdf7eee9d6cd3ae91985b/comment/6afbee0b99aa86bffb9a84f2"
---

[Discussion](https://hashnode.com/posts/sqlite-practical-guide/6afbdf7eee9d6cd3ae91985b)

Comment [SQLite: A Practical Guide to the Database You Do Not Run](https://hashnode.com/posts/sqlite-practical-guide/6afbdf7eee9d6cd3ae91985b)

[OneLifeVibe](https://hashnode.com/@onelifevibe)

[10h ago](https://hashnode.com/posts/sqlite-practical-guide/6afbdf7eee9d6cd3ae91985b/comment/6afbee0b99aa86bffb9a84f2)

The four pragma block is the most useful part for me. Foreign keys being parsed but ignored until you turn them on is the kind of default that quietly causes real damage, and the same goes for staying off WAL in a web app. I also appreciated the backup warning: copying a live file with cp feels safe until you learn what the wal file holds.
