Quote:
Originally Posted by xXziroXx
Not too much to elaborate on. SQLite database is a huge total filesize decrease comparing to plain files, it's faster loading/altering of data, it's *A LOT* easier to find specific data across the entire table then searching through all files. And the biggest pro of them all: save one, that's right - ONE, file on your computer and your entire servers database is backed up.
I could most probably list a lot more reasons why SQLite is superior, but the above ones are the ones that convinced me.
|
So you would store all information that is important or used by all of your systems in one SQL database?
Do you only use SQL or some combo as Jerret described in his post?
Edit; What if you have a player that had it's player data glitched, and you need to restore their old values from the old SQL backup, what would you do then? Install a third party software to view the table wanted and then manually query a change in the current SQL DB with the old backup data? (Seeing as requestsql2() isn't working as far as I've seen)