Yesterday afternoon, I was talking with one of my co-workers, Michael. I was yammering on about how much I liked SQLite for unit testing and how much faster in-process databases engines were for applications that didn't need all the features of relational databases.

Then he mentioned SQL Server Everywhere Edition. It's in process, light weight (the same configuration as what runs on Windows Mobile), and free to distribute. I don't think it supports views or stored procs (installing it now, so I might edit this later) but I avoid those types of database dependencies anyway.

SQL Server Everywhere Edition sounds exciting for a number of reasons.