I've been playing with PHP 5's SQLite capabilities with what may eventually become Thorn 2, and I gotta say I'm really liking it. Just the ability to instantly get all multiple-row results as a two-dimensional array (sqlite_array_query) instead of having to loop and build your own array makes for so much cleaner code. And the fact that it's much easier for both me and the end user to work with -- they don't have to set up databases and type in usernames and passwords -- is a huge incentive to really never use MySQL again for small-ish projects like this. (Instead of connecting to a server, SQLite just keeps its data in a single file which can be stored anywhere.)

Anyone else done any playing with SQLite? Your thoughts?