|
Title, very curious why the majority of people choose storing data via .txt or XML over using an relational database management system such as MySQL or PostgreSQL. Is it just a preference, or are there any personal benefits choosing it over a RDBMS.
Didn't really want to make a thread but my curiosity kills me
I'd suggest using a rds as it comes with handy features such as queries etc which are useful in RSPS
Prefer JSON over XML for definitions and such as it's much lighter, easier to read, ease of parsing.
But overall using a rds like MySQL would be a better alternative to store data (obviously). Saves so much time / processes to just submit a query, instead of having to open a file, alter, save. However in general I think this isn't utilized in servers due to the overhead associated with setting up such database, configuring secure connections, and most basic users being unfamiliar.
Just a little time consuming tbh
I'm not sure whats so hard to read about; To me it seems much more friendly to the eye lol.
Code:<list> <shop> <!-- General store --> <id>0</id> <name>General Store</name> <shopType>GENERAL_STORE</shopType> <currency>995</currency> <items> <item> <id>4151</id> <amount>10</amount> </item> <item> <id>892</id> <amount>1000</amount> </item> <item> <id>11802</id> <amount>15</amount> </item> </items> </shop> </list>
To answer the question, it's because most users here lack the understanding of threads in general. You can see users asking "Why does my server lag when players claim votes?".
All I can say is that most, if not all, "big" servers do use some sort of database to store some sort of data, whether it's SQL or NoSQL. While small servers and (most) projects use flat file storage
XML has a lot more markup / redundancy. Although it's all open to opinion in my eyes JSON is much simpler to glance at and see the key / value.
Plus the ease of use when using JSON in web applications compared to xml parsing. A simple AJAX request page will show you the overhead difference between the two.
At the end of the day, they both have their own advantages.
Sent from my iPhone using Tapatalk
Most people here lack the skill to set up a proper DB system, flat file storage is what comes with most servers. Plus depending on your host you'll probably end up paying extra for remote connections. Added to that most players cap at what 50 players, so at that level a DB seems somewhat pointless.
« Previous Thread | Next Thread » |
Thread Information |
Users Browsing this ThreadThere are currently 1 users browsing this thread. (0 members and 1 guests) |