MariaDB Sqlite swapping drawbacks and caveats

I’m considering dropping sqlite, cause it isn’t reliable IMHO and it’s proved it dying at the second time.

The page with instructions riddled with “don’t do it, everything tested and optimized solely for sqlite”.

Could you tell me the real experience with the swap? Maybe not with Maria, anything from the supported list will do better.

Also, out of curiosity, does anybody know why it’s a primary DB, as a software developer I’m really puzzled about possible reasons?

Up, it is still an important decision to make.**