Is SQL Server Compact Edition a sensible alternative to SQLite?

What are the differences, other than a file size restriction in SQL Server Compact, and 开发者_JAVA技巧Windows only usage?

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.