Thread: Why do you choose XML over SQL?

Page 10 of 11 FirstFirst ... 891011 LastLast
Results 91 to 100 of 108
  1. #91  
    Why do you choose XML over SQL?



    Scu11's Avatar
    Join Date
    Aug 2007
    Age
    30
    Posts
    16,307
    Thanks given
    7,215
    Thanks received
    12,308
    Rep Power
    5000
    Quote Originally Posted by OsFury View Post
    I don't use sql due to it relying on the website being up. When I was with trentahost, my website was down at least once/day and that could cause severe problems when you're trying to load data from it.
    you don't have to host the SQL database on a separate server from your game server whatsoever...

    Attached image
    Reply With Quote  
     

  2. Thankful users:


  3. #92  
    Registered Member
    Freezia's Avatar
    Join Date
    Feb 2011
    Posts
    6,013
    Thanks given
    1,147
    Thanks received
    758
    Rep Power
    1311
    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...

    Quote Originally Posted by Scu11 View Post
    you don't have to host the SQL database on a separate server from your game server whatsoever...


    Host your RUNESCAPE PRIVATE SERVER on the cheapest and flagship provider on Rune-Server! Now equipped with DDOS Protection!.


    Reply With Quote  
     

  4. #93  
    Registered Member

    Join Date
    Dec 2009
    Posts
    774
    Thanks given
    367
    Thanks received
    455
    Rep Power
    927
    Binary always number one, but that's my personal opinion I guess.
    link removed
    Reply With Quote  
     

  5. #94  
    SERGEANT OF THE MASTER SERGEANTS MOST IMPORTANT PERSON OF EXTREME SERGEANTS TO THE MAX!

    cube's Avatar
    Join Date
    Jun 2007
    Posts
    8,871
    Thanks given
    1,854
    Thanks received
    4,745
    Rep Power
    5000
    Quote Originally Posted by Admiral Slee View Post
    Binary always number one, but that's my personal opinion I guess.
    Strongest downside is probably its inflexibility, hard or impossible to do migrations efficiently

    Attached image

    Reply With Quote  
     

  6. Thankful users:


  7. #95  
    Registered Member

    Join Date
    Jan 2013
    Posts
    364
    Thanks given
    14
    Thanks received
    324
    Rep Power
    548
    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).
    Reply With Quote  
     

  8. #96  
    ???

    funkE's Avatar
    Join Date
    Feb 2008
    Posts
    2,612
    Thanks given
    255
    Thanks received
    989
    Rep Power
    1366
    Quote Originally Posted by ThePalidino View Post
    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 sure what you mean by the terms you use, but if you're talking about master/slave replication, that's what you call it. not sure what you mean by realtime and local.
    .
    Reply With Quote  
     

  9. #97  
    Why do you choose XML over SQL?



    Scu11's Avatar
    Join Date
    Aug 2007
    Age
    30
    Posts
    16,307
    Thanks given
    7,215
    Thanks received
    12,308
    Rep Power
    5000
    Quote Originally Posted by ThePalidino View Post
    Either you'll have to update a local and realtime database whenever you make changes
    not true, look up database migrations. popular solutions include flyway & liquibase


    Quote Originally Posted by ThePalidino View Post
    or update one single one and pray your database is never compromised.
    why would you need to pray for this, you'd be doing routine backups (which you should be doing regardless of using an RDBMS)


    Quote Originally Posted by ThePalidino View Post
    If my database were to be cleared right now, I would have 100% up-to-date definition files sitting here on my local machine.
    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


    Quote Originally Posted by ThePalidino View Post
    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,
    see answer above re: db migrations


    Quote Originally Posted by ThePalidino View Post
    but then that's something I'd have to learn how to do
    if you already know how to write SQL then you already know how to write database migrations


    Quote Originally Posted by ThePalidino View Post
    opposed to handling definitions through XML
    yuck, xml is not meant for human consumption. at least resort to something bareable like JSON, YAML, or TOML


    Quote Originally Posted by ThePalidino View Post
    and just uploading the file changes when I do a server update
    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.


    Quote Originally Posted by ThePalidino View Post
    (updating all the files takes under 5 minutes, simple zip, upload, unzip, done).
    am i misinterpreting or are you implying that your your delivery system really relies on you manually zipping/unzipping a bunch of files?

    Attached image
    Reply With Quote  
     

  10. #98  
    Registered Member
    Join Date
    Jul 2017
    Posts
    15
    Thanks given
    0
    Thanks received
    2
    Rep Power
    17
    MySQL is superior.
    Reply With Quote  
     

  11. #99  
    Extreme Donator


    Join Date
    Oct 2010
    Posts
    2,853
    Thanks given
    1,213
    Thanks received
    1,622
    Rep Power
    5000
    SQL everyday lol, it's just so flexible and easy to manage
    Reply With Quote  
     

  12. #100  
    Registered Member
    Join Date
    Jul 2017
    Posts
    15
    Thanks given
    0
    Thanks received
    2
    Rep Power
    17
    Quote Originally Posted by Professor Oak View Post
    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!
    Reply With Quote  
     

Page 10 of 11 FirstFirst ... 891011 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
  •