
Why a single file is often all the database you need, and the four settings to switch on before you trust it
Every database. One cone.
CreamDB is a web-based database explorer with an AI assistant. Connect your databases, ask questions in plain English and get answers, tables and charts from any browser. Product news and tips here.
Markdown supported · ⌘↵ to post
OneLifeVibe
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.