This is probably not news to a lot or most of you.. SQLite doesn’t work on medium trust hosting. The reason makes sense. The .Net assembly has to talk (p-invoke) to a native dll. That’s something you can’t do in a standard medium trust environment.
Why this matters – to me – is that we had plans to move some of the non-blog content of the web site to an embedded database. SQLite was the embedded db of choice, but it doesn’t matter which one. This would be a problem with most all embedded db’s; perhaps something like VistaDB would work. That would require a license though. It was intended to be a first step towards a touch of CMS, and would have been pretty easy using FluentMigrator and Fluent-NHibernate. That will have to be put on hold until a suitable approach is found. Or suggested by a reader!
-j