Is SQL Server Compact Edition a sensible alternative to SQLite?

Question

What are the differences, other than a file size restriction in SQL Server Compact, and Windows only usage?

Answer 1

I've found a couple of questions and some blog posts relating to this. A small comparison of their memory usage can be found here.