Recency bias playing a factor here. But System.Data.SQLite. When you scan around the offerings of the other top-shelf languages, it becomes quickly evident how good/reliable that DLL is. Not to mention that it's maintained by he SQLite team. SQLite has been having a moment in the sun, and this is the perfect package to use it in production.

Thanks for sharing! Have you found any specific implementation patterns that work particularly well with it in production?

It's all gems if you use enough Ruby.

this one made me smile :)