> For example, a WordPress site built on MySQL can't be migrated into an SQLite powered WordPress using a common migration plugin. I know, because I tried.
Ok, didn't expect that response! I tried this today.
I admit I didn't try super hard- I have a lot of other things to work on, was a 20 minute curiosity mission. I just downloaded the zip file and grabbed the files out of that. Don't get me wrong- it worked- but I couldn't do an import as mentioned.
If you want lots of detail, I can spend more time on it. Email me at my hn user at the google mail.
Out of curiosity, how recently did you try?
We're using a new SQLite integration that seems to be pretty good at translating SQL to SQLite: https://github.com/WordPress/sqlite-database-integration
We'd be curious to learn more about how it failed. It's definitely an area we'd like to improve.