Yep I like to think of sqlite as being to relational databases as memcache is to caches. Both are super simple and straightforward, with a minimum of moving parts, and yet does something really well. You can start with each, and then later evolve into something more featureful. But often you'll not need to!