|
Many people don't know that; we always recommend they host locally on the same server as then they can just use localhost instead of having the high delay via a remote webserver MYSQL. the second issue that arises is the security; a simple XAMPP MYSQL or Local database must be secured...
Binary always number one, but that's my personal opinion I guess.
If we're talking all kinds of content, convenience. For example I wouldn't want to deal with item and npc definitions through SQL. Either you'll have to update a local and realtime database whenever you make changes, or update one single one and pray your database is never compromised. If my database were to be cleared right now, I would have 100% up-to-date definition files sitting here on my local machine. I imagine there would be a way to set something up to where when you modify you local database the changes are automatically passed over to the realtime database, but then that's something I'd have to learn how to do opposed to handling definitions through XML and just uploading the file changes when I do a server update (updating all the files takes under 5 minutes, simple zip, upload, unzip, done).
not true, look up database migrations. popular solutions include flyway & liquibase
why would you need to pray for this, you'd be doing routine backups (which you should be doing regardless of using an RDBMS)
you can't attribute that to your usage of flat files, it's a result of you having the data stored elsewhere - which is a practice you should be applying to both flat files and databases
see answer above re: db migrations
if you already know how to write SQL then you already know how to write database migrations
yuck, xml is not meant for human consumption. at least resort to something bareable like JSON, YAML, or TOML
benefit you get from using an RDBMS in the situation you've outlined here is that you wouldn't need to restart anything or interrupt any of your players.
am i misinterpreting or are you implying that your your delivery system really relies on you manually zipping/unzipping a bunch of files?
MySQL is superior.
SQL everyday lol, it's just so flexible and easy to manage
What do you think about this?
Have the server check "MySQL version" of a table. If the servers data != the MySQL version, it'll load the MySQL data into memory and output it to the Json. If the server data is the same as the MySQL version, no updating needs to be done so load the Json files. Obviously you're not going to do this with Player data but rather ObjectLocations, ObjectDefinitions and things of that nature. Yea sure it could be considered redundant but it's worth the saved startup time with getting the server back online!
« Previous Thread | Next Thread » |
Thread Information |
Users Browsing this ThreadThere are currently 1 users browsing this thread. (0 members and 1 guests) |