I love SQLite. It’s pluggable interfaces and concise C code make it enjoyable to use (and sometimes to debug - as long as you don’t have to go through the single file version!).

Unfortunately, I wish there were multiple implementations of it, and that the file format was documented and stable.