Show Posts
1
Suggestions / SQLite?
« on: August 29, 2016, 02:10:20 pm »
I just randomly checked the webstats and it displayed:
Why is SvM still using SQLite when there are not only better, drastically better options available like MySQL? I'm not sure about the language this server is written in and depending on it, you could have used any other centralized database rather than an embedded one. Even if you're taking regular backups (assuming they're stored on the same machine), how you're going to recover it in case your entire hosting machine is somehow wiped away? It's entirely possible and it has happened before. I'd suggest moving to some other database since SQLite in today's world for anything like SvM is very risky.
Quote
Eeek! We couldn't connect to the sqlite database. Error: SQLSTATE[HY000] [14] unable to open database file
Why is SvM still using SQLite when there are not only better, drastically better options available like MySQL? I'm not sure about the language this server is written in and depending on it, you could have used any other centralized database rather than an embedded one. Even if you're taking regular backups (assuming they're stored on the same machine), how you're going to recover it in case your entire hosting machine is somehow wiped away? It's entirely possible and it has happened before. I'd suggest moving to some other database since SQLite in today's world for anything like SvM is very risky.
