I think you're wrong there. SQLite is a really well tested and (as far as I'm concerned) doesn't fall into the "hacky" category. It works really well for what it was designed to do. However, if you need to use it outside of its intended scope, I agree, it may not be a good fit. They even have a page where they describe where it might be a good fit vs using a RDBMS:
http://www.sqlite.org/whentouse.html Hi, Paul,
You may want to check out other forums that discuss Sqlite and concurrency...whereas the link you referenced discourages high concurrency environments, there are reports even in the last few months of errors occuring with smaller concurrency situations and multithreaded situations.
I agree, it would seem to be a fine solution for other situations they mention.