Thread: Why do you choose XML over SQL?

Page 1 of 11 123 ... LastLast
Results 1 to 10 of 108
  1. #1 Why do you choose XML over SQL? 
    Rune-Server Affiliate
    Genesis's Avatar
    Join Date
    Sep 2010
    Posts
    4,149
    Thanks given
    1,508
    Thanks received
    1,980
    Rep Power
    4944
    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
    Reply With Quote  
     

  2. Thankful user:


  3. #2  
    Respected Member


    George's Avatar
    Join Date
    Mar 2009
    Posts
    7,099
    Thanks given
    2,226
    Thanks received
    3,146
    Rep Power
    5000
    Personal preference on my side. (XML)
    Attached image

    Spoiler for Spoilers!:
    Attached image
    Attached image
    Attached image
    Attached image
    Reply With Quote  
     

  4. Thankful user:


  5. #3  
    Registered Member

    Join Date
    Dec 2012
    Posts
    2,999
    Thanks given
    894
    Thanks received
    921
    Rep Power
    2555
    I'd suggest using a rds as it comes with handy features such as queries etc which are useful in RSPS
    Attached image
    Reply With Quote  
     

  6. #4  
    Respected Member


    Join Date
    Jul 2015
    Posts
    781
    Thanks given
    206
    Thanks received
    394
    Rep Power
    524
    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.
    Reply With Quote  
     

  7. Thankful user:


  8. #5  
    we up

    Number 0's Avatar
    Join Date
    Apr 2012
    Posts
    533
    Thanks given
    107
    Thanks received
    161
    Rep Power
    224
    Just a little time consuming tbh
    Reply With Quote  
     

  9. #6  
    Respected Member


    George's Avatar
    Join Date
    Mar 2009
    Posts
    7,099
    Thanks given
    2,226
    Thanks received
    3,146
    Rep Power
    5000
    Quote Originally Posted by RileyM View Post
    as it's much lighter, easier to read, ease of parsing.
    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>
    Attached image

    Spoiler for Spoilers!:
    Attached image
    Attached image
    Attached image
    Attached image
    Reply With Quote  
     

  10. #7  
    Registered Member
    Join Date
    Apr 2016
    Posts
    124
    Thanks given
    14
    Thanks received
    21
    Rep Power
    37
    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
    Reply With Quote  
     

  11. Thankful user:


  12. #8  
    Registered Member

    Join Date
    Dec 2012
    Posts
    2,999
    Thanks given
    894
    Thanks received
    921
    Rep Power
    2555
    Quote Originally Posted by Idiot Bird View Post
    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>
    At the end of the day it's opinionated in terms of what looks prettier, but factually, XML is far more verbose
    Attached image
    Reply With Quote  
     

  13. Thankful users:


  14. #9 Why do you choose XML over SQL? 
    Respected Member


    Join Date
    Jul 2015
    Posts
    781
    Thanks given
    206
    Thanks received
    394
    Rep Power
    524
    Quote Originally Posted by Idiot Bird View Post
    I'm not sure whats so hard to read about; To me it seems much more friendly to the eye lol.

    Code:
    
    
    
    0
    General Store
    GENERAL_STORE
    995
    
    
    4151
    10
    
    
    892
    1000
    
    
    11802
    15
    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
    Reply With Quote  
     

  15. Thankful users:


  16. #10  
    Registered Member
    Join Date
    Jan 2012
    Posts
    176
    Thanks given
    110
    Thanks received
    33
    Rep Power
    43
    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.
    Reply With Quote  
     

  17. Thankful user:


Page 1 of 11 123 ... LastLast

Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Why do you bot?
    By Aeterna in forum RuneScape Underground
    Replies: 13
    Last Post: 11-22-2009, 06:56 PM
  2. Why do you hate delta?
    By Andys1841 in forum RS2 Server
    Replies: 32
    Last Post: 06-24-2009, 05:33 PM
  3. Why Do You Code?
    By Unstoppable in forum RS2 Server
    Replies: 31
    Last Post: 02-23-2009, 03:19 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •