We used it for a while, and when we started running into locking and performance issues, we upgraded to Postgres. It was pretty great while it lasted though.

We still use it for a bunch of internal apps, which we've mostly forgotten about since it keeps on trucking.

Personally, I love SQLite, and I still use it for crunching data when a CSV/spreadsheet will be too complicated.