I installed sqlite3, and configured mt-daapd with both –enable-sqlite and –enable-sqlite3. I set the db_type to be sqlite3 and deleted the old database. Fired up mt-daapd and everything’s a go. I re-added my smart playlists and they worked great as well. I can’t really tell what sqlite3 is doing for me that sqlite2 wasn’t, but either way, it’s working and seems stable enough (I haven’t stress tested it or anything).
Yeah, me neither. 🙂 I hoped there would be a magical performance boost, but no, damn it. 🙂
I guess the biggest thing is that the db stuff isn’t dependant on one specific kind of database — in theory, it would be easy to make a postgres backend, or a mysql backend, or (dare I say it) a gdbm database (again).