WordPress should be on SQLite by default. Most installations run only on one sever and are rather small (less than a few GB database size). And not a lot of inserts/updates to the DB.
In those cases SQLite will probably have much better speed and a lower memory footprint.
In those cases SQLite will probably have much better speed and a lower memory footprint.