If this requires turning off pragma synchronous, doesn't that disqualify it for anything but read only tasks? Power loss etc would corrupt the database...
But think about it as a library, you can build master-slave on top of it.
Which is basically what I did with https://redisql.com/ in the pro version exploiting Redis AOF